Insert MySQL with php into a html a list

Question

I am currently working on a website have ran into an issue. I am trying to insert data from my database into a list. Currently I run a problem where either I get the error:

Undefined variable: results in C:\xampp\htdocs\portfolio\index.php on line 65 or nothing outputs.

I know the issue not with query as I have tested it in phpmyAdmin and it works fine. If someone could point what is wrong and how to fix it, that would be awesome. Thank you.

Below is my code: main.php

<?php
if(isset($_POST['ass1'])){
    $courseNumber = "CS3800";
    $projectid = "PROJ0001";
    $results = get_courseNo_courseDes($db, $courseNumber, $projectid);
    print_r($results);
    unset($_POST['ass1']);
    }
 ?>


  <form action="ass1.php" method="post" name="a1">
  <input type="hidden" name="ass1">
 <ul name="list1">
 <?php
    foreach($results as $result){
    $sresult = $result['course_number'];
    echo"<li value='$sresult'>$sresult</option>"; 
    }
    ?>
    </ul>

    <button type="submit" value="Learn More About This Project" name="ass1">LearnMore About This Project</button>
    </form>

Here is my function in functions.php

function get_courseNo_courseDes($db, $courseNumber, $projectid){
  $query = "SELECT courses.course_name, project_description from projects inner join courses on projects.course_number = courses.course_number where courses.course_Number = :courseNumber and project_id = :projectid";
$statement = $db->prepare($query);
 $statement->bindValue(':courseNumber', $courseNumber);
 $statement->bindValue(':projectid', $projectid);
 $statement->execute();
 $result = $statement->fetchAll(PDO::FETCH_ASSOC);
 $statement->closeCursor();
 return $result;
}

danblack · Accepted Answer · 2020-02-26 05:28:09Z

1

$results isn't set unless ass1 is POSTed.

foreach($results as $result) occurs for the non-ass1 POSTED query and therefore this error occurs.

answered Feb 26, 2020 at 5:28

danblack

14.9k2 gold badges27 silver badges49 bronze badges

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

2 Comments

WaterHearts Over a year ago

oh okay I see, however when I remove the isset post, I get this error: Call to undefined function get_courseNo_courseDes() in C:\xampp\htdocs\portfolio\index.php:5 Stack trace: #0 {main} thrown in C:\xampp\htdocs\portfolio\index.php on line 5

danblack Over a year ago

functions.php isn't included in main.php

sleepingpanda · Accepted Answer · 2020-02-26 05:43:06Z

0

@WaterHearts Please refer to this tutorial.

It is simply inserting data into the database.

Please see this LINK

answered Feb 26, 2020 at 5:43

sleepingpanda

565 bronze badges

1 Comment

WaterHearts Over a year ago

Thank you as well, this tutorial was very informative.

Collectives™ on Stack Overflow

Insert MySQL with php into a html a list

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related