localhost

LordOrange · 11-23-2007, 05:43 AM

I've just set up a localhost with Apache. I've installed PHP and MYSQL. I downloaded a database manager and it connects to the database fine with username-root
password-orange
server-localhost

but when I run a php script to connect:

PHP Code:

   $con = mysql_connect("localhost","root","orange");

 
mysql_select_db("mysql", $con);

$result = mysql_query("SELECT * FROM info");

while($row = mysql_fetch_array($result))

{

echo "123 <br>";

 
echo $row['name']." ".$row['age'];

 
echo "<br>";

}

mysql_close($con);

nothing happens. I am sure the database (mysql) and table in it (info) are correct aswell as the row names. Can anyone help me understand what I'm doing rong?

UnKnown · 11-23-2007, 02:56 PM

never mind i posted something wrong you can delete this
but did you set a root password? If not leave it blank when connecting as root

hasan_889 · 12-03-2007, 02:22 AM

R u sure -

1. you confired MySQL with Apache properly?
2. MySQL is running?
3. Your php file is in right directory?

Check those question first, your coding looks alright to me.

Best of Luck!

11-23-2007, 05:43 AM	#1
LordOrange Newcomer Join Date: Nov 2007 Posts: 13	localhost I've just set up a localhost with Apache. I've installed PHP and MYSQL. I downloaded a database manager and it connects to the database fine with username-root password-orange server-localhost but when I run a php script to connect: PHP Code: `$con = mysql_connect("localhost","root","orange"); mysql_select_db("mysql", $con); $result = mysql_query("SELECT * FROM info"); while($row = mysql_fetch_array($result)) { echo "123 <br>"; echo $row['name']." ".$row['age']; echo "<br>"; } mysql_close($con);` nothing happens. I am sure the database (mysql) and table in it (info) are correct aswell as the row names. Can anyone help me understand what I'm doing rong?

11-23-2007, 02:56 PM	#2
UnKnown Moderator Join Date: Aug 2006 Posts: 1,128	Re: localhost never mind i posted something wrong you can delete this but did you set a root password? If not leave it blank when connecting as root __________________ Webmaster Resources & Forums / Webmaster Tools & Forum / eCommerce Shopping Basket / Scene Releases

12-03-2007, 02:22 AM	#3
hasan_889 iWEBTOOL Moderator Join Date: Aug 2006 Location: London Posts: 1,186	Re: localhost R u sure - 1. you confired MySQL with Apache properly? 2. MySQL is running? 3. Your php file is in right directory? Check those question first, your coding looks alright to me. Best of Luck! __________________ Please read the Signature & Link Rule first and award Reputation to good posts Jinnat Ul Hasan's SEO Blog - I'm not a SEO Guru - I just know some techniques Webmaster Forums & Marketplace Free Business Expert Article Directory Free Live Cricket \| Online Streaming \| TV Broadcast

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)