mysqliはmysqlの前処理を実現する


<?php

	//  mysqli    mysql   

	//  mysqli_stmt   
	$mysqli = new mysqli('localhost', 'root', '', 'test', '3306');
	$mysqli->set_charset('utf-8');

	$sql = "insert into test values (null, ?, ?)";
	
	$stmt = $mysqli->prepare($sql);

	// ss                string string     ss
	$stmt->bind_param('ss', $username, $password)

	//  
	$username = "test123";
	$password = "test123";

	//  sql  
	$stmt->execute();

	//     mysqli_stmt             prepare()
	//$stmt = $mysqli->stmt_init();	
	//$stmt->prepare($sql);

?>