[PHP] Re: [PHP-DB] PHP/Mysql
Fatal error: Call to undefined function: mysql_connect() means to things. php is not built with integrated mysql support, or php cannot find php_mysql.so on your comp. What is the value of php.ini variable include_path or something similar. Regards, Andrey Hristov - Original Message - From: "Riccardi Moreno" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 30, 2001 5:21 PM Subject: [PHP-DB] PHP/Mysql > Hello, > I've got cobalt raq4 with php(work) and mysql(work) but when I try to > connect via mysql_connect() this error happens: > Fatal error: Call to undefined function: mysql_connect() > This is my php.ini: > [MySQL] > mysql.allow_persistent = On ; allow or prevent persistent link > mysql.max_persistent= -1 ; maximum number of persistent > links. -1 means no limit > mysql.max_links = -1 ; maximum number of links > (persistent+non persistent). -1 means no > mysql.default_port = ; default port number for > mysql_connect(). If unset, > ; > mysql_connect() will use the $MYSQL_TCP_PORT, or > ; entry in > /etc/services, or the compile-time defin > ; (in that > order). Win32 will only look at MYSQL_P > mysql.default_host = ; default host for > mysql_connect() (doesn't apply in safe mode) > mysql.default_user = ; default user for > mysql_connect() (doesn't apply in safe mode) > mysql.default_password = ; default password for > mysql_connect() (doesn't apply in safe mode) > ; Note that > this is generally a *bad* idea to store > ; in this > file. *Any* user with PHP access can run > ; 'echo > cfg_get_var("mysql.default_password")' and > ; password! > And of course, any users with read acc > ; file will > be able to reveal the password as well. > And this is my httpd.conf: > # Extra Modules > #LoadModule php_module > #LoadModule php3_modul > LoadModule php4_module > > # because mod_perl lea > #LoadModule perl_modul > > # make sure that this > LoadModule ssl_module > > # Reconstruction of t > # (static and shared > # [WHENEVER YOU CHANG > #ClearModuleList > > # Extra Modules > AddModule mod_php4.c > #AddModule mod_php.c > #AddModule mod_php3.c > #AddModule mod_perl.c > #AddModule mod_casp2.c > I thing that it's all ok but it doesn't work. > Any Ideas? > Hi > > > > - Moreno Riccardi > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: [PHP-DB] PHP/Mysql
> > Hello, > > I've got cobalt raq4 with php(work) and mysql(work) but when I try to > > connect via mysql_connect() this error happens: > > Fatal error: Call to undefined function: mysql_connect() > > This is my php.ini: > > I thing that it's all ok but it doesn't work. > > Any Ideas? > > Hi > > > > > > > > - Moreno Riccardi > > > > > > Moreno- If you just updated to PHP 4.0.6 on a Raq you need to add 'extension=mysql.so' to /etc/httpd/php.ini -- P -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: [PHP-DB] PHP/Mysql
> > Hello, > > I've got cobalt raq4 with php(work) and mysql(work) but when I try to > > connect via mysql_connect() this error happens: > > Fatal error: Call to undefined function: mysql_connect() > > This is my php.ini: > > I thing that it's all ok but it doesn't work. > > Any Ideas? > > Hi > > > > > > > > - Moreno Riccardi > > > > > > Moreno- If you just updated to PHP 4.0.6 on a Raq you need to add 'extension=mysql.so' to /etc/httpd/php.ini -- P -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: [PHP-DB] PHP/MySQL Question
Look at the MySQL manual that came along with it when you downloaded it: manual.html#String_comparison_functions or manual.html#Comparison_Operators May be that helps you. René www.comunica2.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: [PHP-DB] PHP/MySql - address book
The answer to your question is the relational model of databases. So instead of one big table, you have to use 2. Say first table is employee and the second - companies. in the employee we have some fields and one of them is company_id, this id corresponds to a single row in the companies table. companies table contains several fields nut one of them is company_id. company_id is a foreign key (the link you ask). How to get all employees from single company: select employee.* from employee,companies where employee.company_id=companies.company_id and companies.company_name='Some Ltd. Inc.'; or better select employee.* from employee left join companies using(company_id) where company_name='Some Ltd Inc.'; I do not have links to literature about relational model but I remember that on www.phpbuilder.com there is/are some info on it.I think from y.2000. Regards, Andrey Hristov Andrey Hristov Web Developer - Original Message - From: "sg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, January 06, 2002 7:26 PM Subject: [PHP-DB] PHP/MySql - address book > Hi, > > I'm trying to do a sort of address book where I'd put all information about > anybody or any company from which I receive informtation (friend, people > from work, hotels, places...) > > An entry starts with a name, then I can have any type of information. The > table I'm using has a lot of fields, but I display via PHP only those that > are not empty. > > I'm now facing a problem many must have already faced. A lot of people work > for the same company, and I'd like to have a separate table or storage area > to put that data, so that I don't have to write the same company addresse > twice, and if that information changes, I won't have to go through ten or > twenty people's entries to modify it. > > So how would I link a company's information to a person's entry? > > I know it may sound easy or ridiculous a question, but though I know HTML > very well I'm still a beginner (learning on my own) et PHP and MySql. > > So far I have a neat rendering of the database I've created, but I feel I > should look further into DB use. > > Software I'm using: > > EasyPHP (latest version) > PHP 4 > MySql > PhpMyAdmin > > on Windows Me > > Main question, I repeat is : how would I link a company's information to a > person's entry? > > Cheers > > Sébastien > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] RE: [PHP-DB] PHP, MySQL and XML
http://freshmeat.net/projects/exist/ -Original Message- From: Thor M. Steindorsson [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 5:57 PM To: php-general; php-db Subject: [PHP-DB] PHP, MySQL and XML Does anyone have a solution for importing data from a RDF-XML file into a MySQL database? I've been racking my brain, as well as looking at tutorials and some xml parsers, but if someone has something like this it would save me tons of time. Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: [PHP-DB] php+mysql simple query help me pls! ty.
yes, i forgot something, this = mysql_select_db("mydb",$db); i did not specify my db name. thanks :) louie - Original Message - From: "Rick Emery" <[EMAIL PROTECTED]> To: "'louie miranda'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, January 04, 2002 4:06 AM Subject: RE: [PHP-DB] php+mysql simple query help me pls! ty. > Test the mysql_query() return value: > $result = mysql_query("SELECT * FROM members") or > die("Error:".mysql_error()); > > there may be an error in your query. > > -Original Message- > From: louie miranda [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 03, 2002 1:59 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: [PHP-DB] php+mysql simple query help me pls! ty. > > > Hi, can someone help me here! :( > I can't query the data on my sql from php. > db is fine, i couldnt see the prob in php! > pls help, ty. > > > > # MSQL ### > mysql> desc members; > +--+-+--+-+-++ > | Field| Type| Null | Key | Default | Extra | > +--+-+--+-+-++ > | id | tinyint(5) | | PRI | NULL| auto_increment | > | ircname | varchar(30) | YES | | NULL|| > | email| varchar(30) | YES | | NULL|| > | realname | varchar(40) | YES | | NULL|| > | asl | varchar(30) | YES | | NULL|| > | info | varchar(70) | YES | | NULL|| > +--+-+--+-+-++ > > > > # PHP > > > > > $db = mysql_connect("my_db_host", "my_db_user", "my_db_pass") > or die("Could not connect"); > > mysql_select_db("mydb",$db); > > $result = mysql_query("SELECT * FROM members",$db); > > printf("ircname: %sn", mysql_result($result,0,"ircname")); > printf("email: %sn", mysql_result($result,0,"email")); > printf("realname: %sn", mysql_result($result,0,"realname")); > printf("asl: %sn", mysql_result($result,0,"asl")); > printf("info: %sn", mysql_result($result,0,"info")); > > ?> > > > > > > # ERROR > > > Warning: Supplied argument is not a valid MySQL result resource in > /mnt/host-users/cavite/irc/members/t2.php on line 13 > ircname: > n > Warning: Supplied argument is not a valid MySQL result resource in > /mnt/host-users/cavite/irc/members/t2.php on line 14 > email: > n > Warning: Supplied argument is not a valid MySQL result resource in > /mnt/host-users/cavite/irc/members/t2.php on line 15 > realname: > n > Warning: Supplied argument is not a valid MySQL result resource in > /mnt/host-users/cavite/irc/members/t2.php on line 16 > asl: > n > Warning: Supplied argument is not a valid MySQL result resource in > /mnt/host-users/cavite/irc/members/t2.php on line 17 > info: > n > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] RE: [PHP-DB] php+mysql simple query help me pls! ty.
Test the mysql_query() return value: $result = mysql_query("SELECT * FROM members") or die("Error:".mysql_error()); there may be an error in your query. -Original Message- From: louie miranda [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 1:59 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [PHP-DB] php+mysql simple query help me pls! ty. Hi, can someone help me here! :( I can't query the data on my sql from php. db is fine, i couldnt see the prob in php! pls help, ty. # MSQL ### mysql> desc members; +--+-+--+-+-++ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-++ | id | tinyint(5) | | PRI | NULL| auto_increment | | ircname | varchar(30) | YES | | NULL|| | email| varchar(30) | YES | | NULL|| | realname | varchar(40) | YES | | NULL|| | asl | varchar(30) | YES | | NULL|| | info | varchar(70) | YES | | NULL|| +--+-+--+-+-++ # PHP n", mysql_result($result,0,"ircname")); printf("email: %sn", mysql_result($result,0,"email")); printf("realname: %sn", mysql_result($result,0,"realname")); printf("asl: %sn", mysql_result($result,0,"asl")); printf("info: %sn", mysql_result($result,0,"info")); ?> # ERROR Warning: Supplied argument is not a valid MySQL result resource in /mnt/host-users/cavite/irc/members/t2.php on line 13 ircname: n Warning: Supplied argument is not a valid MySQL result resource in /mnt/host-users/cavite/irc/members/t2.php on line 14 email: n Warning: Supplied argument is not a valid MySQL result resource in /mnt/host-users/cavite/irc/members/t2.php on line 15 realname: n Warning: Supplied argument is not a valid MySQL result resource in /mnt/host-users/cavite/irc/members/t2.php on line 16 asl: n Warning: Supplied argument is not a valid MySQL result resource in /mnt/host-users/cavite/irc/members/t2.php on line 17 info: n -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]