Displaying data from base

Question

filipgothic 0 Junior Poster in Training

9 Years Ago

I need code that will after pressing submit display concerts for selected group (grupanaziv), which includes number of sold tickets for that concert, place, and date, in database they are called place=mesto, date=datum, and tickets=karte

<p align="center"><font color="#0000FF">Pregled grupa</font></p>

<p align="center">Grupa kojoj koncert pripada: 
    <select name="grupa_select" id="grupa_select">
      <?php
    while($row = mysql_fetch_array($sql))
    {
    echo "<option>".$row['grupanaziv']."</option>";
    }
    ?>
    </select>
  </p>
  <p align="center">
    <input type="submit" name="pregled_grupe" id="pregled_grupe" value="- Izaberi grupu-" />
  </p>
  <p>
    <label></label>
  </p>

Thanks in advance

php

3 Contributors
3 Replies
161 Views
3 Hours Discussion Span
Latest Post 9 Years Ago Latest Post by filipgothic

All 3 Replies

cereal 1,524 Nearly a Senior Poster

9 Years Ago

Hi,

assuming you're using method GET for your form, you need to read the value assigned to $_GET['grupa_select'] and to use it as condition in your select query. So, something like:

$values = array(
    $_GET['grupa_select']
);

$sql = "SELECT * FROM concerts WHERE groupnaziv = ?";

$query = $pdo->prepare($sql);
$query->execute($values);

$result = $query->fetchAll();

foreach($result as $row)
{
    echo $row['mesto'];
    echo $row['datum'];
    echo $row['karte'];
}

Now, when you write:

in database they are called place=mesto, date=datum, and tickets=karte

Do you mean that these are the table or the column names? Please, show us the table structure.

In my example I'm using PDO, because the MySQL API is deprecated and will be removed, I suggest you to read this:

https://php.net/manual/en/mysqlinfo.api.choosing.php

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 1 · 2014-05-29T09:10:01+00:00

pritaeas 2,194 ¯\_(ツ)_/¯

9 Years Ago

So what's the problem?

filipgothic 0 Junior Poster in Training · Answer 2 · 2014-05-29T10:00:43+00:00

here I will post whole code, I have 3 tables, table korisnici, is for creating new users, and admin page does that, it works ok, database works fine for all stuff, now I need just code that will take data from base and display to user based on what group he selected

//Kreiranje baze podataka
$con = mysql_connect($hostname,$db_username,$db_password);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

if (mysql_query("CREATE DATABASE ".$db_name,$con))
  {
  echo "Database CREATED!<br>";
  }
else
  {
  echo "Error creating database: " . mysql_error()."<br>";
  }

//Kreiranje potrebnih tabela
mysql_select_db($db_name, $con);
//Tabela korisnici
$sql = "CREATE TABLE korisnici
(
ID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ID),
FirstName varchar(64),
LastName varchar(64),
Username varchar(64),
Password varchar(64)
)";
mysql_query($sql,$con);
echo "Table korisnici CREATED!<br>";
//Tabela Sections
$sql = "CREATE TABLE grupe
(
ID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ID),
grupanaziv varchar(64)
)";
mysql_query($sql,$con);
echo "Table grupe CREATED!<br>";
//Tabela Subjects
$sql = "CREATE TABLE koncerti
(
ID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ID),
koncertnaziv varchar(64),
karte int(10),
mesto varchar(64),
datum DATE,
grupa_id int(6)
)";
mysql_query($sql,$con);
echo "Table koncerti CREATED!<br>";

and here is whole php code

<?php
//Provjerava da li se korisnik vec ulogovao. Ako nije, ispisace gresku.
session_start();
if (!isset($_SESSION['korisnik'])) {
die('Za pristup ovoj stranici morate se prvo ulogovati.');
}
$student = $_SESSION['korisnik'];
  //Podaci o bazi podataka
    $hostname = "";
    $db_username = "";
    $db_password = "";
    $db_name = "";
    $con = mysql_connect($hostname,$db_username,$db_password);
    if (!$con)
    {
        die('Could not connect: ' . mysql_error());
    }
    mysql_select_db($db_name, $con);
    $sql = mysql_query("select * from grupe");
    $sql_2 = mysql_query("select * from grupe");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Administracija aplikacije</title>
</head>

