/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

0 vote162 views1 answer
Gravity Form Shortcode Wordpress
PHP
2 votes270 views1 answer
How to make a model in folder in laravel
PHP Laravel
0 vote197 views1 answer
Php afosto / yaac urn:ietf:params:acme:error:malformed 405
PHP
0 vote189 views1 answer
Separate numbers with commas laravel
PHP Laravel
0 vote162 views2 answers
Count rows mysql limit php
PHP
0 vote130 views2 answers
Pdo check if row exists
PHP
7 votes179 views1 answer
Laravel not in query
PHP Laravel
-1 vote171 views1 answer
Clear Caching of Queries Laravel Specific Model Cache
PHP Laravel
0 vote166 views1 answer
Fill zero on php
PHP
0 vote144 views1 answer
Part of url php
PHP