Learn VBA & Macros in 1 Week!

PHP - Using If In The Select Data Code

Full Excel VBA Course - Beginner to Expert

Using If In The Select Data Code	View Content

Example Code:
$sql=$baglan->prepare("SELECT * FROM img where id='$getx') and if (FirstImage==1 echo FirstImage=1 ; else FirstImage==0 echo FirstImage=0 ) "); // AS ETC.
$sql->execute();
$rs = $sql->fetch();

if FirstImage=1 is absent, continue with FirstImage=0

Thanks for your idea and effort.

Full Excel VBA Course - Beginner to Expert

Need Help To Select And Display Data From Db

Similar Tutorials

View Content

Hi all,
I am a php student and i am doing a project in php. I am doing the project of online attendance register. I am stuck with the part of reports. We need to select three different values from an HTML form and pick the selected rows and wants to display those rows in a table. I have done a code but it is not working. Please help me out of this issue. HTML Form:

<!doctype html>

<html>

<head>

<meta charset="utf-8">

<title>Untitled Document</title>

</head>



<body><form action="reportpro.php" method="get"    name="services">

  <table width="447" border="0" align="center" >

    <tr style="text-align: center">

      <td width="441"><table width="481" border="1">

        <tr>

          <td width="216"><div align="center">

            SECTION

          </div></td>

          <td width="102"><div align="center">

            MONTH

          </div></td>

          <td width="141"><div align="center">

            YEAR

          </div></td>

           

        </tr>

        <tr>

          <td><select name="section" id="select">

            <option>SERVICES-A</option>

            <option>SERVICES-B</option>

            <option>SERVICES-C</option>

            

          </select></td>

          <td><select name="month" id="select">

            <option>01</option>

            <option>02</option>

            <option>03</option>

            <option>04</option>

            <option>05</option>

            <option>06</option>

            <option>07</option>

            <option>08</option>

            <option>09</option>

            <option>10</option>

            <option>11</option>

            <option>12</option>

          </select></td>

          <td><select name="year" id="select">

            <option>2014</option>

            <option>2015</option>

            <option>2016</option>

            <option>2017</option>

            <option>2018</option>

            <option>2019</option>

            <option>2020</option>

            </select></td>

            

    </tr>

            

          

        

        <tr>

          <td colspan="4">  <center><input name="submit" type="submit" id="submit"   formaction="reportpro.php" formmethod="get" value="Search"></center></td>

          </tr>

      </table>

        <p>&nbsp;

          

        </p>

        <p>&nbsp;&nbsp;&nbsp;

        </p>

      <p>&nbsp;

      </p></td>

    </tr>

  </table>

</form>

</body>

</html>

PHP Code:

<!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>Untitled Document</title>

</head>



<body>



<form action="" method="get">

  <table border="1" align="center" >

 

    <tr>

      <td>BOOK NO</td>

      <td>Name</td>

      <td>Desigination</td>

      <td>Section</td>

      <td>Day</td>

       <td>Month</td>

        <td>Year</td>

         

      <td>Attendance</td>

      </tr>

    

    <?php

$con=mysql_connect("localhost","root","");

mysql_select_db("niy",$con);



$m=$_REQUEST['month'];

$y=$_REQUEST['year'];

$sec=$_REQUEST['section'];



 $sql="select month='$m', year='$y', sectn='$sec' from attendance ";

echo $sql;



$res=mysql_query($sql,$con);

while($row=mysql_fetch_array($res))

{

?>

<tr>

   <td><?php echo $row[1];?></td>

<td><?php echo $row[2];?></td>

<td><?php echo $row[3];?></td>

<td><?php echo $row[4];?></td>



  <td><?php echo $row[5];?></td>

  <td><?php echo $m;?></td>

  <td><?php echo $y;?></td>  

    <td><?php echo $row[8];?></td>

     

 

 </tr>

  <?php

  }

  ?>

 

    

   </table>

</body>

</html>

Get The Data From Select Option

Similar Tutorials

View Content

Hi..

I need to add code to check if the compound that was choose is reach the maximum value then if it is already reach theirs a notification displayed that he already gain the maximum.

the problem is..I don't know how can I check if what the user choose before run the condition.

here is my code:

Code: [Select]
<?php
  $config['BASE_DIR']  = dirname(dirname(__FILE__));
  $config['BASE_DIR'] = $config['BASE_DIR']. '\MES PROJECT';
   define('SMARTY_DIR', $config['BASE_DIR']. '/INCLUDE/smarty/libs/');

  require(SMARTY_DIR . 'Smarty.class.php');
  $smarty = new Smarty();

  $smarty = new Smarty();
  $smarty->template_dir = $config['BASE_DIR'].  '/smarty/templates';
  $smarty->config_dir   = $config['BASE_DIR'].  '/smarty/config';

  $smarty->cache_dir    = $config['BASE_DIR'].  '/INCLUDE/smarty/cache';
  $smarty->compile_dir  = $config['BASE_DIR'].  '/INCLUDE/smarty/templates_c';

// =================================================================================================================
$con= mysql_connect('localhost', 'root', '');
if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);

$hostAddr = $_SERVER['REMOTE_ADDR'];