<body>
<p align="center"><font color="#000000"><strong>Administracija aplikacije</strong></font></p>
<form id="form1" name="form1" method="post" action="">

    <br>
  </p>
  <hr />
  <p align="center"><font color="#0000FF">Registracija grupa</font></p>
  <p align="center">Unos nove grupe: 
    <input type="text" name="grupa_new" id="grupa_new" />
  </p>
  <p align="center">Sačuvaj grupu:
    <input type="submit" name="sacuvaj_grupu" id="sacuvaj_grupu" value="- Sacuvaj grupu -" />
  </p>
  <p>&nbsp;</p>
  <p>
    <label></label>
  </p>
  </p><br>

  <?php
  if (isset($_POST['sacuvaj_grupu'])){
  $grupa_new = $_POST['grupa_new'];
  if (empty($grupa_new)){
  die ("ERROR: Niste uneli naziv grupe!");
  }
  $con = mysql_connect($hostname,$db_username,$db_password);
    if (!$con)
    {
        die('Could not connect: ' . mysql_error());
    }
    mysql_select_db($db_name, $con);
    $sql = "insert into grupe values (NULL,'".$grupa_new."')";
    if (!mysql_query($sql,$con))
    {
        die('Error: ' . mysql_error());
    }
    echo "Podaci uspesno uneseni u bazu podataka!";
  }
  ?>


  <br>
  <hr />
   <p align="center"><font color="#0000FF">Registracija koncerata</font></p>
  <p align="center">Naziv koncerta: 
    <input type="text" name="enter_koncert" id="enter_koncert" />
  </p>
  <p align="center"><font color="#0000FF">Broj prodatih karata</font></p>
  <p align="center">Broj: 
    <input type="text" name="enter_karte" id="enter_karte" />
  </p>

   <p align="center"><font color="#0000FF">Mesto</font></p>
  <p align="center">Mesto: 
    <input type="text" name="enter_mesto" id="enter_mesto" />
  </p>

  <p align="center"><font color="#0000FF">Datum</font></p>
  <p align="center">Datum: 
    <input type="text" name="enter_datum" id="enter_datum" />
  </p>

  <p align="center">Grupa kojoj koncert pripada: 
    <select name="grupa_select" id="grupa_select">
      <?php
    while($row = mysql_fetch_array($sql_2))
    {
    echo "<option>".$row['grupanaziv']."</option>";
    }
    ?>
    </select>
  </p>
  <p align="center">
    <input type="submit" name="unos_koncert" id="unos_koncert" value="- Sacuvaj koncert-" />
  </p>
  <p>
    <label></label>
  </p>

 <?php
  if (isset($_POST['unos_koncert'])){
    $enter_koncert = $_POST['enter_koncert'];
    $enter_karte = $_POST['enter_karte'];
    $enter_mesto = $_POST['enter_mesto'];
    $enter_datum = $_POST['enter_datum'];
    $grupa_select = $_POST['grupa_select'];
    if (empty($enter_koncert)){
  die ("ERROR: Niste uneli naziv koncerta!");
  }
  $con = mysql_connect($hostname,$db_username,$db_password);
    if (!$con)
    {
        die('Could not connect: ' . mysql_error());
    }
    mysql_select_db($db_name, $con);
        $sql = mysql_query("select id from grupe where grupanaziv ='".$grupa_select."'");
        $grupa = mysql_fetch_array($sql);
    $sql = "insert into koncerti values (NULL,'".$enter_koncert."','".$enter_karte."','".$enter_mesto."','".$enter_datum."',".$grupa['id'].")";
    if (!mysql_query($sql,$con))
    {
        die('Error: ' . mysql_error());
    }
    echo "Podaci uspesno uneseni u bazu podataka!";
  }
  ?>



  <p align="center"><font color="#0000FF">Pregled grupa</font></p>

<p align="center">Grupa kojoj koncert pripada: 
    <select name="grupa_select" id="grupa_select">
      <?php
    while($row = mysql_fetch_array($sql))
    {
    echo "<option>".$row['grupanaziv']."</option>";
    }
    ?>
    </select>
  </p>
  <p align="center">
    <input type="submit" name="pregled_grupe" id="pregled_grupe" value="- Izaberi grupu-" />
  </p>
  <p>
    <label></label>
  </p>

</form>
<p align="center"><a href="logout.php">LogOut </a></p>
</body>
</html>
<?php
mysql_close($con);
?>

I have option to add new groups, to add new concerts to specific group, to add place, date and number of sold tickets in that concert, and all that works, now I need to make available to user to see all concerts, and date,place and sold tickets for that concert, so bassicly user get option to select group(band) and after clicking submit to display all concerts and their information for that group, I started that last its called pregled grupa, need to finish it and I need help

Displaying data from base

Recommended Answers Collapse Answers

All 3 Replies

Recommended Answers