Connect to a Database

[calculus]

Let me start by saying I'm new to PHP. I've figured out some of the basics, but I need to create and connect to a database on a Unix system (I actually have the database created, I just need to re-shape it).

If someone could give me the connection string and maybe some basics about database manipulation like MoveFirst, MoveNext, SQL example, add field, then I'm sure I could be on my way quickly.

Eventually this database will drive web pages based on user selections.

Your assistance to a rookie is greatly appreciated.

calculus

 

[sleipnir214]

Insufficient data for a meaningful answer.

Connect to what database server? Oracle? PostgreSQL? MySQL? MS SQL?

Connect to a database on a unix-like os from what os? On what OS will you be running PHP?

Want the best answers? Ask the best questions:

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

TANSTAAFL!!

 

[calculus]

Sorry,

PHP is running on a Unix server. It is MySQL.

 

[deecee]

to connect i use this

$hostname_connectionName = "localhost";
$database_connectionName= "database name";
$username_connectionName= "username";
$password_connectionName= "password";
$connectionName= mysql_pconnect($hostname_connectionName, $username_connectionName, $password_connectionName) or die(mysql_error());

<Signature>
Sometimes the Answer You Are LOOKING for can be FOUND BY SEARCHING THE FAQ'S @&%$*#!!!
</Signature>

 

[sleipnir214]

A good place to start is the PHP online manual. PHP's MySQL connectivity functions are documented here:

http://php.he.net/manual/en/ref.mysql.php

There is example code in the documentation for mysql_fetch_array():

http://php.he.net/manual/en/function.mysql-fetch-array.php

Want the best answers? Ask the best questions:

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

TANSTAAFL!!