Copy Code code as follows:
<?php
@mysql_connect ("localhost", "root", "1981427")//Select database before you need to connect to the database server
Or Die ("Database server Connection Failed");
@mysql_select_db ("test")//Select Database MyDB
Or Die ("database does not exist or not available");
$query = @mysql_query ("SELECT * from TableName1")//Execute SQL statement
Or Die ("SQL statement execution failed");
?>
Copy Code code as follows:
<?php
@mysql_connect ("localhost", "root", "1981427")//Select database before you need to connect to the database server
Or Die ("Database server Connection Failed");
@mysql_select_db ("test")//Select Database MyDB
Or Die ("database does not exist or not available");
$query = @mysql_query ("INSERT into tablename1 values (' 4 ', ' Judy ', ' 456 ')")
Or Die ("SQL statement execution failed");
?>
Copy Code code as follows:
<?php
@mysql_connect ("localhost", "root", "1981427")//Select database before you need to connect to the database server
Or Die ("Database server Connection Failed");
@mysql_select_db ("test")//Select Database MyDB
Or Die ("database does not exist or not available");
$query = @mysql_query ("SELECT * from TableName1")//Execute SQL statement
Or Die ("SQL statement execution failed");
Echo mysql_result ($query, 0, ' username '); Output the Name column of line No. 0
?>