PHP reading mysql database entry example
Full code:
-
-
$hostname = "localhost:3306"; - $username = "root";
- $password = "root";
- $dbname = "test";
-
- $conn = mysqli_connect($hostname, $username, $password, $dbname);
- $conn->query("SET NAMES 'gbk'");
- //Detect data connection
- if (mysqli_connect_errno()){
- echo "Failed to connect to MySQL: " . mysqli_connect_error();
- }
-
- $sql = "select * from keyword";
- $result = mysqli_query($conn, $sql);
- < p>//Output mysql data query results
- while($row = mysqli_fetch_array($result)){
- echo $row['keycId'] . " : " .$row['keycontent'] . " : " . $row ['keycause'];
- echo "
";
- }
-
- // Close the connection
- mysqli_close($conn);
- ?>
-
Copy code
|