1.用mysqli方式:
//創(chuàng)建數(shù)據(jù)庫之類的
$db=@mysqli_connect('localhost', 'root', 'root','數(shù)據(jù)庫名') or @mysqli_connect('localhost', 'root', '123456','數(shù)據(jù)庫名');
$sql="INSERT INTO weibo (content, time, acc, ref) VALUES('{$content}', {$time}, 0, 0)";
if(mysqli_query($db,$sql)){
? ? ? ? ?echo "1111"; die;
? ? ?}else{
? ? ? echo "Error: " . $sql . "" . mysqli_error($db);die;? //測試發(fā)送sql問題排查問題
? ? ? ?}
2.PDO 連接方式
$dsn ="mysql:host=119.23.229.126;dbname=test數(shù)據(jù)庫;charset=utf8";
$pdo =new PDO($dsn,'root','root');?
$sql="select member_name,member_truename,member_mobile,member_email,member_passwd,member_paypwd,member_sex,available_predeposit,freeze_predeposit,white_points,red_points,member_status,member_agent_status,inviter_id from club_member";
//$result=$pdo->exec($sql);
$mm=$pdo->query($sql);??
$result =$mm->fetchAll();