// connect to database $dsn = 'mysql:host=localhost;dbname=my_db'; $username = 'my_user'; $password = 'my_password'; $pdo = new PDO($dsn, $username, $password); // prepare and execute SELECT statement $sql = "SELECT * FROM users WHERE username = :username"; $stmt = $pdo->prepare($sql); $stmt->execute(array(':username' => 'john')); // fetch results as associative array $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
// connect to database $mysqli = new mysqli('localhost', 'my_user', 'my_password', 'my_db'); // prepare and execute INSERT statement $stmt = $mysqli->prepare("INSERT INTO users (username, email) VALUES (?, ?)"); $stmt->bind_param('ss', $username, $email); $username = 'john'; $email = 'john@example.com'; $stmt->execute();
// connect to database $link = mysql_connect('localhost', 'my_user', 'my_password'); mysql_select_db('my_db', $link); // execute UPDATE statement $username = 'john'; $age = 30; $result = mysql_query("UPDATE users SET age = $age WHERE username = '$username'", $link);It's important to note that the legacy MySQL extension is deprecated and should not be used for new projects. PDO or MySQLi should be used instead.