/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 vote251 views1 answer
Php get object josn
PHP
12 votes264 views4 answers
Wordpress get post thumbnail
PHP
58 votes272 views6 answers
In_array php
PHP
0 vote249 views1 answer
WordPress enqueue wp-api as a dependency
PHP
7 votes258 views2 answers
Secure random number php
PHP
1 vote255 views1 answer
Php execute a background process
PHP
2 votes249 views1 answer
How to use join query in codeigniter
PHP
20 votes271 views6 answers
Laravel 8 make:auth
PHP
0 vote252 views1 answer
How to migrate new column without empty the table in laravel
PHP
3 votes242 views3 answers
Php max_execution_time
PHP