<html>
<head>
<title>MySQL & DML</title>
</head>
<body>
<h2>Select Data</h2>
<?php
include "connect.php";
$result_single = mysql_query("SELECT * FROM msuser");
if(mysql_num_rows($result_single) > 0){
$row = mysql_fetch_array($result_single);
echo $row['name']."<br>";
echo $row['email'];
}
else{
echo "Data not found";
}
?>
<h4>Using HTML Table</h4>
<?php
$result_multiple = mysql_query("SELECT * FROM msuser");
// Create table header first
echo "<table border='1'>
<tr>
<th>User Id</th>
<th>Name</th>
<th>Email</th>
</tr>";
// Looping through the rows of data
while ($row = mysql_fetch_array($result_multiple)) {
echo "<tr>";
echo "<td>".$row['userid']."</td>";
echo "<td>".$row['name']."</td>";
echo "<td>".$row['email']."</td>";
echo "</tr>";
}
echo "</table>";
?>
<h2>Insert Data</h2>
<?php
$name = "testuser1";
$password = "userpass1";
$email = "testuser1@admin.com";
$phone = 23456789;
$query = "INSERT INTO msuser VALUES ('','$name','$password','$email','$phone')";
if(mysql_query($query)){
echo "Insert data success<br>";
echo $name." / ".$password." / ".$email." / ".$phone;
}
else
echo "Error insert data";
?>
<h2>Update Data</h2>
<?php
$updatedname = "testuser2";
$updatedpassword = "testuser2";
$updatedphone = 98765432;
$query = "UPDATE msuser SET name='$updatedname', password='$updatedpassword', phone='$updatedphone'
WHERE name='testuser1'";
if(mysql_query($query)){
echo "Update data success<br>";
echo $updatedpassword." / ".$updatedphone;
}
else
echo "Error update data";
?>
<h2>Delete Data</h2>
<?php
$query = "DELETE FROM msuser WHERE name='testuser2'";
if(mysql_query($query)){
echo "Delete data success<br>";
}
else
echo "Error delete data";
?>
<?php
mysql_close($con);
?>
</body>
</html>
Tidak ada komentar:
Posting Komentar