Mysql --> Mysqli

Question

hi i need some help again. can anyone do me a favor to convert my code from Mysql --> Mysqli I've been using mysql so im not that familiar yet with mysqli thanks in advance

Here is my php code that i want to convert

<?php
    $query = mysql_query("SELECT sched_ID, venue FROM tblschedule"); 
    echo '<select id="sched_ID" name="sched_ID"  class="form-control" >';
    echo '<option>-- Select Venue --</option>';
    while ($row = mysql_fetch_array($query)) 
    {
        echo '<option value="'.$row['sched_ID'].'">'.$row['venue'].'</option>';
    }
    echo '</select>';
 ?>

There is a manual, it shows everything you need. We won't convert code for you. We will help you with issues you have. — chris85, Jan 11 '17 at 04:32
@chris85 *"We won't..."* - you and I lol, but someone did VVVVVVVV — Funk Forty Niner, Jan 11 '17 at 04:42
@Fred-ii- good point. I guess I'll leave a this by the hole, https://www.organicfacts.net/wp-content/uploads/2013/05/Carrot1.jpg. — chris85, Jan 11 '17 at 04:44
@chris85 I guess that was meant for the OP, as in "feeding them", correct? ;-) I usually like to teach them how to fish, rather than just throwing them a halibut or something. — Funk Forty Niner, Jan 11 '17 at 04:48
This question showed 0% percent effort and you learned nothing. — Funk Forty Niner, Jan 11 '17 at 04:48
@Fred-ii- for the answerer to feed the rabbit so the hole stops growing. — chris85, Jan 11 '17 at 06:21

score 1 · Accepted Answer · answered Jan 11 '17 at 04:38

To learn how to use mysqli syntax, please check the documentation here. Seems to me the mysqli syntax for your code would be:

<?php

    $query = "SELECT sched_ID, venue FROM tblschedule"; 
    echo '<select id="sched_ID" name="sched_ID"  class="form-control" >';
    echo '<option>-- Select Venue --</option>';
    $result = mysqli_query($dbconnection, $query) or die(mysqli_error($dbconnection));
    while ($row = mysqli_fetch_assoc($result)) 
        {
            echo '<option value="'.$row['sched_ID'].'">'.$row['venue'].'</option>';
        }
        echo '</select>';
 ?>

Mysql --> Mysqli

1 Answers1