note 114994 deleted from function.mysqli-connect by cmb
| From: | cmb@php.net | Date: | Thu, 20 Aug 2015 00:46:50 +0000 |
| Subject: | note 114994 deleted from function.mysqli-connect by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-203398@lists.php.net to get a copy of this message | ||
Note Submitter: sapioit at gmail dot com
----
Because these functions are not so easy to use, at the beginning, there is a simple basic script,
using 3 files, showing how mysqli basic functions are working:
<?php
# db.php
$sql_login_host = "localhost"; # MySQL Host
$sql_login_user = "test"; # MySql UserName
$sql_login_pass = "test"; # MySql Password
$sql_login_db = "jocdecarti"; # MySql Database
define("sql_login_host",$sql_login_host);
define("sql_login_user",$sql_login_user);
define("sql_login_pass",$sql_login_pass);
define("sql_login_db",$sql_login_db);
$devmode = true; # show errors
?>
<?php
# functions.php
include ("db.php");
# show errors
ini_set('short_open_tag', true);
if ($devmode) {
ini_set('display_errors', true); /*change to false in production mode */
/* error_reporting(E_ALL); */
error_reporting(E_ALL & ~E_NOTICE & ~E_WARNING);
} else {
error_reporting(E_ALL ^E_NOTICE ^E_WARNING);
}
# conectare la baza de date
$con=mysqli_connect($sql_login_host, $sql_login_user, $sql_login_pass, $sql_login_db);
if(!$con){
die("Conectare imposibila: ".mysqli_error($con));
}
if (mysqli_connect_errno()) {
die("Connect failed: ".mysqli_connect_errno()." : ". mysqli_connect_error());
}
# obtinere de rezultate din baza de date
function db($sqlq){ # $sqlq = sql querry;
global $con;
if( !$sql=mysqli_query($con,$sqlq) ){
die("Error:".mysqli_errno($sql).":".mysqli_error($sql)."</br>Query:
".$sqlq);
} else {
mysqli_free_result($sqlq);
return $sql;
}
}
# functii pentru prelucrarea datelor din functia db
function sql_get_lines($sql){
$sqlq=db($sql);
$nr=0;
$returned_array[][]=0;
$returned_array[0][0]=mysqli_num_rows($sqlq);
$returned_array[0][1]=mysqli_num_fields($sqlq);
while($row=mysqli_fetch_row($sqlq)){
$nr++;
foreach ($row as $key => $value){
$returned_array[$nr][$key+1]=$value;
}
echo "</br>";
}
mysqli_free_result($sqlq);
return $returned_array;
}
function sql_get_fields($sql){
$sqlq=db($sql);
$nr=0;
$returned_array[]=0;
$returned_array[0]=mysqli_num_rows($sqlq);
while($row=mysqli_fetch_row($sqlq)){
$nr++;
foreach ($row as $value){
$returned_array[$nr]=$value;
}
echo "</br>";
}
mysqli_free_result($sqlq);
return $returned_array;
}
function sql_get_value($sql){
$sqlq=db($sql);
$row=mysqli_fetch_row($sqlq);
mysqli_free_result($sqlq);
return $row[0];
}
function sql_value($sql){
return sql_get_value($sql);
}
# functii pentru afisarea datelor din functiile anterioare
function sql_print_lines($returned_array){
for($i=1;$i<=$returned_array[0][0];$i++){
for($j=1;$j<=$returned_array[0][1];$j++){
printf("%s : %s |= %s</br>", $i, $j, $returned_array[$i][$j]);
}
}
}
function sql_print_fields($returned_array){
for($i=1;$i<=$returned_array[0];$i++){
printf("%s |= %s</br>", $i, $returned_array[$i]);
}
}
# functii pentru afisarea directa din cod sql, folosind functiile anterioare
function echo_sql_print_lines($sql){
sql_print_lines(sql_get_lines($sql));
}
function echo_sql_print_fields($sql){
sql_print_fields(sql_get_fields($sql));
}
function echo_sql_value($sql){
echo sql_get_value($sql);
}
function sql_print_value($sql){
echo sql_get_value($sql);
}
?>
<?php
# test_functions.php
include ("functions.php");
# show entire table
$sql_querry="select * from multiplayer";
sql_print_lines(sql_get_lines($sql_querry));
echo_sql_print_lines($sql_querry);
# show table row
$sql_querry="select player2_hand from multiplayer";
sql_print_fields(sql_get_fields($sql_querry));
echo_sql_print_fields($sql_querry);
# show first value returned
$sql_querry="SELECT id FROM multiplayer WHERE id=1";
echo sql_value($sql_querry);
echo sql_get_value($sql_querry);
echo_sql_value($sql_querry);
sql_print_value($sql_querry);
mysqli_close($sql_link);
?>