$terminal = $hostAddr; //<-enable this in server
//$terminal = $_POST['doThis'];  //<- disable this in server
$terminal = "192.168.1.101";
switch ($terminal) {
       case "192.168.1.101" : //<< enable this in server
       //case "1" :

          $smarty->assign('process', 'Rubber/Chemical Preparation');
          $smarty->assign('termNo', 'Terminal 1');

          $smarty->assign('text_name1','Compound Code');
          $smarty->assign('text_name2','Lot Traveler ID');
          $smarty->assign('text_name3','Kit Weight ');
          $smarty->assign('text_name4','Operator Code');

         [b]  $smarty->assign('compoundIndexValue', array('0',  'P28',  'P30',  'P32',  'P33',  'P35',  'P35M',  'P38',  'P40', 'P41',  'P42',  'P43', 'P46', 'P47', 'PXX', 'P35W'));[/b]
           $smarty->assign('names', array('<Choose Code>',   'P28',  'P30',  'P32',  'P33',  'P35',  'P35M',  'P38',  'P40', 'P41',  'P42',  'P43', 'P46', 'P47', 'PXX', 'P35W'));

           $smarty->assign('weightIndexValue', array('0',  '60.145', '68.980', '65.381', '69.270', '49.360', '68.610', '54.880', '73.300', '51.973', '52.944', '57.627', '45.997', '69.196', '70.000', '55.000'));

           $smarty->assign('kitWeight', array('<Choose Weight>','60.145', '68.980', '65.381', '69.270', '49.360', '68.610', '54.880', '73.300', '51.973', '52.944', '57.627', '45.997', '69.196', '70.000', '55.000'));

          //Chemical weighing Process :  Terminal 1
          $smarty->display('header.tpl');  // common Header
          $smarty->display('box_1.tpl');
          $smarty->display('footer.tpl');


       [b] $compound = mysql_real_escape_string($_POST['compoundIndexValue']);
        $sql = "SELECT
                P28, P28_max, P28_min,
                P30, P30_max, P30_min,
                P32, P32_max, P32_min,
                P33, P33_max, P33_min,
                P35, P35_max, P35_min,
                P35M, P35M_max, P35M_min,
                P35W, P35W_max, P35W_min,
                P38, P38_max, P38_min,
                P41, P41_max, P41_min,
                P42, P42_max, P42_min,
                P43, P43_max, P43_min,
                P46, P46_max, P46_min,
                P47, P47_max, P47_min
                FROM parameter_settings";
        $res_pcode = mysql_query($sql, $con);

        $row = mysql_fetch_assoc($res_pcode);
            $P28 = $row['P28'];
            $P28_max = $row['P28_max'];
            $P28_min = $row['P28_min'];

            $P30 = $row['P30'];
            $P30_max = $row['P30_max'];
            $P30_min = $row['P30_min'];

            $P32 = $row['P32'];
            $P32_max = $row['P32_max'];
            $P32_min = $row['P32_min'];

            $P33 = $row['P33'];
            $P33_max = $row['P33_max'];
            $P33_min = $row['P33_min'];

            $P35 = $row['P35'];
            $P35_max = $row['P35_max'];
            $P35_min = $row['P35_min'];

            $P35M = $row['P35M'];
            $P35M_max = $row['P35M_max'];
            $P35M_min = $row['P35M_min'];

            $P35W = $row['P35W'];
            $P35W_max = $row['P35W_max'];
            $P35W_min = $row['P35W_min'];

            $P38 = $row['P38'];
            $P38_max = $row['P38_max'];
            $P38_min = $row['P38_min'];

            $P41 = $row['P41'];
            $P41_max = $row['P41_max'];
            $P41_min = $row['P41_min'];

            $P42 = $row['P42'];
            $P42_max = $row['P42_max'];
            $P42_min = $row['P42_min'];

            $P43 = $row['P43'];
            $P43_max = $row['P43_max'];
            $P43_min = $row['P43_min'];

            $P46 = $row['P46'];
            $P46_max = $row['P46_max'];
            $P46_min = $row['P46_min'];

            $P47 = $row['P47'];
            $P47_max = $row['P47_max'];
            $P47_min = $row['P47_min'];


        $sql = "SELECT PCODE, total FROM kanban_checker WHERE PCODE = '$compound' ORDER BY PCODE";
        $res_kanban = mysql_query($sql, $con);

        $row_kanban = mysql_fetch_assoc($res_kanban);

        $PCODE = $row_kanban['PCODE'];
        $total = $row_kanban['total'];

        if($compound == $P28 && $total == $P28_max){
         echo "<script type='text/javascript'>notify(P28 gain total maximum)</script>";
        }
        else {
            echo '';
        }

       if($compound == $P30 && $total == $P30_max){
         echo "<script type='text/javascript'>notify(P30 gain total maximum)</script>";
       }
        else{
        echo '';
        }

        if($compound == $P32 && $total == $P32_max){
         echo "<script type='text/javascript'>notify(P32 gain total maximum)</script>";
       }
        else{
        echo '';
        }

        if($compound == $P33 && $total == $P33_max){
         echo "<script type='text/javascript'>notify(P33 gain total maximum)</script>";
       }
        else{
        echo '';
        }

        if($compound == $P35 && $total == $P35_max){
         echo "<script type='text/javascript'>notify(P35 gain total maximum)</script>";
       }
        else{
        echo '';
        }

        if($compound == $P35M && $total == $P35M_max){
         echo "<script type='text/javascript'>notify(P35M gain total maximum)</script>";
       }
        else{
        echo '';
        }

        if($compound == $P35W && $total == $P35W_max){
         echo "<script type='text/javascript'>notify(P35W gain total maximum)</script>";
       }
        else{
        echo '';
        }

        if($compound == $P38 && $total == $P38_max){
         echo "<script type='text/javascript'>notify(P38 gain total maximum)</script>";
       }
        else{
        echo '';
        }

        if($compound == $P41 && $total == $P41_max){
         echo "<script type='text/javascript'>notify(P41 gain total maximum)</script>";
       }
        else{
        echo '';
        }

        if($compound == $P42 && $total == $P42_max){
         echo "<script type='text/javascript'>notify(P42 gain total maximum)</script>";
       }
        else{
        echo '';
        }

        if($compound == $P43 && $total == $P43_max){
         echo "<script type='text/javascript'>notify(P43 gain total maximum)</script>";
       }
        else{
        echo '';
        }

        if($compound == $P46 && $total == $P46_max){
         echo "<script type='text/javascript'>notify(P46 gain total maximum)</script>";
       }
        else{
        echo '';
        }

        if($compound == $P47 && $total == $P47_max){
         echo "<script type='text/javascript'>notify(P47 gain total maximum)</script>";
       }
        else{
        echo '';
        }[/b]
       break;

       case "192.168.1.102" : //<< enable this in server
       //case "2" :

          $smarty->assign('process', 'Compounding Process');
          $smarty->assign('termNo', 'Terminal 2');
          $smarty->assign('text_name1','Lot Traveler ID');
          $smarty->assign('text_name2','Kit Weight');
          $smarty->assign('text_name3','Machine Code');
          $smarty->assign('text_name4','Operator Code');

          $smarty->assign('machineID', array('0', 'B1', 'B2', 'B3', 'K1', 'K2', 'OM1', 'OM2', 'OM3', 'OM4', 'OM5', 'OM6', 'OM7'));
          $smarty->assign('machineIDdisplay', array('<Choose Machine ID>', 'B1', 'B2', 'B3', 'K1', 'K2', 'OM1', 'OM2', 'OM3', 'OM4', 'OM5', 'OM6', 'OM7'));

          $smarty->display('header.tpl');  // common Header
          $smarty->display('box_2.tpl');
          $smarty->display('footer.tpl');
       break;

       case "192.168.1.103" : //<< enable this in server
       //case "3" :
          $smarty->assign('process', 'Extrusion Process');
          $smarty->assign('termNo', 'Terminal 3');
          $smarty->assign('text_name1','Lot Traveler ID');
          $smarty->assign('text_name2','Kit Weight');
          $smarty->assign('text_name3','Machine Code');
          $smarty->assign('text_name4','Operator Code');

          $smarty->assign('machineID', array('0', 'E1', 'E2', 'E3', 'E4', 'E5', 'E6'));
          $smarty->assign('machineIDdisplay', array('<Choose Machine ID>', 'E1', 'E2', 'E3', 'E4', 'E5', 'E6'));

          $smarty->display('header.tpl');  // common Header
          $smarty->display('box_2.tpl');
          $smarty->display('footer.tpl');
       break;

       case "192.168.1.104" : //<< enable this in server
       //case "4" :
          $smarty->assign('process', 'Half Shell Forming');
          $smarty->assign('termNo', 'Terminal 4');

          $smarty->assign('text_name1','Lot Traveler ID');

          $smarty->assign('text_nameDG','New Lot ID');

          $smarty->assign('text_name2','Machine ID');
          $smarty->assign('text_name3','Output Qty.');
          $smarty->assign('text_name4','Reject Qty.');
          $smarty->assign('text_name5','Operator Code');

          $smarty->assign('id', array('0', 'NTG1', 'NTG2', 'NTG3', 'NTG4', 'GTG1', 'SQG1', 'PL1'));
          $smarty->assign('id_name', array('<Choose Machine ID>', 'NTG1', 'NTG2', 'NTG3', 'NTG4', 'GTG1', 'SQG1', 'PL1'));

          $smarty->display('header.tpl');  // common Header
          $smarty->display('box_3.tpl');
          $smarty->display('footer.tpl');
       break;

       case "192.168.1.105" : //<< enable this in server
       //case "5" :

          $smarty->assign('process', 'Half Shell Deflashing'); //= to be implemented
          $smarty->assign('termNo', 'Terminal 5');
          $smarty->assign('text_name1','Lot Traveler ID');
          $smarty->assign('text_name2','Machine ID');
          $smarty->assign('text_name3','Output Qty.');
          $smarty->assign('text_name4','Reject Qty.');
          $smarty->assign('text_name5','Operator Code');

$smarty->assign('id',      array('0', 'US DEF.1', 'US DEF.2', 'FRENCH DEF.1', 'FRENCH DEF.2', 'THAILAND DEF.1', 'THAILAND DEF.2', 'HANAU 45 DEF.'));
$smarty->assign('id_name', array('<Choose Machine ID>', 'US DEF.1', 'US DEF.2', 'FRENCH DEF.1', 'FRENCH DEF.2', 'THAILAND DEF.1', 'THAILAND DEF.2', 'HANAU 45 DEF.'));

          $smarty->display('header.tpl');  // common Header
          $smarty->display('box_3.tpl');
          $smarty->display('footer.tpl');
       break;


}
?>

