New Comer (less than 5 posts)
connecting to mysql database
hie i'm a newbie and am having a problem connecting to my database..
the name of my database is wilsoft and it does not have a password..here is my code:
<html><?php
mysql_connect("localhost", "root", "") or die(mysql_error());
echo "Connected to MySQL";
?>
</html>
Junior Coders
Re: - connecting to mysql database
Hi,
If executing this code you are getting output as "Connected to MySQL" means you are connected to the MySQL server, now the next step is selecting the database.
To select the database ythe function provided by PHP is mysql_select_db("name of the database"). Thus after add this line
mysql_select_db("") or die ("could not select database");
Once this is done you can then use PHP function mysql_query() to fire a query on the selected database and may use mysql_fetch_array() to fetch the result if you are firing a select query.
Hope this is helpful.
Cheers,
~Maneet
LeXolution IT Services (P) Ltd.
Web Development Company
Posting Permissions
Reply With Quote
Bookmarks