How can I use array to cut down this block of code by retrieve these captions from a database?

Question

So instead of caption1, caption2, caption3 etc, how am I able to just pull the caption from a DB? Probably simple but I'm fairly new so I apologize.

<?php
    $captions = array(
    /*01*/ "caption1",
    /*02*/ "caption2",
    /*03*/ "caption3",
    /*04*/ "caption4",
    ); 

    for($n = 1; $n <= count($captions); $n++):
?>

EDIT: And yes I have a DB connected.

Here is my attempt at trying to retrieve the captions. Unfinished yet because I'm not to sure if I'm even going in the right direction.

<?php
            $query = mysql_query("SELECT * FROM images_tbl");
            $array = array();
            while($row = mysqli_fetch_assoc($array)){
            echo $row['caption'];
                        }


                $caption = array ( "");

                for($n = 1; $n <= count($caption); $n++):
            ?>

Do you have a db setup already? What is your code to retrieve your caption? — Yolo, Jul 30 '17 at 22:51
You should connect to the database first, you can use and ORM or plain PHP to do that. https://www.w3schools.com/php/php_mysql_select.asp — Pascal Meunier, Jul 30 '17 at 22:52
Although I'm getting: Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, array given in C:\xampp\htdocs\gallerywebsite\albums3.php on line 70 — Calvin M, Jul 30 '17 at 23:04
you can't mix different mysql apis and the base connection is unknown. — Funk Forty Niner, Jul 30 '17 at 23:04
To be fair I could just search for an answer to that, seems to be a common mistake for newcomers. — Calvin M, Jul 30 '17 at 23:05
Also see https://stackoverflow.com/questions/548986/mysql-vs-mysqli-when-using-php. — localheinz, Jul 30 '17 at 23:08
*"EDIT: And yes I have a DB connected."* - Being what, `mysql_`? `mysqli_`? PDO? Other? Only you know that. — Funk Forty Niner, Jul 30 '17 at 23:17
mysqli_, I corrected my mistake on my code, still no success nonetheless. — Calvin M, Jul 30 '17 at 23:20
you need to stop editing *on the fly here*. I rolled the question back to a previous revision. You need to place a comment under the answer given as to what's not working. — Funk Forty Niner, Jul 30 '17 at 23:30
Sorry, I'll just research it a bit more in depth with the sources localheinz has given me. — Calvin M, Jul 30 '17 at 23:36

localheinz · Accepted Answer · 2017-07-30T23:30:01.643

1

Adjust your code like this:

// establish database connection with your credentials
$connection = mysqli_connect(
    $host,
    $user,
    $password,
    $database
);

// query database
$result = mysqli_query(
    $connection,
    'SELECT caption FROM images_tbl'
);

$captions = [];

// check if querying succeeded
if (false !== $result) {
    // populate captions with values from database
    while ($row = mysqli_fetch_assoc($result)) {
        $captions[] = $row['caption'];
    }
}

Note Adjusted your query to select caption only instead of all columns, and consistently used mysqli instead of mysql.

For reference, see:

edited Jul 30 '17 at 23:30

answered Jul 30 '17 at 23:07

localheinz

9,179
2
33
44

1

you missed the connection to the query function, and we don't even know if they did connect and which api is used. – Funk Forty Niner Jul 30 '17 at 23:15
@Fred-ii- Ha, good point! Adjusted it. – localheinz Jul 30 '17 at 23:19
see my (last) comment under the question about their edits. I think you're / we're in for a long ride. – Funk Forty Niner Jul 30 '17 at 23:30
Sorry Fred, won't be a "long ride" today :( Thanks for the help localheinz, you're a true beast. Have a nice day. – Calvin M Jul 30 '17 at 23:51

How can I use array to cut down this block of code by retrieve these captions from a database?

1 Answers1