connecting mysql database with php

[linux1880]

what is the basic i should know about php when connecting the database ? I have finished studing php but being newbie, I would like ask what should I need to know ? I saw that even application forms on html can be sent to mysql with javascript, can anybody enlight this to me on the basics , any help is appreceated. Thank you.

 

[murdocsvan]

Ask a more specific question and i may be able to help.

 

[CrazeD]

<?php
$host = 'localhost'; // MySQL host name
$user = 'root'; // MySQL database user name
$pass = 'root'; // MySQL database user password
$db = 'dbname'; // MySQL database name

$connect = @mysql_connect ($host,$user,$pass) or die ('Error connecting to database!');

$select = @mysql_select_db ($db) or die ('Error selecting database!');
?>

Now you are connected to MySQL. Save this file as mysql.php or something and include it on every page that needs a MySQL connection.

As for Javascript accessing MySQL, that is called AJAX and you need a pretty good knowledge of Javascript and XML before you get into that.

 

[linux1880]

Thank you,

what i want to know is how html page form submission is going to the database ?

 

[CrazeD]

PHP Tutorial - Forms
PHP Forms
PHPmac - Writing Form Data to a MySQL Database using PHP

 

[willsko87]

I saw that even application forms on html can be sent to mysql with javascript

As CrazeD mentioned AJAX is an advanced javascript that is usually used to update data from a database without having to refresh the page.