首页导航博客电子书算法众创代码随贴关于我们

简单连接mysql,php语句手写

代码正文双击正文可选择全部

1[代码][php]

<?php
$db = new mysqli('localhost', 'user', 'pass', 'dbname');
$stmt = $db->prepare('insert je_user (phone,nickname)values(?,?) ');
#$stmt->bind_param('ss',$a='168',$b='qq2232');//必须要这样传参，且在mysqli等的预处理参数绑定中，必须要指定参数的类型且只能一次性绑定全部参数，不能像PDO那样一个个绑定
$params=array('1','a2');
array_unshift($params,'ss');
call_user_func_array(array($stmt,'bind_param'), refValues($params));
$stmt->execute();
$stmt->close();
function refValues($arr){
	$refs = array();
	foreach($arr as $key => $value){
		if($key)$refs[$key] = &$arr[$key]; else $refs[$key] = $arr[$key]; 
	}
	return $refs;
}
exit;

//bind_param传数组方法
$db = new mysqli('localhost', 'user', 'pass', 'dbname');
$stmt = $db->prepare('insert je_user (phone,nickname)values(?,?) ');
#$stmt->bind_param('ss',$a='168',$b='qq2232');//必须要这样传参，且在mysqli等的预处理参数绑定中，必须要指定参数的类型且只能一次性绑定全部参数，不能像PDO那样一个个绑定
$params=array('ss','1681111','qq22321111');
call_user_func_array(array($stmt,'bind_param'), refValues($params));
$stmt->execute();
$stmt->close();
function refValues($arr){
	$refs = array();
	foreach($arr as $key => $value){
		if($key)$refs[$key] = &$arr[$key]; else $refs[$key] = $arr[$key]; 
	}
	return $refs;
}
exit;

header('Content-Type: text/html; charset=utf-8');
$db=mysql_connect('localhost','user','pass');
if($db)
{
mysql_query("SET character_set_connection=utf8, character_set_results=utf8,character_set_client=binary");
mysql_select_db('a') or die('select_db failed');
set_magic_quotes_runtime(0);
//ini_set('magic_quotes_runtime','off');
echo $temp='update a set a=a中\国c where id=1'; echo '<br/>';
$result = mysql_query('update a set a="a中aaa国c" where id=1') or die('Query failed: ' . mysql_error());
$query = 'select * from a where id=1';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

while($row=mysql_fetch_array($result))
{
echo $row['a'];
}
//echo get_magic_quotes_runtime( );
}

$db = new mysqli('localhost', 'user', 'pass', 'dbname');
$stmt = $db->prepare('SELECT uid,nickname FROM je_user where uid=?');
$stmt->bind_param('i', $a=1);
$ret2 = $stmt->execute();
$stmt->bind_result($admin_id,$username);
$stmt->fetch();
$stmt->close();
printf ("\n%s (%s)", $admin_id, $username);exit;

读

$db = new mysqli('localhost', 'user', 'pass', 'dbname');
$stmt = $db->prepare('SELECT uid,nickname FROM je_user where uid=? and nickname=?');
$stmt->bind_param('ss',$a=1,$b='qq');//必须要这样传参，且在mysqli等的预处理参数绑定中，必须要指定参数的类型且只能一次性绑定全部参数，不能像PDO那样一个个绑定
$stmt->execute();
		if($stmt->affected_rows){
			$result = $stmt->get_result();
			while($row = $result->fetch_assoc()){
				var_dump($row);
			}
		}

$db = new mysqli('localhost', 'user', 'pass', 'dbname');
$stmt = $db->prepare('SELECT uid,nickname FROM je_user where uid=? and nickname=?');
$stmt->bind_param('ss',$a=1,$b='qq');//必须要这样传参，且在mysqli等的预处理参数绑定中，必须要指定参数的类型且只能一次性绑定全部参数，不能像PDO那样一个个绑定
$stmt->execute();
if($db->affected_rows){
    $result = $stmt->get_result();
    while($row = $result->fetch_assoc()){
        var_dump($row);
    }
}
$stmt->close();

$db = new mysqli('localhost', 'user', 'pass', 'dbname');
$stmt = $db->prepare('insert je_user (phone,nickname)values(?,?) ');
$stmt->bind_param('ss',$a='168',$b='qq2232');//必须要这样传参，且在mysqli等的预处理参数绑定中，必须要指定参数的类型且只能一次性绑定全部参数，不能像PDO那样一个个绑定
$stmt->execute();
$stmt->close();