onsa
12/17/2016 - 4:14 PM

Sample usage of pure PHP mysqli

Sample usage of pure PHP mysqli

<?php
  function mysqliQuery($queryString, $hostName, $userName, $password, $dbName) {
    $mysqlInstance = new mysqli($hostName, $userName, $password, $dbName);              // create instance
    
    if (!$mysqlInstance->set_charset("utf8")) {                                         // set character coding
        printf("Error loading character set utf8: %s\n", $mysqlInstance->error);
    } else {
        printf("Current character set: %s\n", $mysqlInstance->character_set_name());
    }
    
    if ($mysqlInstance->connect_error) {                                                // connect
        die('Connect Error: ' . $mysqlInstance->connect_error);
    }
    
    $escapedQueryString=$mysqlInstance->real_escape_string($queryString);               // escape query string
    
    $result = $mysqlInstance->query($escapedQueryString);                               // execute query
    while($row = $result->fetch_assoc())                                                // get results
    {
        array_push($resultArray, $row);                                                 // organise them in an array
    }
    
    $result->free();                                                                    // release the result variable
    
    $mysqlInstance->close();                                                            // close database
    
    return $resultArray;
  }
?>