[RESOLVED] Kinda beginner can you help..?

[BlueGemini]

I'm testing out if my PHP is working along with MySQL. I used this script for test

<?php
$user="root";
$password="";
$database="test";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";
mysql_query($query);
mysql_close();
?>

The code works but theirs message like this appeared:
PHP Notice: Use of undefined constant localhost - assumed 'localhost' in C:\Inetpub\wwwroot\index.php on line 12

Was there something wrong with the script or my PHP's configuration?

[scross]

Firstly, don't create two topics for the same problem. Secondly, the problem is that have missed out the quotes that should be placed around localhost in your code to make it a string. Change:

mysql_connect(localhost,$user,$password);

to:

mysql_connect('localhost',$user,$password);

and it should work.

[bradgrafelman]

In other words, since localhost isn't a constant (e.g. one that is built-in to PHP or one that you've [man]define/man'ed), it must be a [man]string[/man], and strings are (almost always) delimited by quotes in PHP.

[BlueGemini]

scross wrote:

Firstly, don't create two topics for the same problem. Secondly, the problem is that have missed out the quotes that should be placed around localhost in your code to make it a string. Change:

mysql_connect(localhost,$user,$password);

to:

mysql_connect('localhost',$user,$password);

and it should work.

Still didn't work. it gave a new error message,

PHP Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\wwwroot\create.php on line 10

[jkurrle]

sounds like PHP wasn't compiled with the "--with-mysql" switch. If you run the following PHP command: "phpinfo(); " it should display all your PHP operating parameters. Look at the first section at the line listed as "Configure Command" and see if "--with-mysql" is in there. Also, you can see if there's a "mysql" section as well. That's the first place I'd look.

[BlueGemini]

jkurrle wrote:

sounds like PHP wasn't compiled with the "--with-mysql" switch. If you run the following PHP command: "phpinfo(); " it should display all your PHP operating parameters. Look at the first section at the line listed as "Configure Command" and see if "--with-mysql" is in there. Also, you can see if there's a "mysql" section as well. That's the first place I'd look.

Nah! There's no such with it... this is what it display in mine...

cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared"

[jkurrle]

You will need to recompile your PHP. I believe the windows version has MySQL support enabled by default, but unix/linux versions you have to specify it. If you can, I'd go to the directory you compiled PHP from and rerun the ./configure with the added --with-mysql switch. Then make, make test, then make install. That's my best guess...

[BlueGemini]

jkurrle wrote:

You will need to recompile your PHP. I believe the windows version has MySQL support enabled by default, but unix/linux versions you have to specify it. If you can, I'd go to the directory you compiled PHP from and rerun the ./configure with the added --with-mysql switch. Then make, make test, then make install. That's my best guess...

I think I'm not yet familiar with that... how do I do that.. 😕

Sorry, not yet that good in PHP especially when configuring it :p

[jkurrle]

Well, let's start out with some basic questions.

1) What type of operating system are you installing on? Windows? Linux?
2) What type of web server are you using? Apache? IIS?
3) How was PHP originally installed? Did it come preinstalled into your Linux distro? Did you originally install it or did someone else?
4) Are you sure mysql is installed and running?

Let's start from there and see where we need to go...

[BlueGemini]

jkurrle wrote:

Well, let's start out with some basic questions.

1) What type of operating system are you installing on? Windows? Linux?
2) What type of web server are you using? Apache? IIS?
3) How was PHP originally installed? Did it come preinstalled into your Linux distro? Did you originally install it or did someone else?
4) Are you sure mysql is installed and running?

Let's start from there and see where we need go go...

Ok...

1) I'm using Windows XP
2) I'm using the default server of Windows, which is the IIS.
3) I actually installed using the installer (not the zip one) from php.net
4) I also installed MySql 5. I think its working (since i can use it with phpMyAdmin) but I'm not sure if I got it right or maybe I left something...

Thanks for everything! 🙂

[jkurrle]

I believe with the windows version of PHP, you have to do an advanced install and tell it to use the mysql module. It's odd though, as the windows version should have chosen the mysql module by default.

[scross]

Find your php.ini file (if you don't know where it is, run phpinfo() and look for the "Configuration File (php.ini) Path", it should be just about at the top of the page) and uncomment the following line (by removing the starting semi-colon):

;extension=php_mysql.dll

You will then need to restart your server and you should see the changes. Mind you I've only ever used Apache on Windows so I'm unsure whether using IIS would make a difference. Nevertheless try it.

[BlueGemini]

scross wrote:

Find your php.ini file (if you don't know where it is, run phpinfo() and look for the "Configuration File (php.ini) Path", it should be just about at the top of the page) and uncomment the following line (by removing the starting semi-colon):

;extension=php_mysql.dll

You will then need to restart your server and you should see the changes. Mind you I've only ever used Apache on Windows so I'm unsure whether using IIS would make a difference. Nevertheless try it.

I already did that...

I actually uncommented both php_mysql.dll & php_msqli.dll. Is that alright?

[bradgrafelman]

Moved thread to Install forum.

1. [man]MySQL[/man] and [man]MySQLi[/man] are two different extensions. The MySQL extension has been deprecated in favor of MySQLi, so I would recommend you either switch to that extension or even [man]PDO[/man] (which allows prepared queries that automatically escape data for you). Since your question is about MySQL, however, I'll continue on with my post as if you have ignored this recommendation and still want to use the deprecated MySQL extension...

2. Where is the php.ini file that you modified? Is this the same file referenced in the "Loaded Configuration File" field (not "Configuration File (php.ini) Path") in phpinfo() ?

3. Is the extension_dir directive properly set in your php.ini to the directory with the php_*.dll extension modules? Does phpinfo() show the correct path?j

4. Do you see php_mysql.dll in this extension directory?

5. Do you see libmysql.dll in the main directory of PHP (e.g. c:\php\ for me)?

6. Did you ensure that the main PHP directory was added to your system's PATH environment variable? Easy way to do this is to open a command prompt (start menu -> run -> cmd) and type in path and hit enter; you should see the PHP directory listed (again, c:\php for me) somewhere in the list of paths. If not, you need to add it - instructions for this can be found in the sticky in this forum.

[BlueGemini]

bradgrafelman wrote:

Moved thread to Install forum.

1. [man]MySQL[/man] and [man]MySQLi[/man] are two different extensions. The MySQL extension has been deprecated in favor of MySQLi, so I would recommend you either switch to that extension or even [man]PDO[/man] (which allows prepared queries that automatically escape data for you). Since your question is about MySQL, however, I'll continue on with my post as if you have ignored this recommendation and still want to use the deprecated MySQL extension...

2. Where is the php.ini file that you modified? Is this the same file referenced in the "Loaded Configuration File" field (not "Configuration File (php.ini) Path") in phpinfo() ?

3. Is the extension_dir directive properly set in your php.ini to the directory with the php_*.dll extension modules? Does phpinfo() show the correct path?j

4. Do you see php_mysql.dll in this extension directory?

5. Do you see libmysql.dll in the main directory of PHP (e.g. c:\php\ for me)?

6. Did you ensure that the main PHP directory was added to your system's PATH environment variable? Easy way to do this is to open a command prompt (start menu -> run -> cmd) and type in path and hit enter; you should see the PHP directory listed (again, c:\php for me) somewhere in the list of paths. If not, you need to add it - instructions for this can be found in the sticky in this forum.

I check all of them and they're all correct...

Well, I think whatever I encounter doesn't really matter since my PHP is working anyway...

Thanks for everything! 🙂