My only purpose is to avoid adding data so i need to prompt if he already reach the maximum per compound.

Thank you so much

Select - Data From Two Tables

Similar Tutorials

View Content

Hi guys,

This is my first time posting here - im just getting into PHP - i got a question;

I have two databases:

profile(id, name, interests, dob, gender, join_date, email)
interests(id, profile_id, interests)
id being the primary key, and profile_id being the foreign key from profile.

I want to script that returns profile information and all the matching interests (one user can have multiple interests).

This is what i have so far, though it does not work, and i knew it wouldnt;

function get_profile($id) {
   $connection = mysql_open();
   $query = "SELECT * ";
   $query .= "FROM profiles, interests ";
   $query .= "WHERE profile.id=" . $id;
   $query .= " AND interests.profile_id=" . $id;
   $result = @ mysql_query($query, $connection);
   // Transform the result set to an array (for Smarty)
   $entries = array();
   while ($row = mysql_fetch_array($result)) {
      $entries[] = $row;
   }
   mysql_close($connection) or show_error();;
   return $entries;
}

Can someone please advise on how this can be done? or do i need to have two query's one for each table ?

Thank you in advance!!

Can You Use Data From A Database In A Combo Box Select Form?

Similar Tutorials

View Content

I have a simple database table that has the names of countries listed with just 2 fields ID & country. I want to use this in a form to choose the country and provide statistics regarding that country. I know how to get the data from MySQL, but I don't know how I can use this in the form as a selection? How do I get the options to iterate all of the countries so that when the form is displayed a combo type box is displayed with a dropdown list? I have not shown any code as I am not sure if this is possible. Please can anyone advise if this is possible and if so some example code?

Problem With Using Mysql Data In Select Form

Similar Tutorials

View Content

This is a continuation of a previous post.
I am trying to get the names of countries that are in a database table.
It's not working! All I get is a Submit button, but no data.
This is what I understand from the code that Psycho suggested:
I am unfamiliar with the function and the use of the FOREACH constuct.
looking at the PHP manual there are two syntaxes. It appears that Psyhco has used the second form where the current element's key is assigned to $key variable for each itteration.
foreach (array_expression as $key => $value
The 2 variables he used are $id and $label
I assume that the line: $optionsHTML = ''; is the array built from the expression: $optionsHTML .= "{$label}\n";
Because I was not familiar with the PDO method, but have used mysqli, I had to rewrite the data retrival part which I believe is OK.
I guess that the line : $countryOptions = buildSelectOptions($countries); is used in conjunction with the function to build the array.
The HTML part that Psycho wrote puts the variable into the Form format for a selection list.
Why is the $optionsHTML also inclosed in the option tags?
Have I got the HTML part correct or is it the data extraction part that is incorrect?
Here is the code:

<?
include("AddStats_admin_connect.php");
//connect to database
doDB();
//Function to build select options based on passed array
function buildSelectOptions($options)
{
$optionsHTML = '';
foreach($options as $id => $label)
{
$optionsHTML .= "<option value='{$id}'>{$label}</option>\n";
}
return $optionsHTML;
}

//Run query to get the ID and Name from the table
//Then populate into an array
$clist_sql = "SELECT CID, Country FROM Countries";
$clist_res= mysqli_query($mysqli, $clist_sql) or die(mysqli_error($mysqli));
if (mysqli_num_rows($clist_res) < 1) {
//this Country not exist
$display_block = "<p><em>You have selected an invalid Country.<br/>
Please try again.</em></p>";
}
$countries = array();
while($Ctry_info = mysqli_fetch_array($clist_res)) {
$countries[$Ctry_info['CID'] = $Ctry_info['Country']];
}
$countryOptions = buildSelectOptions($countries);
?>

<!DOCTYPE html>
<html lang="en">
<head>

<title>Stats</title>
<link rel="stylesheet" href="stylesheets/style.css" />
<!--[if IE]>
<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
</head>
<body>
<? echo $countryOptions; ?>
</br></br></br></br></br></br></br></br>
<!Later in the HTML for the page
<form action="Ctrystats.php" method="post">
<option name="country" value=<? echo $countryOptions;?>Country</option></br></br>
<input type="submit" value="Submit Choice">
</form></p>


</body>
</html>

I think I am nearly there so I would appreciate some help to finish this coding.

Note: If you make your questions easy to read, then you have better chances of a quality answer.
Use [ code ] ] tags.

How Do I Take Data From A Select Query And Insert Into Another Table?

Similar Tutorials

View Content

I have tried several attempts and can get data to select and using echo display it, however, I need to take this data and insert it into the database in a separate table. I have the following which does hafl the job, can I get some pointers on the rest. I have looked everywhere and not found a solution, at all.

// Selects the data I need
<?php
mysql_connect("PRIVATE INFO","PRIVATE INFO","PRIVATE INFO") or
die("Could not connect: " . mysql_error());

mysql_select_db("wpdb");

$result = mysql_query("SELECT ID FROM wp_posts

WHERE post_title LIKE '%future%'
AND post_status = 'publish'
OR post_title LIKE '%option%'
AND post_content LIKE '%fundamental%'
AND post_status = 'publish'

   ORDER BY post_date DESC");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{   echo $row['ID'];
   echo "<br />";};

?>

Thought maybe something like the following would work, but am at a loss:
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id, term_order)
SELECT ID FROM wp_posts

WHERE post_title LIKE '%future%'
AND post_status = 'publish'
OR post_title LIKE '%option%'
AND post_content LIKE '%fundamental%'
AND post_status = 'publish'

