/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

2 votes157 views2 answers
Laravel get file in public folder
PHP
0 vote183 views1 answer
Laravel $browser->keys alt click
PHP
1 vote214 views2 answers
How to delete image from aws using laravel 8
PHP
0 vote162 views1 answer
Php convert accented characters to html entities
PHP
0 vote154 views2 answers
Laravel collection every
PHP
23 votes193 views6 answers
Laravel 6 auth
PHP Laravel
0 vote188 views1 answer
Taxonomy_get_parents drupal 8
PHP
0 vote269 views1 answer
Curl_setopt_array php
PHP
0 vote205 views1 answer
Dropzone in php
PHP
2 votes171 views1 answer
Livewire not working
PHP