/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 vote289 views1 answer
Php get url after question mark
PHP
1 vote300 views1 answer
Php artisan services
PHP
1 vote357 views2 answers
Wordpress login user programmatically
PHP Wordpress
1 vote371 views1 answer
Laravel include with variable
PHP Laravel
0 vote310 views1 answer
Laravel where on relationsship column
PHP
-1 vote264 views2 answers
Wp websites login
PHP
18 votes295 views5 answers
Alert in php
PHP
3 votes316 views1 answer
Events.js:174 error discord.js
PHP
0 vote349 views1 answer
If post id is wordpress php
PHP
0 vote277 views1 answer
HTTP 500 ERROR WITHOUT MESSAGE PHP
PHP