php mysql一些简单操作

先说mysql

<?php
header('content-type:text/html;charset=utf-8');
/**
 * Created by PhpStorm.
 * User: liuan
 * Date: 2018-11-16 0016
 * Time: 10:55
 */
// 1,连接数据库
$con = @mysql_connect('localhost','root','') or die("数据库连接失败");
//2， 选择数据库
mysql_select_db('test')or die("选择的数据库不存在");
//3 .设置字符集
mysql_set_charset('utf8');
//cmd 创建表格 执行
// mysql -uroot -p
// 回车进入sql语句输入
//查看表
//show tables
//create table users(id int primary key auto_increment,name varchar(20),money int);
//创建成功 查看该表
//desc users
//代码插入数据
$myID = Null;
$myName='李四';
$myMoney=20;

/**
 * @param $myName
 * @param $myMoney
 */
function addSql($myName, $myMoney)
{
    $sqlstatement = "insert into users values(Null, '{$myName}', '{$myMoney}')";
    $result = mysql_query($sqlstatement);
    var_dump($result);
    echo mysql_error();
}
//添加数据
addSql($myName, $myMoney);
//修改数据
//$result =mysql_query("UPDATE users SET money=25 where id=10");
//var_dump($result);
//echo mysql_error();
//修改单条数据
//$result =mysql_query("DELETE FROM users WHERE id=10");
//var_dump($result);
//echo mysql_error();
//删除表
//
//$result =mysql_query("DROP TABLE test");
//var_dump($result);
//echo mysql_error();
//查询表

$result =mysql_query("SELECT *  FROM users");

echo mysql_error();
//得到索引数组
#$line=mysql_fetch_row($result);
//得到关联数组
#$line=mysql_fetch_assoc($result);

得到关联数组
#$line=mysql_fetch_array($result,MYSQLI_ASSOC);
得到索引数组
//$line=mysql_fetch_array($result,MYSQLI_NUM);
得到关联和索引混合数组
//$line=mysql_fetch_array($result,MYSQLI_BOTH);
//$line=mysql_fetch_array($result);
//array(3) {
//    ["id"]=>
//  string(2) "11"
//    ["name"]=>
//  string(6) "李四"
//    ["money"]=>
//  string(2) "20"
//}
echo  '<pre>';
while ($line=mysql_fetch_array($result,MYSQLI_ASSOC)){
    $data[]=$line;
}

#var_dump($line);

var_dump($data);

echo  '</pre>';
//;$sqlstatement="select * from users";
//$result=mysql_query($sqlstatement);
//var_dump($result);
//查看表内数据
//select * from users;
//关闭数据库连接
mysql_close($con);

再说mysqli

<?php
/**
 * Created by PhpStorm.
 * User: liuan
 * Date: 2018-11-16 0016
 * Time: 18:05
 */
header('content-type:text/html;charset:utf-8');
$conn=mysqli_connect('localhost','root','','test');
mysqli_query($conn,'set names utf8');
$sql='SELECT * FROM users';
$res=mysqli_query($conn,$sql);
//索引数组
#$data=mysqli_fetch_all($res);
//关联数组
$data=mysqli_fetch_all($res,MYSQLI_ASSOC);

var_dump($data);
mysqli_close($conn);