Read a MySQL DB with PHP

Question

I have a MySQL database on my hosting and am trying to query it with PHP on a dedicated PHP file, content.php :

<?php
//on inclue un fichier contenant nom_de_serveur, nom_bdd, login et password d'accès à la bdd mysql
include ("membersarea/connect.php");
//on se connecte à la bdd
$connexion = mysqli_connect (SERVEUR, LOGIN, MDP);    
if (!$connexion) {echo "LA CONNEXION AU SERVEUR MYSQL A ECHOUE\n"; exit;}
mysqli_select_db ($connexion, BDD); print "Connexion BDD reussie";echo "<br/>"; 

$result = mysqli_query($connexion, "SELECT contenu FROM content WHERE id=1");
$text =  mysqli_fetch_field($result);
?>

I want to display the BDD data on my index.php file so I included the content.php at the begining of index.php :

<?php
include ("content.php");
?>

and display between HTML balises with :

<?= $text ?>

Unfortunately i get the following error "Recoverable fatal error: Object of class stdClass could not be converted to string"

I don't really understand why (as the data in the DB is a "text") or how to fix it. Thank you for reading until here, any help is welcome ! :)

try: <?= $text->contenu ?>, then read fetch_field theres an example to fetch all rows — Lawrence Cherone
– Lawrence Cherone, Commented Jul 5, 2020 at 15:36

Joni · Accepted Answer · 2020-07-05 15:43:49Z

1

Use mysqli_fetch_row instead of mysqli_fetch_field:

$row =  mysqli_fetch_row($result);
$text = $row[0];

The mysqli_fetch_field function returns field metadata (what is its name, which table did it come from, ...). You need to use a different function to get the field values for the rows in the result set.

answered Jul 5, 2020 at 15:43

Joni

112k14 gold badges151 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ScaisEdge · Accepted Answer · 2020-07-05 15:44:18Z

1

mysqli_fetch_field($result) return a row object not a text

$obj=  mysqli_fetch_field($result);

echo  $obj->contenu;

https://www.php.net/manual/en/mysqli-result.fetch-field.php;

answered Jul 5, 2020 at 15:44

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Collectives™ on Stack Overflow

Read a MySQL DB with PHP

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related