Difference between revisions of "PHP:Databases"

From wiki
Jump to: navigation, search
(Created page with "Category:PHP ;$conn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname, $dbport) or die ('Error connecting to mysql'); :Open database connection ;$result = mysqli_query($...")
 
 
Line 8: Line 8:
 
;$row    = mysqli_fetch_array($result, MYSQLI_NUM);
 
;$row    = mysqli_fetch_array($result, MYSQLI_NUM);
 
:Fetch a row as array
 
:Fetch a row as array
 +
;mysqli_free_result ($result)
 +
;$result->free_result()
 +
:Free the memory for the result (use whenever possible)
 +
;info = $result->fetch_fields()
 +
;info = mysqli_fetch_fields($result)
 +
:Get field information from the last query
 +
<syntaxhighlight lang=php>
 +
$info = $result->fetch_fields();
 +
foreach ($info as $val) {
 +
            printf("Name:      %s<br>",  $val->name);
 +
            printf("Table:    %s<br>",  $val->table);
 +
            printf("Max. Len:  %d<br>",  $val->max_length);
 +
            printf("Length:    %d<br>",  $val->length);
 +
            printf("charsetnr: %d<br>",  $val->charsetnr);
 +
            printf("Flags:    %d<br>",  $val->flags);
 +
            printf("Type:      %d<br><br>", $val->type);
 +
}
 +
</syntaxhighlight>

Latest revision as of 16:45, 10 June 2019

$conn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname, $dbport) or die ('Error connecting to mysql');
Open database connection
$result = mysqli_query($conn,$query) or die('Error, retrieve failed');
Execute a query on the opened connection
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
Fetch a row as hash
$row = mysqli_fetch_array($result, MYSQLI_NUM);
Fetch a row as array
mysqli_free_result ($result)
$result->free_result()
Free the memory for the result (use whenever possible)
info = $result->fetch_fields()
info = mysqli_fetch_fields($result)
Get field information from the last query
$info = $result->fetch_fields();
foreach ($info as $val) {
            printf("Name:      %s<br>",   $val->name);
            printf("Table:     %s<br>",   $val->table);
            printf("Max. Len:  %d<br>",   $val->max_length);
            printf("Length:    %d<br>",   $val->length);
            printf("charsetnr: %d<br>",   $val->charsetnr);
            printf("Flags:     %d<br>",   $val->flags);
            printf("Type:      %d<br><br>", $val->type);
}