ORDER BY post_date DESC

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))

VALUES
($row['ID'], '25', '0')

Help Needed: Select Specific User Data From Mysql In Php

Similar Tutorials

View Content

Hello. I'm a newbie so sorry if this isn't the best forum to post my problem. I am using a MySQL and PHP to create a web app. I have authentication, and I can register users. I also have a form that users provide information and it is successfully inserting data into a table in my database. I will use fictional fields for my database table called meal_info: username dateStartedDiet numberMealsPerDay costPerMeal Problem: Select user-specific data from the MySQL database, using Session username to select only the current user's data, then display it and do some calculations. Here is thecode at the top, and I am fairly sure it's working: session_start(); //execute commone code require("common.php"); //includes code to connect to database, etc. if(empty($_SESSION['user']))

Select Data From Mysql Database Based On Get Variables.

Similar Tutorials

View Content

Not sure why this isnt working.
Code: [Select]
<?php session_start(); ?>
<!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>
<script src="http://js.nicedit.com/nicEdit-latest.js" type="text/javascript"></script>
<script type="text/javascript">bkLib.onDomLoaded(nicEditors.allTextAreas);</script>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<LINK REL=StyleSheet HREF="inc/dyn_style.css" TYPE="text/css" MEDIA=screen />
<?php

?>
<?php include('logic.inc'); mysqlConnect(); ?>
<script type="text/javascript" src="bbeditor/ed.js"></script>
<link rel="stylesheet" type="text/css" href="dyn_style.css" />
<title>
Social
</title>
<script type="text/javascript">
function changeTitle(title)
{
document.title = title;
}
</script>

</head>

<body>
<?php
$inc = 'new_story.php';
$view = 'Newest ';
$by = 'added';
$where = " ";
$where2 = " ";
$order = "ASC";
$gen = "All";
$rat = 'All';
$blerg = "";
$sort = 'newest';
//----------------------------------------------------------------------
if(isset($_GET['sub']))
{
$sort = $_GET['sort'];
switch($sort)
{
case "Most Popular";
$by = 'views';
$view = 'Most Popular ';
$order = 'DESC';
break;
case "Most Reviewed";
$view= 'Most Reviewed  ';
$by = 'reviews';
$order = 'DESC';
break;
case "Newest";
$by = 'added';
$view = 'Newest';
$order = 'ASC';
break;
}

$genre = mysql_real_escape_string($_GET['cat']);
$rating = mysql_real_escape_string($_GET['rat']);
if($gen ==  'All')
{
$where = " ";
$blerg = "";
}
else
{
$where = "WHERE cat='$gen'";
}
if ($rat == "All")
{
$where2 = ' ';
$blerg = 'AND';

}
else
{
$where2 = $blerg ."
rating = '$rat'
";
}
}
//----------------------------------------------------------------------

?>
<?php serch(); ?>
<form action="story.php" method="get">
<label id='inline'> Order By: </label>
<select name='sort'>
<option selected='yes' label='Currently Selected' > <?php echo $view;  ?> </option>
<option> Newest </option>
<option> Most Popular</option>
<option> Most Reviewed </option>
</select>
<input type='hidden' value='spec_view' name='p' />
<label id='inline'> Genre/Catagory: </label>
<select name='gen'>
<option selected='yes' label = 'Selected Genre - <?php echo $gen; ?>'> <?php echo $gen; ?> </option>
<option> All </option>
<option> Fantasy </option>
<option> Adventure </option>
<option> Science Fiction</option>
<option> Drama</option>
<option> Fable </option>
<option> Horror</option>
<option> Humor</option>
<option> Realistic Fiction </option>
<option> Tall Tale</option>
<option> Mystery </option>
<option> Mythology </option>
<option> Poetry </option>
<option> Shorty Story </option>
<option> Romance </option>

</select>
<label id='inline'> Rating: </label>
<select name='rat'>
<option selected='yes' label = "Selected Genre - <?php echo $rat; ?>"> <?php echo $gen; ?> </option>
<option> All </option>
<option> C </option>
<option> C13 </option>
<option> YA </option>
<option> A </option>

</select>

<input type='submit' value='Go!' name = 'go' />
</form>
<?php

$query = "
SELECT * FROM story_info
ORDER BY $by $order
$where
$where2
";
echo $query;
$select = mysql_query($query) or die(mysql_error());

while($rows = mysql_fetch_assoc($select))
{
$viewsdb = $rows['views'];
$titledb = $rows['title'];
$userdb = $rows['user'];
$catdb = $rows['cat'];
$ratdb = $rows['rating'];
$id_db = $rows['story_id'];
$sumdb = shorten($rows['sum']);
echo "<h3><a href='?p=page&id=$id_db'> $titledb </a>   </h3>";
echo "<div id='fun_info'>";
echo "$sumdb <br />";
echo "By <a href='?p=profile&user=$userdb'> $userdb </a> <br /> ";
echo "$viewsdb Views | Rated: $ratdb | Catagory: <a href='?p=cat_view&gen=$catdb'> $catdb </a>  </div>";
}
?>
</div>

</body>
</html>

Insert Data Into Database From Multi Select List

Similar Tutorials

View Content

could anyone please help me with the code which is i have already displayed data as a multi select list but now i need to select one or more from them and insert into another database table. would be appreciate your help. thanx

Cannot Select Data After Update Or Delete Sql Statement In Php In Same Action

Similar Tutorials

View Content

In the same $-POST , i wanted to perform update and delete. With the updated and deleted database, I need to select the updated data from the database. However, it tells me: Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in... .I am new to sql in php, is it true that i cannot perform sql in this way? Or is there any suggestion to perform select straight after deleting and updating?

CANCEL BOOK RESERVATION
if(isset($_POST['cancelres']))
{


        $query = "DELETE FROM reserved_books WHERE id='$resid';"; //delete reservation
        $query .="UPDATE reserved_books SET queue = queue - 1 WHERE bookid = '$bookid' AND queue > '$bookqueue';";//update queue number where reservation that queue behind/after/ the current reservation
        $query_run = mysqli_multi_query($connection, $query);

        if($query_run)
        {
          $_SESSION['success'] = "Reservation Cancelled";
        }
        else
        {
          $_SESSION['status'] = " Reservation Not Cancelled";    
        }

        $query= "SELECT title FROM books WHERE id = '$bookid';"; //get book title from db
        $query_run = mysqli_query($connection,$query);
        if(mysqli_num_rows($query_run)>0)
        {
            foreach ($query_run as $row) {
            $title = $row['title'];
            }
        }
        $bookres = "SELECT * FROM reserved_books WHERE bookid = '$bookid' AND queue = 1";
        $bookres_run = mysqli_query($connection,$bookres);
        foreach($bookres_run as $row)
        {
            $res_username = $row['username'];
            $res_id = $row['id'];
        }

        $query= "SELECT option_value FROM settings WHERE option_name = 'email_temp_rescollect'"; //get email template from db
        $query_run = mysqli_query($connection,$query);
        if(mysqli_num_rows($query_run)>0)
        {
            $row = mysqli_fetch_array($query_run);
            $rescollect_template = $row[0];
        }}

