Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $link = mysqli_connect("localhost", "my_user", "my_password", "world");
- /* check connection */
- if (mysqli_connect_errno()) {
- printf("Connect failed: %s\n", mysqli_connect_error());
- exit();
- }
- $city = "Amersfoort";
- /* create a prepared statement */
- if ($stmt = mysqli_prepare($link, "SELECT District FROM City WHERE Name=?")) {
- /* bind parameters for markers */
- mysqli_stmt_bind_param($stmt, "s", $city);
- /* execute query */
- mysqli_stmt_execute($stmt);
- /* bind result variables */
- mysqli_stmt_bind_result($stmt, $district);
- /* fetch value */
- mysqli_stmt_fetch($stmt);
- printf("%s is in district %s\n", $city, $district);
- /* close statement */
- mysqli_stmt_close($stmt);
- }
- /* close connection */
- mysqli_close($link);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement