connect to mysql and get some data

Question

I need to connect my sql with php and get some data in a variable, this is my code:

<?php 
$servername = "localhost";
$username = "imsdybug_pappagallo";
$password = "Vasivafa";

// Create connection
$conn = mysqli_connect($servername, $username, $password,"imsdybug_admin");

$result = mysqli_query($conn,"SELECT * FROM profilo_pappagallo;");
while($row = mysql_fetch_array($result, MYSQL_ASSOC)){


 $pappagallo = $row['sesso'];
 echo $pappagallo;
 }
 ?>

Try instead of `while($row = mysql_fetch_array($result, MYSQL_ASSOC)){` to `while($row = $result->fetch_assoc()) {` — executable, Dec 14 '18 at 12:58
You are nesting mysql* with mysqli* library. mysql* is deprecated. — AnTrakS, Dec 14 '18 at 13:00
@SimonePostiglione You can accept the answer below by clicking on the (gray) tickmark till it turns green. You can also do the same for your other question to mark it as solved. There appears to be a solution in that one also. — Funk Forty Niner, Dec 14 '18 at 13:33

score 1 · Answer 1 · answered Dec 14 '18 at 13:00

1

You're using the mysqli in the wrong way. It looks like you confound with mysql which is deprecated, here is the proper way :

<?php 
$servername = "localhost";
$username = "imsdybug_pappagallo";
$password = "Vasivafa";

// Create connection
$conn = new mysqli($servername, $username, $password, "imsdybug_admin");

$result = $conn->query("SELECT * FROM profilo_pappagallo;");

while($row = $result->fetch_assoc()) {
    $pappagallo = $row['sesso'];
    echo $pappagallo;
}
?>

answered Dec 14 '18 at 13:00

executable

2,788
3
16
39

Maybe they just downvoted seeing your original answer that still contained the `mysql_` stuff and they never bothered coming back to remove it (or to upvote). I originally saw that but you edited within the grace period so there's no actual proof of that. For the record, I upvoted it. – Funk Forty Niner Dec 14 '18 at 13:31
Thank you to figure it out – executable Dec 14 '18 at 13:39
You're welcome. – Funk Forty Niner Dec 14 '18 at 13:40
What is the proper way? How does it answer the question? – Dharman Dec 22 '19 at 23:00

connect to mysql and get some data

1 Answers1