Problem In Saving Data From While Loop And Select Option

Similar Tutorials

View Content

Hi..

I need to save data from a while loop and data from select option, Now I encountered that using my query I only save is the last part of my while loop and also the data that I choose in select option did not save.

here is my code:

Code: [Select]
<?php
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date =date('Y-m-d H:i:s');

$sr_date = $_POST['sr_date'];
$sr_number = $_POST['sr_number'];
$Items = $_POST['Items'];
$SubItems = $_POST['SubItems'];
$ItemCode = $_POST['ItemCode'];
$DemandedQty = $_POST['DemandedQty'];
$UoM = $_POST['UoM'];
$Class = $_POST['Class'];
$Description = $_POST['Description'];
$BINLocation = $_POST['BINLocation'];
$RequestedBy = $_POST['RequestedBy'];
$ApprovedBy = $_POST['ApprovedBy'];
$ReceivedBy = $_POST['ReceivedBy'];
$IssuedBy = $_POST['IssuedBy'];

$sql = "INSERT INTO stock_requisition
(sr_date, sr_number, Items, SubItems, ItemCode, DemandedQty, UoM, Class, Description, BINLocation, RequestedBy,
ApprovedBy, ReceivedBy, IssuedBy)
VALUES
('$sr_date', '$sr_number', '$Items', '$SubItems', '$ItemCode', '$DemandedQty', '$UoM', '$Class', '$Description',
'$BINLocation', '$RequestedBy', '$ApprovedBy', '$ReceivedBy', '$IssuedBy')
ON DUPLICATE KEY UPDATE
sr_date = '$sr_date', sr_number = '$sr_number', Items = '$Items', SubItems = '$SubItems', ItemCode = '$ItemCode', DemandedQty = '$DemandedQty',
UoM = '$UoM', Class = '$Class', Description = '$Description', BINLocation = '$BINLocation', RequestedBy = '$RequestedBy',
ApprovedBy = '$ApprovedBy', ReceivedBy = '$ReceivedBy', IssuedBy = '$IssuedBy'";

$result = mysql_query($sql, $con);

        $sql = "SELECT sr_number FROM stock_requisition ORDER BY sr_date DESC LIMIT 1";
        $result = mysql_query($sql, $con);

        if (!$result) {
            echo 'failed';
            die();
        }
        $total = mysql_num_rows($result);
        if ($total <= 0) {
            $currentSRNum = 1;
        }
        else {
//------------------------------------------------------------------------------------------------------------------
            // Stock Number iteration....
            $row = mysql_fetch_assoc($result);

            $currentSRNum = (int)(substr($row['sr_number'],0,3));

            $currentSRYear  = (int)(substr($row['sr_number'],2,2));
            $currentSRMonth = (int)(substr($row['sr_number'],0,2));
            $currentSRNum = (int)(substr($row['sr_number'],6,4));

            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD)
            {
                $currentSRNum = 1;
            }
            else
            {
                $currentSRNum += 1;
            }
        }
//------------------------------------------------------------------------------------------------------------------
        $yearMonth = date('ymd');
        $currentSR = $currentYMD . sprintf("%04d", $currentSRNum);
?>
<html>
<title>Stock Requisition</title>
<head>
<style type="text/css">
#ddcolortabs{
margin-left: 2px;
padding: 0;
width: 100%;
background: transparent;
voice-family: "\"}\"";
voice-family: inherit;
padding-left: 2px;
}

#ddcolortabs ul{
font: bold 12px Arial, Verdana, sans-serif;
margin:0;
padding:0;
list-style:none;
}

#ddcolortabs li{
display:inline;
margin:0 2px 0 0;
padding:0;
text-transform:uppercase;
}

#ddcolortabs a{
float:left;
color: white;
background: #8cb85c url(layout_image/color_tabs_left.gif) no-repeat left top;
margin:2px 2px 0 0;
padding:0px 0 1px 3px;
text-decoration:none;
letter-spacing: 1px;
}

#ddcolortabs a span{
float:right;
display:block;
/*background: transparent url(layout_image/color_tabs_right.gif) no-repeat right top;*/
padding:6px 9px 2px 6px;
}

#ddcolortabs a span{
float:none;
}

#ddcolortabs a:hover{
background-color: #678b3f;
}

#ddcolortabs a:hover span{
background-color: #678b3f ;
}

#ddcolortabs #current a, #ddcolortabs #current span{ /*currently selected tab*/
background-color: #678b3f;
}
</style>
<style type="text/css">
#ddcolortabs1{
position: relative;
top: 10px;
margin-left: 2px;
padding: 0;
width: 100%;
background: transparent;
voice-family: "\"}\"";
voice-family: inherit;
padding-left: 2px;
}

#ddcolortabs1 ul{
font: bold 12px Arial, Verdana, sans-serif;
margin:0;
padding:0;
list-style:none;
}

#ddcolortabs1 li{
display:inline;
margin:0 2px 0 0;
padding:0;
text-transform:uppercase;
}

#ddcolortabs1 a{
float:left;
color: white;
background: #8cb85c url(layout_image/color_tabs_left.gif) no-repeat left top;
margin:2px 2px 0 0;
padding:0px 0 1px 3px;
text-decoration:none;
letter-spacing: 1px;
}

#ddcolortabs1 a span{
float:right;
display:block;
/*background: transparent url(layout_image/color_tabs_right.gif) no-repeat right top;*/
padding:6px 9px 2px 6px;
}

#ddcolortabs1 a span{
float:none;
}

#ddcolortabs1 a:hover{
background-color: #678b3f;
}

#ddcolortabs1 a:hover span{
background-color: #678b3f ;
}

#ddcolortabs1 #current a, #ddcolortabs1 #current span{ /*currently selected tab*/
background-color: #678b3f;
}
</style>

<style>
#SR_date{
position: relative;
font-family: Arial, Helvetica, sans-serif;
font-size: .9em;
margin-left: 10px;
width: auto;
height: auto;
float: left;
top : 10px;

}
#SR_number{
position: relative;
font-family: Arial, Helvetica, sans-serif;
font-size: .9em;
margin-left: 270px;
width: auto;
height: auto;
float: left;
top : 10px;

}
table {
margin: 10px;
font-family: Arial, Helvetica, sans-serif;
font-size: .9em;
border: 1px solid #DDD;
width: auto;
}

th {
font-family: Arial, Helvetica, sans-serif;
font-size: .7em;
background: #694;
color: #FFF;
padding: 2px 6px;
border-collapse: separate;
border: 1px solid #000;
}

td {
font-family: Arial, Helvetica, sans-serif;
font-size: .7em;
border: 1px solid #DDD;
text-align: left;
}

#RequestedBy{
position: relative;
font-family: Arial, Helvetica, sans-serif;
font-size: .8em;
margin-left: 10px;
width: auto;
height: auto;
float: left;
top : 10px;
}

#ApprovedBy{
position: relative;
font-family: Arial, Helvetica, sans-serif;
font-size: .8em;
margin-left: 15px;
width: auto;
height: auto;
float: left;
top : 10px;
}

