使ç¨mysqlå½æ°mysqliå½æ°è¿æ¥æä½æ°æ®å¯å³å¯ï¼æè
使ç¨PDO
使ç¨mysqliæ¥éª¤ï¼
1. è¿æ¥MySQLæ°æ®åº
2. å¤ææ¯å¦è¿æ¥æå
3. éæ©æ°æ®åº
ï¼åä¸æ¥å¯ç®åæï¼$link = @mysqli_connect('localhost', 'root', '', 'lx') or exit('æ°æ®åºè¿æ¥å¤±è´¥');ï¼
4. 设置å符é
5. åå¤SQLè¯å¥
6. åMySQLæå¡åéSQLè¯å¥
7. 解æå¤çç»æé
8. éæ¾ç»æéï¼å
³éæ°æ®åºè¿æ¥
æ¡ä¾ï¼
<?php
header('Content-type:text/html;charset=utf-8');
//1.è¿æ¥æ°æ®åºæå¡å¨ mysqli mysql -u root -p
$link = @mysqli_connect('localhost','root','');
//var_dump($link);
//2.å¤æè¿æ¥æ¯å¦æå ä¿¡æ¯æ示GBKç¼ç
if(mysqli_connect_errno()){
exit('æ°æ®åºè¿æ¥å¤±è´¥åå ï¼'.mysqli_connect_error());
}
//3.éæ©æ°æ®åº è¿æ¥æ è¯ æ°æ®åºå称
if(!mysqli_select_db($link, 'wz')){
exit('æ°æ®åºéæ©å¤±è´¥');
}
//4.设置å符é
mysqli_set_charset($link, 'utf8');
//5.åå¤SQL
$username = 'zhangsan';
$password = md5('12345');
$pic = '32545.jpg';
$sql = "insert into user2(uname,password,pic) values('{$username}','{$password}','{$pic}')";
/* echo $sql;
exit; */
//6.æ§è¡SQL
$res = mysqli_query($link, $sql);
//7.å¤ææ§è¡ç»æ
if($res){
//æå
echo 'æå';
}else{
//失败
echo '失败';
}
//8.å
³éæ°æ®åºè¿æ¥
mysqli_close($link);