Simple learning PHP code for inserting data into MYSQL & lt ;? Php $ dbhostlocalhost; $ dbuserwebjxcom; // your mysql username $ dbpass123456; // your mysql password $ dbnamedatabase; // your mysql database name // number of local connections SyntaxH
Simple learning PHP code for inserting data into MYSQL
$ Dbhost = localhost;
$ Dbuser = webjxcom; // your mysql User name
$ Dbpass = 123456; // your mysql password
$ Dbname = database; // your mysql database name
// Connect to the local database
$ Conn = mysql_connect ($ dbhost, $ dbuser, $ dbpass );
If ($ conn ){
Echo "database connected ";
} Else {
Echo "failed to connect to database ";
}
// Open the database
Mysql_select_db ($ dbname, $ conn );
// Insert data
$ SQL = "insert into test (test) values (ddddddd )";
$ Result = mysql_query ($ SQL, $ conn) or die (mysql_error ());
Echo "open database ";
// Close the database
Mysql_close ($ conn );
?>