#ReceivedBy{
position: relative;
font-family: Arial, Helvetica, sans-serif;
font-size: .8em;
margin-left: 15px;
width: auto;
height: auto;
float: left;
top : 10px;
}
#IssuedBy{
position: relative;
font-family: Arial, Helvetica, sans-serif;
font-size: .8em;
margin-left: 15px;
width: auto;
height: auto;
float: left;
top : 10px;
margin-right: 120px;
}
#save_btn{
position: relative;;
font-family: Arial, Helvetica, sans-serif;
font-size: .8em;
margin-left: 10px;
top: 10px;
}
</style>

<script type="text/javascript">
function save_sr(){
var sr_date = document.getElementById("sr_date").value;
var sr_number = document.getElementById("sr_number").value;
var Items = document.getElementById("Items").value;
var SubItems = document.getElementById("SubItems").value;
var ItemCode = document.getElementById("ItemCode").value;
var DemandedQty = document.getElementById("DemandedQty").value;
var UoM = document.getElementById("UoM").value;
var Class = document.getElementById("Class").value;
var Description = document.getElementById("Description").value;
var BINLocation = document.getElementById("BINLocation").value;
var RequestedBy = document.getElementById("RequestedBy").value;
var ApprovedBy = document.getElementById("ApprovedBy").value;
var ReceivedBy = document.getElementById("ReceivedBy").value;
var IssuedBy = document.getElementById("IssuedBy").value;

document.stock_requisition.action="StockRequisitionSave.php?sr_date="+sr_date+"&sr_number="+sr_number+"&Items="+Items+
"&SubItems="+SubItems+"&ItemCode="+ItemCode+"&DemandedQty="+DemandedQty+"&UoM="+UoM+"&Class="+Class+"&Description="+
Description+"&BINLocation="+BINLocation+"&RequestedBy="+RequestedBy+"&ApprovedBy="+ApprovedBy+"&ReceivedBy="+ReceivedBy+
"&IssuedBy="+IssuedBy;
document.stock_requisition.submit();

alert("Stock Requisition data save.");
window.location = "StockRequisition.php";

}
</script>
</head>
<body>
<form name="stock_requisition" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<div id="ddcolortabs">
<ul>
<li> <a href="ParameterSettings.php" title="Parameter Settings"><span>Parameter Settings</span></a></li>
<li style="margin-left: 1px"><a href="kanban_report.php" title="WIP Report"><span>Wip Report</span></a></li>
<li id="current"><a href="StockRequisition.php" title="WMS RM"><span>WMS RM</span></a></li>
</ul>
</div>

<div id="ddcolortabs1">
<ul>
<li><a href="ReceivingMaterials.php" title="Receiving Materials"><span>Receiving Materials</span></a></li>
<li><a href="Shelving.php" title="Shelving"><span>Shelving</span></a></li>
<li id="current"><a href="StockRequisition.php" title="Stock Requisition"><span>Stock Requisition</span></a></li>
</ul>
</div>

<div id="SR_date">
<label>Date :</label>
<input type="text" name="sr_date" value="<?php echo $sr_date; ?>" size="16" readonly="readonly" style="border: none;">
</div>
<div id="SR_number">
<label>SR# :</label>
<input type="text" name="sr_number" value="<?php echo $currentSR; ?>" size="10" readonly="readonly" style="font-weight: bold; border: none;">
<br/>
</div>
<div>
<table>
<thead>
<th>Items</th>
<th>Sub Items</th>
<th>Item Code</th>
<th>Demanded Qty</th>
<th>UoM</th>
<th>Class</th>
<th>Description</th>
<th>BIN Location</th>
</thead>
<?php

$sql = "SELECT DISTINCT Items FROM bom_subitems ORDER BY Items";
$res_bom = mysql_query($sql, $con);

while($row = mysql_fetch_assoc($res_bom)){

    $Items = $row['Items'];
echo "<tr>
        <td style='border: none;font-weight: bold;'> <input type='name' value='$row[Items]' name='Items' id='Items' readonly = 'readonly' style = 'border:none;width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='5'></td>
        </tr>";

$sql = "SELECT SubItems, ItemCode, UoM, Class, Description, BINLocation FROM bom_subitems WHERE Items = '$row[Items]' ORDER BY Items"or die(mysql_error());

$res_sub = mysql_query($sql, $con);
while($row_sub = mysql_fetch_assoc($res_sub)){

    echo "<tr>
        <td style='border: none;'> </td>
        <td style='border: none;'> <input type='text' name='SubItems' value='$row_sub[SubItems]' id='SubItems' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'> <input type='text' name='ItemCode' value='$row_sub[ItemCode]' id='ItemCode' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'><center><input type='text' name='DemandedQty' id='DemandedQty' value='' size='7'></center></td>
        <td style='border: none;' size='3'> <input type='text' name='UoM' value='$row_sub[UoM]' id='UoM' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='3'></td>
        <td style='border: none;'> <input type='text' name='Class' value='$row_sub[Class]' id='Class' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'> <input type='text' name='Description' value='$row_sub[Description]' id='Description' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'> <input type='text' name='BINLocation' value='$row_sub[BINLocation]' id='BINLocation' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        </tr>";
}
}

?>
</table>
</div>

<div id='RequestedBy'>
<label>Requested By:</label>
<select name="Requested_By">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBBB'>BBBBBBBBB</option>
<option name='CCCCCCCCCC'>CCCCCCCCCC</option>
</select>
</div>

<div id='ApprovedBy'>
<label>Approved By:</label>
<select name="Approved_By">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBBB'>BBBBBBBBB</option>
<option name='CCCCCCCCCC'>CCCCCCCCCC</option>
</select>
</div>

<div id='ReceivedBy'>
<label>Received By:</label>
<select name="Received_By">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBB'>BBBBBBBB</option>
<option name='CCCCCCCC'>CCCCCCCC</option>
</select>
</div>

<div id='IssuedBy'>
<label>Issued By:</label>
<select name="Issued BY">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBB'>BBBBBBBB</option>
<option name='CCCCCCCC'>CCCCCCCC</option>
</select>
</div>

<div id="save_btn">
<input type="button" name="button" value="save" onclick="save_sr()">
</div>
</body>
</html>

I also I attach the display data.

Thank you

Problem In Highlighting Display Data Using Select Statement With Css Class

Similar Tutorials

View Content

Hi...

I have query in highlighting null data using this code:

Code: [Select]
<?php

include 'config.php';

$currentEmpID = $_SESSION['empID'];

if(!isset($_POST['Regsubmit_'])){

    $DATE1 = $_GET['Regfirstinput'];
    $DATE2   = $_GET['Regsecondinput'];

$sql = "SELECT DISTINCT IF(ISNULL(a.LOG_IN), 'rdc', '') AS LOGIN_CLASS, IF(ISNULL(a.LOG_OUT), 'rdc', '') AS LOGOUT_CLASS, a.EMP_ID, CONCAT(LASTNAME, ', ' , FIRSTNAME) AS FULLNAME, a.LOG_IN, a.LOG_OUT
FROM $ATTENDANCE.attendance_build AS a JOIN $ADODB_DB.employment em ON (a.EMP_ID = em.EMP_NO AND em.STATUS IN ('Reg Operatives', 'Reg Staff'))
WHERE LOG_IN BETWEEN '$DATE1' AND '$DATE2'
OR ISNULL(LOG_IN) OR ISNULL(LOG_OUT)";

    $DTR = $conn3->GetAll($sql);
    $smarty->assign('attendance', $DTR);
}
$smarty->display('header_att.tpl');
$smarty->display('RegAttendance.tpl');
$smarty->display('footer.tpl');
?>

