How to fetch data from database table on PHP page

Question

I have created one IMS in that I am trying to fetch data from one table from the database and display it in drop-down form to another page. In the database, I have created one table named a party in that table one column named party_name is available and I have to fetch that column data to my order page. Below is my Code. If anyone knows a solution than please help.

<select name="party[]" style="width:100%;" required>
   <?php
     $result=mysql_query("SELECT * FROM partys");
     while ($row = mysql_fetch_array($result)) {
   ?>
   <option value="<?php echo $row['id'];?>"><?php echo $row['party_name'];?></option>
   <?php
    }
   ?>
</select>

Basic mysql. Take a look at [this](https://www.w3schools.com/php/php_mysql_select.asp) — Michel, Apr 04 '18 at 12:40
1.What is the problem here? 2. what is the output of `var_dump($partys);` (post in question)? 3. I am unable to see any DB connection and record fetching code here. — Alive to die - Anant, Apr 04 '18 at 12:40

Grant · Answer 1 · 2018-04-04T14:18:16.780

0

Firstly: mysql extension is deprecated, you should use at least mysqli_*:

Secondly: try the below example, replacing the database connection string variables with your database credentials:

<select name="party[]" style="width:100%;" required>
  <option value="">-- Please select --</option>
<?php
  $dbc = mysqli_connect('localhost', 'userName', 'password', 'databaseName')
    or die('Error connecting to MySQL server.');
  $query = "SELECT * FROM partys";
  $result = mysqli_query($dbc, $query);
  while ($row = mysqli_fetch_array($result)) {
?>
  <option value="<?php echo $row['id'];?>"><?php echo $row['party_name'];?></option>
<?php } ?>
</select>

edited Apr 04 '18 at 14:18

answered Apr 04 '18 at 13:38

Grant

2,413
2
30
41

Still blank drop down is coming – Apr 04 '18 at 13:44
Did you add your database connection credentials? What are the table columns called? – Grant Apr 04 '18 at 13:45
Can you cut and paste the EXACT table Name and the EXACT column names from that table? – Grant Apr 04 '18 at 13:51
It worked perfectly but right now issue i am facing is i unable to change value from drop down(in partys table 3 currently three records are available) by default it is selecting first value from table – Apr 04 '18 at 14:09
Can you show me the HTML that comes back for the query? – Grant Apr 04 '18 at 14:15
Add this below the – Grant Apr 04 '18 at 14:19
@RuchirShah - please accept my answer if you have come right – Grant Apr 04 '18 at 14:44
@RuchirShah - my pleasure, can you please accept my answer as the solution Thanks! – Grant Apr 05 '18 at 14:26

How to fetch data from database table on PHP page

1 Answers1