/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

11 votes318 views3 answers
Full url php
PHP
0 vote311 views1 answer
Encode string for csv
PHP
2 votes323 views1 answer
Grep only in php files
PHP
1 vote305 views1 answer
How to get file name in upload images in php
PHP
0 vote310 views1 answer
Check if any field update laravel
PHP
0 vote334 views9 answers
Laravel view-model
PHP Laravel
0 vote296 views1 answer
What is scalar data type in php
PHP
1 vote334 views1 answer
Laravel http request plain text
PHP
5 votes302 views1 answer
Php psr4
PHP
9 votes324 views1 answer
Npm run dev error laravel 8
PHP Laravel