and here is the tpl code:

Code: [Select]
{section name=att loop=$attendance}
<tr>
<td colspan="2">{$attendance[att].EMP_ID}</td>
<td colspan="2">{$attendance[att].FULLNAME}</td>
<td colspan="2" class="{$attendance[att].LOGIN_CLASS}">{$attendance[att].LOG_IN|date_format:"%d-%m-%Y %I:%M %p"}</td>
<td colspan="2" class="{$attendance[att].LOGOUT_CLASS}">{$attendance[att].LOG_OUT|date_format:"%d-%m-%Y %I:%M %p"}</td>
</tr>
{sectionelse}
<tr><td colspan="1">No DATA</td></tr>
{/section}

this code highlight the null value of login or logout or both.

this is the css:
Code: [Select]
.rdc {background-color:#ff0000;}

Now, I need to revised my query statement, because i have separate code for adding attendance if the employee has no attendance or no login or no logout.

I just want to happen is if the employee is already add his attendance in NRS table or should I said if the LOG_IN in attendance table is equal to TIME_IN in NRS table the data will have a color yellow.

For Example:

I have this data in attendance table:

EMP_ID = 012012
LOG_IN = NULL
LOG_OUT = 2011-12-12 13:35:00

I will his attendance in NRS table to have his attendance:

EMP_NO = 012012
TIME_IN = 2011-12-12 05:35:00
TIME_OUT = 2011-12-12 13:35:00

In my above query the LOG_IN has a background color of RED.

I want to happen is if I add his attendance in NRS the EMP_NO, LOG_IN, LOGOUT will have a color to notice that it is already have in NRS.

Because theirs a scenario that the employee has no login or no logout or both.

Feel free to ask me if my explanation is not clear to you.

Thank you in advance

Select Form To Display Data From Mysql Not Working When Using Ajax

Similar Tutorials

View Content

I had this working, but when I try and get fancy and use AJAX the data doesn't display. I think this is a PHP problem though.

My code for the select form including AJAX code

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-GB">
<head>
<title>AJAX Example</title>
<link rel="stylesheet" type="text/css" href="Form.css" media="screen" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("tr:odd").addClass("odd");
});
</script>
<script type="text/javascript">
function showPlayers(str)
{
var xmlhttp;
if (str=="")
{
document.getElementById("DataDisplay").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
else
{// code for IE6, IE5
}
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("DataDisplay").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","Query.php?category_id="+str,true);
xmlhttp.send();
}
</script>
</head>

<body>

<h1">AJAX Example</h1>

<?php
#connect to MySQL
$conn = @mysql_connect( "localhost","username","pw")
or die( "You did not successfully connect to the DB!" );

#select the specified database
$rs = @mysql_SELECT_DB ("MyDB", $conn )
or die ( "Error connecting to the database test!");
?>
<form name="sports" id="sports">
<legend>Select a Sport</legend>
<select name="category_id" onChange="showPlayers(this.value)">
<option value="">Select a Sport:</option>
<?php
$sql = "SELECT category_id, sport FROM sports ".
"ORDER BY sport";

$rs = mysql_query($sql);

while($row = mysql_fetch_array($rs))
{
echo "<option value=\"".$row['category_id']."\">".$row['sport']."</option>\n ";
}
?>
</select>

</form>
<br />
<div id="DataDisplay"></div>

</body>
</html>

Query.php

<?php
#get the id
$id=$_GET["category_id"];

#connect to MySQL
$conn = @mysql_connect( "localhost","username","pw")
or die( "Error connecting to MySQL" );

#select the specified database
$rs = @mysql_SELECT_DB ("MyDB", $conn )
or die ( "Could not select that particular Database");
#$id="category_id";
#create the query
$sql ="SELECT *
FROM sports
INNER JOIN players ON sports.category_id = players.category_id
WHERE players.category_id = '".$id."'";

echo $sql;

#execute the query
$rs = mysql_query($sql,$conn);
#start the table code
echo "<table><tr><th>Category ID</th><th>Sport</th><th>First Name</th><th>Last Name</th></tr>";
#write the data
while( $row = mysql_fetch_array( $rs) )
{
echo ("<tr><td>");
echo ($row["category_id"] );
echo ("</td>");
echo ("<td>");
echo ($row["sport"]);
echo ("</td>");

echo ("<td>");
echo ($row["first_name"]);
echo ("</td>");

echo ("<td>");
echo ($row["last_name"]);
echo ("</td></tr>");
}
echo "</tr></table>";
mysql_close($conn);
?>

I think the problem is either with this part in the AJAX
Code: [Select]
xmlhttp.open("GET","Query.php?category_id="+str,true);

or most likely in my Query.php code

when I wasn't using AJAX and using POST it worked fine, but adding the AJAX stuff and GET it doesn't work.

When I echo out the SQL the result is

Code: [Select]
SELECT * FROM sports INNER JOIN players ON sports.category_id = players.category_id WHERE players.category_id = ''

so the category_id is not being selected properly and that is the primary key/foreign key in the MySQL table which connects the JOIN.

Select All Code Tag...

Similar Tutorials

View Content

PHPBB3 does it. I crafted it on my own forum too. Why not have it here? Code is being posted daily.

https://www.phpbb.co...655675#p5655675

See it in action? That would be usefull here instead of dragging and highlighting our mouse over the code and pressing CTRL+C.

If IPB has a custom BBCODE manager, you could just use the code in their topic @Phillip.
Edited by Monkuar, 25 January 2015 - 12:19 PM.

Php Sql Select Error In Code Please Help

Similar Tutorials

View Content

please can you help .. I'm passing a value from another page using $_SESSION and trying to then use it in a SELECT statement in SQL think I'm missing something ... if hard code the value it works , and I have also checked at the other end that the variable is being assigned ...

code is (its the = $_SESSION['g_district'] "); that's causing the issue

I'm getting

Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting '-' or identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in /Applications/XAMPP/xamppfiles/htdocs/mytimekeeper/add/add.php on line 170 in the browser

     <div class="row s2 m2 l2">    
                <div>
                <label for="course_id">Choose the course raced:</label>
                <select name="course_id">
    	            <?php
    	                // query to create course_id dropdown
    	                $resultset = $conn->query("SELECT `course_id`,`course_name` FROM `tbl_courses` WHERE `district`= $_SESSION['g_district'] ");
                        while($row = $resultset->fetch_assoc())
                        { 
                        echo "<option value='{$row[course_id]}'>{$row['course_name']}</option>";   
                        }
      	            ?>  
	            </select>

No Values Shown In <select> Aft Using Php Code

Similar Tutorials

View Content

Hi all,

Currently my dob_day is not showing any value, even though there is a value in the database, it seems like it is unable to retrieve the value.

No value was shown in the <select> box. Do you guys have any idea? Thanks

Code: [Select]
<?php
$query = "SELECT name, nric, gender, picture, dob_day FROM tutor_profile WHERE tutor_id = '" . $_GET['tutor_id'] . "'";

$data = mysqli_query($dbc, $query)
or die(mysqli_error($dbc));

// The user row was found so display the user data
if (mysqli_num_rows($data) == 1) {
$row = mysqli_fetch_array($data);

    if ($row != NULL) {
      $name = $row['name'];
      $nric = $row['nric'];
      $gender = $row['gender'];
  $old_picture = $row['picture'];
  $dob_day = $row['dob_day'];
    }
    else {
      echo '<p class="error">There was a problem accessing your profile.</p>';
    }

//HTML CODING
<label for="dob" class="label">Date Of Birth</label>
<select id="dob_day" name="dob_day" value="<?php if (!empty($dob_day)) echo $dob_day; ?>">
<option>
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
?>

Insert Select Options Into This Code

Similar Tutorials

View Content

Hi, I'm really at a loss here. I have queried a table to get an option list, which returns what I expect but I need to then add it to some current code instead of the fixed option list presented. The syntax is beyond me. Please see attached. Any pointers would be great. Attached Files OptionList.txt 1.61KB 7 downloads

How Do I Change This Code From A Checkbox To A Select Menu

Similar Tutorials

View Content

Howdy everyone, please i need help changing a php coded form from a checkbox to a select menu. Here's the form.

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" >
            <table class="dtable2">
<tr><th colspan="5">Enter a domain name:</th></tr>
            <tr><td colspan="5"><center>www.<input name="domain" type="text" size="35" /></center></td></tr>
<tr><th colspan="5">Select an extension:</th></tr>
            <tr>
<?php
   $i = 0;
foreach ($this->serverList as $value) {
if ($value['check'] == true) $checked=" checked ";
      else $checked = " ";

      echo '<td><input type="checkbox" name="top_'.$value['top'].'"'.$checked.'/>.'.$value['top'].'</td>';
$i++;
      if ($i > 4) {
        $i = 0;
        echo '</tr><tr>';
      }
   }

?>
            </tr>
            </table>
            <center><input type="submit" name="submitBtn" class="sbtn" value="Check" /></center>
</form>
<?php

I'll really appreciate your help.

Help Add A Drop List To <input Field Or Change This Code To A <select Option?

Similar Tutorials

View Content

I have a search function in php where the text characters are matched to characters in a tables field--- works perfectly....
I need to make the input box have a droplist of words from database, this is also easy for me to do. the problem here is there is no definitive value! the options list always outputs a blank in the url---

its supposed to search a matching value and then output the matching value to url...

Here is the droplist code:

$output['RATESTITLE']='<input class="inputbox" type="text" size="24px" name="ratestitle" value="'.$sch->filter['ratestitle'].'" onfocus="if (this.value ==\''.$output['LANGUAGE_SEARCH_RATESTITLE'].'\') {this.value = \'\'}" />';

this outputs a input text box--- i want to have a droplist of options to populate this text box...
If you must know this is the third day im at it...

Need Help With Data Entry Code

Similar Tutorials

View Content

Dear All,

I am developing a website www.computationalphotography.in on which I need to register new users. I have designed an HTML form for this purpose,
but will need help with writing the code for checking and validating the data in the respective fields. The code for my web form is below and the address
of the website is www.computationalphotography.in/registration.php:

Code: [Select]
<html>

<head>

<title>

Photography Experiment Registration
</title>

</head>

<body>

<h1>

Questionnaire
</h1>

<h3>
We would like to know about your background and interests in photography. For each multiple-choice question, please circle all answers that apply.</h3>
<form method="post" action="registration.php">

Name
<input name="name" type="text">
<br>
<br>
Email

<input name="email" type="text">
<br>
<br>
1.) Roughly How many pictures do you take each year?
<br>
<br>
<input name="radios" type="radio" value="a">
a) a few: <10 in a year
<br>
<input name="radios" type="radio" value="b">
b) many: probably 100's a photos a year
<br>
<input name="radios" type="radio" value="c">
c) a lot: probably 1000's of photos a year
<br>
<br>

