<?php
$conn = mysql_connect("localhost","test","123456");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("mydb", $con);
$result = mysql_query("select * from persons", $con);
echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";
while($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>" . $row[0] . "</td>";
echo "<td>" . $row[1] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
?>
<?php
$json_arr = json_encode(array("webname", "webname.org"));
echo "<br />";
print_r(json_decode($json_arr));
?>
<?php
$my = new mysqli("localhost", "test", "123456", "mydb");
if (mysqli_connect_errno()) {
printf("error: %d\n", mysqli_connect_error());
exit();
}
if ($my->query("insert into persons(first_name, last_name) values('don', 'self')")) {
echo "affected_rows: ".$my->affected_rows."<br />";
echo "insert_id: ".$my->insert_id."<br />";
}
?>
<?php
echo strpos("heloloworld", "world");
$email = "helloworld@qq.com";
$mail_array = explode("@", $email);
print_r($mail_array);
$arr = array("a", "bb", "ccc", "dddd");
$test = implode("-", $arr);
print_r($test);
?>
<?php
$mail_to = "qs8607@qq.com";
$mail_subject = "Test";
$message = "hello, not time no see";
$mail_from = "qs8607@qq.com";
$headers = "from: $mail_from";
mail($mail_to, $mail_subject, $message, $headers);
echo "mail sent...";
?>
<?php
$conn = mysql_connect("localhost", "test", "123456");
if (!$conn)
die('could not connect: '.mysql_error());
mysql_select_db("test", $conn);
$result = mysql_query("select * from work");
while ($row = mysql_fetch_array($result)) {
echo $row['id']." ".$row['name'];
echo "<br />";
}
mysql_close($conn);
?>
<?php
$conn = mysql_connect("localhost", "test", "123456");
if (!$conn)
die("could not connect: ".mysql_error());
mysql_select_db("mydb", $conn);
$sql =
"select * from persons";
$result = mysql_query($sql, $conn);
while ($row = mysql_fetch_array($result)) {
echo $row['first_name']." ".$row['last_name'];
echo "<br />";
}
mysql_close($conn);
?>
<?php
try {
$db = new PDO("mysql:host=localhost;dbname=mydb", 'test', '123456');
$sql = "insert into persons values('john', 'smith', '13')";
echo $db->exec($sql);
$db = null;
} catch (PDOException $e) {
echo "error !";
}
?>