Using the Object-Oriented Syntax in MySQLi : mysqli « MySQL Database « PHP






  1. PHP
  2. MySQL Database
  3. mysqli

Using the Object-Oriented Syntax in MySQLi

 
<?php

    $mysqli = new mysqli("localhost", "username", "password","mydatabase", 3306);

    $result = $mysqli->query("SELECT * FROM mytable");

    while($row = $result->fetch_array()) {

        foreach($row as $key => $value) {

            echo "$key = $value<BR/>\n";

        }

    }

    $result->close();
    $mysqli->close();

?>








Related examples in the same category

1.Multiple Queries Using MySQLi
2.Parameter Binding in MySQLi
3.Use mysqli to fetch data from mysql
4.Using the mysqli Object-Oriented API
5.mysqli_fetch_object.php
6.mysqli_fetch_result-2.php
7.mysqli_fetch_result.php
8.mysqli_fetch_row.php
9.mysqli_free_result.php
10.mysqli_multi_query.php
11.mysqli_stmt_prepare.php
12.mysqli_store_result.php
13.retrieving_multiple_rows.php