I trying to configure PHP to run MYSQL and it isn't working. I've spend many hours trying to figure this out. I've made changes to the php.ini file and the httpd.conf file and it no longer gives me an error, but it still doesn't connect to the database. It gets to right before the mysql_connect statement where it says "about to connect", and then instead of the error message, I get nothing. It just sits there. -
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
-
-
<html>
-
<head>
-
<title>Insert to Database</title>
-
</head>
-
<body>
-
-
-
<?php
-
-
$username = "root";
-
$password = "krustyrules";
-
$database = "mysql";
-
-
echo 'about to connect';
-
-
$link = mysql_connect("localhost:3306",$username,$password);
-
-
if(!$link) {
-
die('Could not connect: ' . mysql_error());
-
}
-
echo 'Connected Successfully';
-
mysql_select_db($database) or die( "Unable to select database");
-
-
$firstname = $_POST["fname"];
-
$lastname = $_POST["lname"];
-
$emailadd = $_POST["email"];
-
-
$query = "INSERT INTO contacts VALUES ('',$firstname, $lastname, $emailadd)";
-
-
mysql_query($query);
-
-
mysql_close($link);
-
-
?><br />
-
You are <?php echo $_POST["fname"]; ?>.<br/>
-
-
</body>
-
</html>
-
-
11  1671  Atli 5,058
Expert 4TB
Have you checked the output of the phpinfo() function for the MySQL info?
yes nothing there. could it be because I have windows XP and the phpinfo says I have windows NT???
Atli 5,058
Expert 4TB
No, Windows XP uses the NT kernel, so that's all normal.
Make sure you've done all the following: - Remove the ; from the line ';extension=php_mysql.dll' in php.ini
- Add the file 'libmysql.dll', from your PHP root dir, to the PATH enviroment variable. Or just copy the file to your windows directory.
- Restart the apache server.
If thats all complete MySQL should work.
it still doesn't work......any suggestions?
Atli 5,058
Expert 4TB
Are you sure the MySQL server is running ok?
You can also try to follow the three steppes I posted earlyer, but this time add the line, 'extension=php_mysqli.dll' and copyt the file 'libmysqli.dll' to your windows dir.
i've tried the three previous steps before, they didn't work. could it have anything to do with apache? when i test apache i get the screen "It works!", is that right or should i get the other screen?
Atli 5,058
Expert 4TB
That is the default screen apache puts up when it has been successfully installed. The apache setup should not have anything to do with MySQL. MySQL is loaded by PHP.
Try to following code and see what happens. -
<?php
-
echo mysql_connect("localhost", "root", "YOURPWHERE");
-
?>
-
If MySQL works, this should print "resource# 1", or something similar. Else, is should print a message telling you that the mysql_connect function is invalid.
If something else happens, it is likely that the PHP connection to MySQL works, but that there is a problem with the MySQL server itself.
In any case, copy the output and show us.
It shows a blank screen and "done" in the status bar. nothing on the screen at all. I have MySQL Administrator on and it says that MySQL server is running. I also print out the phpinfo page and there is nothing with MySQL on there either.
That is the default screen apache puts up when it has been successfully installed. The apache setup should not have anything to do with MySQL. MySQL is loaded by PHP.
Try to following code and see what happens.
-
<?php
-
echo mysql_connect("localhost", "root", "YOURPWHERE");
-
?>
-
If MySQL works, this should print "resource# 1", or something similar. Else, is should print a message telling you that the mysql_connect function is invalid.
If something else happens, it is likely that the PHP connection to MySQL works, but that there is a problem with the MySQL server itself.
In any case, copy the output and show us.
Atli 5,058
Expert 4TB
Ok, try this.
Find the line "extension_dir" in your php.ini and point it to the 'ext' directory in your PHP install dir. (In my case 'D:\Program Files\PHP\ext\')
And then restart you Apache server.
Then create a .php file containing the following, and run it.
If everything works you should get a resource #, if not give us the error. -
error_reporting(E_ALL);
-
echo mysql_connect("localhost", "root", "ROOTPWD") or die(mysql_error());
-
Got it!!!! Thanks a lot! I didn't have the php.ini file in the C:\Windows dir. I also specified the location of the php.ini file in apache htppd.conf.
Atli 5,058
Expert 4TB
Got it!!!! Thanks a lot! I didn't have the php.ini file in the C:\Windows dir. I also specified the location of the php.ini file in apache htppd.conf.
Ahh ok, glad it worked out.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Bob Trautman |
last post by:
I have installed MySql on a Windows 98 workstation. I start the service
with the command: mysqld
I can connect to the database and see tables, etc.
I have installed Apache Ver 1.X with PHP...
|
by: pancho |
last post by:
Greetings, I need help configuring/building PHP3 with MySQL as a DSO
on a Solaris 8 box - this module is needed to host some existing
sites I will be migrating
Note. I built PHP4 from source and...
|
by: Monica Ferrero |
last post by:
Hi!
I'm not sure if this is the most adequate mySQL list for this post. If not,
please indicat me which one I should use...
I'm using Tomcat 4.1.24 with Apache 2 and MySQL 4.0.13. I have the...
|
by: bruce |
last post by:
Hi...
A mysql/Apache issue:
I get the following when I'm trying to run a test web site on an Apache
2.0/RH8.0 setup.
--------------------------------
Warning: Access denied for user:...
|
by: bruce |
last post by:
Hi...
Update....
We have the following setup in our httpd.conf file. We've tried to give
what's related to the issue. We're trying to set up a virtual host for a
test project. The behavior...
|
by: MBS |
last post by:
Yeah, read the previous posts...I did that. None answer my question.
I just installed PHP 5.0.4, Apache 2.0.54, and MySQL 4.1.13 a few days ago
on WinXP SP2. My goal is to learn to use these...
|
by: news |
last post by:
We currently have our mySQL server on the same box as the Apache
server.
For security and load balancing, we're going to be moving the mySQL
server to another box.
We're already using a single...
|
by: ironcito |
last post by:
Hello,
I installed Apache 2.0.55, PHP 5.1.1, and MySQL 5.0.17 (in that
order, on Windows XP). I have managed to get Apache and PHP working
right, and MySQL by itself seems ok too. However, when...
|
by: Howard |
last post by:
Hi,
I have been racking my brain trying to figure out what I am missing trying
to follow this book to get a php script to work. I would really appreciate
if someone could point out my errors....
|
by: cwho.work |
last post by:
Hi!
We are using apache ibatis with our MySQL 5.0 database (using innodb
tables), in our web application running on Tomcat 5. Recently we
started getting a number of errors relating to...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |
