Php connection to mysql-php Tutorial

Php connection to mysql


Create Web Page




$ Link = @ mysql_pconnect ('2017. 0.0.1 ', 'root ','');
Mysql_select_db ('mysql', $ link );
$ Query = "SELECT Host, User FROM user ";
$ Result = mysql_query ($ query, $ link );
// The obtained field
While ($ filed = mysql_fetch_field ($ result )){
Echo $ filed-> name ."
";

}
Echo mysql_affected_rows ($ link );
// Obtain the row
While ($ row = mysql_fetch_row ($ result )){
Echo $ row [0]. $ row [1].'
';
}

// $ Query = "create database my_db ";
/* $ SQL = "CREATE TABLE Persons (
FirstName varchar (15 ),
LastName varchar (15 ),
Age int
)";*/
/* $ SQL = "CREATE TABLE Persons (personID int NOT NULL AUTO_INCREMENT,
Primary key (personID ),
FirstName varchar (15 ),
LastName varchar (15 ),
Age int
) "; Set the primary key
*/

/* Mysql_query ("insert into Persons (FirstName, LastName, Age)
VALUES ('Peter ', 'Griffin', '35 ')");*/

/* $ Result = mysql_query ("SELECT * FROM Persons ");

While ($ row = mysql_fetch_array ($ result ))
{
Echo $ row ['firstname']. "". $ row ['lastname'];
Echo"
";
}

*/
/* Search
$ Result = mysql_query ("SELECT * FROM Persons
WHERE FirstName = 'Peter '");

While ($ row = mysql_fetch_array ($ result ))
{
Echo $ row ['firstname']. "". $ row ['lastname'];
Echo"
";
}

*/
Mysql_close ($ link );
?>