尝试 PHP

<?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 !";
}
?>

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值