mysql_connect - connects to MySQL server
mysql_select_db - select database
mysql_query - send query
mysql_num_fields - get number of fields
mysql_fetch_field - get field information
mysql_query - send query
mysql_fetch_row - get current row from result table
mysql_free_result - free result table from memoryPHP > Tips and Tutorials > Database-RelatedOct 25, 2006AnyExample
Clear explanations and tutorial exercises are provided on SQL Server connection; providing port number; selecting database; running SQL statements; checking execution errors; looping through query result; looping through result fields.
In this tutorial I will teach you how using dreamweaver you can insert information into a PHP MySQL database. If you are having problems feel free to e-mail us, or post a message on the forum. If you like this Tutorial please click here to Digg us or add the tutorial to Del.icio.us
In this article, I will explain how it is possible to connect and query an MS SQL server (running under a Windows operating system) from php installed on a unix box. The same problem, in the case of php installed under Windows is not covered here because it is well explained in php FAQ; sadly I cannot say the same thing for the unix case. In fact, there is a multitude of incorrect or outdated sources of information which will cause new people trying to solve this problem to drop it after some bad tries. This article can also be of help to people who don't want to use php as a client.
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.