2.) Do you share your pictures with anyone?
<br>
<input name="radios" type="radio" value="a">
a) No
<br>
<input name="radios" type="radio" value="b">
b) Yes, but only with friends or family
<br>
<input name="radios" type="radio" value="c">
c) Yes, I share with friends or family and also post on public sites such as Flickr, Picasaweb, or Snapfish for anyone to see.
<br>
<input name="radios" type="radio" value="d">
d) Yes, I share frequently and I have also published my photos in books or magazines, or exhibitde my photos in shows.
<br>
<br>

3.) How much training in photography have you had?
<br>
<input name="radios" type="radio" value="a">
a) None
<br>
<input name="radios" type="radio" value="b">
b) Some, but it's self-taught from books or websites
<br>
<input name="radios" type="radio" value="c">
c) Quite a bit: I have taken courses in photography
<br>
<input name="radios" type="radio" value="d">
d) A lot:I have completed a degreee or certificate in the subject
<br>
<br>

4.) How do you describe yourself as a photographer?
<br>
<input name="radios" type="radio" value="a">
a) A novice:someone who takes a few pictures occasionally
<br>
<input name="radios" type="radio" value="b">
b) An amateur:someone who takes many photos, but doesn't usually share them
<br>
<input name="radios" type="radio" value="c">
c) An enthusiast:someone who loves to take pictures, possibly shows them with oters on public sites, or who might own a DSLR, or frequently uses a camera in other than "automatic mode"
<br>
<input name="radios" type="radio" value="d">
d) An expert:skilled photographer who has published their work, or exhibited their work in shows, or has been paid for their work
<br>
<br>

5.) Do you have artistic training or exposure?
<br>
<input name="radios" type="radio" value="a">
a) No
<br>
<input name="radios" type="radio" value="b">
b) I visit museums or art galleries
<br>
c) I have studied art: please describe
<br>
<textarea name="data5c" cols="50" rows="5">
</textarea>
<br>
d) I am a practicing artist: please describe
<br>
<textarea name="data5d" cols="50" rows="5">
</textarea>
<br>
<br>
6.) Some optional information, if you don't mind. We respect your privacy.
<br>
<br>
Age
<br>
<textarea name="6a" cols="1" rows="1">
</textarea>
<br>
<br>
Gender
<br>
<input name="radios" type="radio" value="a">
a) Male
<br>
<input name="radios" type="radio" value="b">
b) Female
<br>
<br>
Languages Spoken
<br>
<textarea name="6b" cols="25" rows="2">
</textarea>
<br>
<br>
Languages Read
<br>
<textarea name="6c" cols="25" rows="2">
</textarea>
<br>
<br>
<br>
<input type="submit" value="Send">

<input type="reset" value"Reset">

</form>

</body>

</html>

Kindly help me out with this issue. Thank you for your help in this regard.