/PHP/Connecting to database and performing sql queries

Connecting to database and performing sql queries

<?php 
//Connecting to the database
$conn =  mysqli_connect('localhost', 'root', '', 'peroHub');

if(!$conn){
    echo "Error in connection: " . mysqli_connect_error();
}

$sql = 'SELECT title, ingredients, id FROM pizzas';

$result = mysqli_query($conn, $sql);


$pizza = mysqli_fetch_all($result, MYSQLI_ASSOC);

//free result from memory
mysqli_free_result($result);

//close connection
mysqli_close($conn);

// print_r($pizza);


?>

Source: stackoverflow.com

Similar codes

7 votes193 views4 answers
Laravel is route name
PHP
9 votes197 views3 answers
Default null migration laravel
PHP
0 vote162 views2 answers
Php get last modified date of file
PHP
0 vote162 views1 answer
Laravel has many insert
PHP Laravel
1 vote186 views2 answers
Laravel 8 seeding
PHP
0 vote198 views1 answer
Laravelda so`rovlarni cheklash
PHP
0 vote166 views1 answer
Laravel recursive relationships
PHP
0 vote180 views1 answer
General errorstring fetchAll() php
PHP
0 vote179 views1 answer
Laravel Can't write image data to path Image::make($image)->resize
PHP
0 vote177 views1 answer
Loop object property laravel
PHP