connecting to a database

[MBall2003]

I am very new to php and sql, let's say about 2 days of reading the PHP4 Bible. I have previously only worked on MS Access as my only database knowledge. I have a temp database in my companies localhost folder
this is the pathname to where the db is
G:\FoxServ\mysql\data\mball_db

how do i use the function mysql_connect() to connect to the database i know it's a very simple queston but then that means a very simple answer
any help would be greatly appreciated thanks

mball

 

[sleipnir214]

I don't think your question can be answered as asked. You have made a number of incorrect assumptions.

First, a little background. MySQL is a database server (like Microsoft SQL Server), not a database application (like Access or FoxPro). You connect by to a database host by IP address, not to a database file by filesystem name.

Do you have the MySQL database server installed and running?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[jimoblak]

You first need to create a MySQL database. The server was installed with Foxserv but you need a database. To establish a database in MySQL, consider installing phpmyadmin on your web server.

http://phpmyadmin.sourceforge.net

For easy administration without the restrictions of HTML layout in phpmyadmin, consider managing your MySQL database with MySQL-Front. This freeware program has been discontinued but can be still found at:

http://efux.de/mysqlfront/MySQL-Front_2.5_Setup.exe

You can begin to worry about connecting to MySQL with PHP after you set up a database.

- - picklefish - -

 

[jimoblak]

ooops - it looks like you may already have tinkered with phpmyadmin as part of foxserv. Try this...

<?php

$Host = &quot;localhost&quot;;
$User = &quot;root&quot;;
$Password = &quot;&quot;;
$DBName = &quot;mball_db&quot;;
$Link = mysql_connect ($Host, $User, $Password);

$Query = &quot;SELECT * FROM mball_db&quot;;
$Result = mysql_db_query ($DBName, $Query, $Link);
while ($Row = mysql_fetch_array ($Result)) {
print (&quot;$Row[one_of_your_field_names]<br>\n&quot;);
}

?>

- - picklefish - -

 

[vbkris]

try using ADO. u can use the ASP code in PHP!!! (with minor modifications of coures)

Known is handfull, Unknown is worldfull