php connection with mysql database

Need help installing PHP, configuring a script, or configuring a server? Then come on in and post your questions! We'll try to help the best we can!

Moderator: General Moderators

Post Reply
izzul_apit
Forum Newbie
Posts: 3
Joined: Mon Nov 16, 2009 1:33 am

php connection with mysql database

Post by izzul_apit »

i am beginner in php,i just want to ask

how to connect php and mysql server.i had install php 5.2.11,mysql sever 5.1 and mysql administrator 5.1.40.i using IIS version 5.1 and windows xp sp2.when i try to connect mysql and php,error was display.an error sound like that "Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\wwwroot\test.php on line 7".
my coding is:-
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

// some code
?>


for information i was tried many times to solve this matter.could anyone help me ?...please.
Last edited by califdon on Mon Nov 16, 2009 11:24 pm, edited 1 time in total.
Reason: Moved to Installation and Configuration forum
User avatar
akuji36
Forum Contributor
Posts: 190
Joined: Tue Oct 14, 2008 9:53 am
Location: Hartford, Connecticut

Re: php connection with mysql database

Post by akuji36 »

connection by mysql with php

Code: Select all

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("my_db", $con);
 
$result = mysql_query("SELECT * FROM Persons");
 
while($row = mysql_fetch_array($result))
  {
  echo $row['FirstName'] . " " . $row['LastName'];
  echo "<br />";
  }
 
mysql_close($con);
?>
Person is the table name
field names = FirstName And LastName

database name = my_db

above code when modified will give you your db data

thanks

Rod
User avatar
iankent
Forum Contributor
Posts: 333
Joined: Mon Nov 16, 2009 4:23 pm
Location: Wales, United Kingdom

Re: php connection with mysql database

Post by iankent »

izzul_apit wrote:Fatal error: Call to undefined function mysql_connect()
that bit would make me think that PHPs mysql extension isn't enabled - check your php.ini file and make sure there's no semi-colon before this line:
extension=php_mysql_libmysql.dll

hth

edit: you'll probably need to restart IIS once if you change php.ini
izzul_apit
Forum Newbie
Posts: 3
Joined: Mon Nov 16, 2009 1:33 am

Re: php connection with mysql database

Post by izzul_apit »

it`s that u mine:-

....................................................................................................................................................................

;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
;
; If you wish to have an extension loaded automatically, use the following
; syntax:
;
; extension=modulename.extension
;
; For example, on Windows:
;
; extension=msql.dll
;
; ... or under UNIX:
;
; extension=msql.so
;
; Note that it should be the name of the module only; no directory information
; needs to go here. Specify the location of the extension with the
; extension_dir directive above.


; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.

;extension=php_bz2.dll
;extension=php_curl.dll
extension=php_dba.dll
extension=php_dbase.dll
;extension=php_exif.dll
;extension=php_fdf.dll
extension=php_gd2.dll
extension=php_gettext.dll
;extension=php_gmp.dll
;extension=php_ifx.dll
extension=php_imap.dll
;extension=php_interbase.dll
extension=php_ldap.dll
extension=php_mbstring.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
extension=php_msql.dll
extension=php_mssql.dll
extension=php_mysql.dll
extension=php_mysqli.dll
;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_pdo.dll
;extension=php_pdo_firebird.dll
;extension=php_pdo_mssql.dll
;extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
;extension=php_pdo_oci8.dll
;extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
;extension=php_pdo_sqlite.dll
extension=php_pgsql.dll
;extension=php_pspell.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_soap.dll
extension=php_sockets.dll
;extension=php_sqlite.dll
;extension=php_sybase_ct.dll
;extension=php_tidy.dll
extension=php_xmlrpc.dll
extension=php_xsl.dll
extension=php_zip.dll


....................................................................................................................................................................

it`s that i have done,please check.thanks for advice,iankent.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: php connection with mysql database

Post by califdon »

Your configuration file tells PHP to use a file named php_mysql.dll. The first thing to check is whether you have a file with that name. If you don't, that explains why it doesn't recognize the command mysql_connect. The other thing, as it says in the instructions, is make sure you set the extension_dir directive to the folder in which all these .dll files are located. Otherwise, PHP will not be able to find them.
izzul_apit
Forum Newbie
Posts: 3
Joined: Mon Nov 16, 2009 1:33 am

Re: php connection with mysql database

Post by izzul_apit »

califdon,thanks you

i will try............. 8O
Post Reply