PHP - Include Mysql Numrows

Hi all,
I'm wondering if it's possible to use the $numrows boolean parameter where $numrows = 0 and meets a condition.

For instance, my code is set up to check for classes where $numrows>0 and then displays the classes. If $numrows < 1, it echoes a message saying there are no classes available and to call the training department. I would like to redirect one of the classes to another link by using a strpos function to search for the classname within the URL. As I understand it, I would have to embed it in the else part of the statement if it's at all possible.

Here's what I have so far.
if ($numrows > 0)
{
  echo "<p align=\"left\" class=\"style2 style4\">Click in the check box next to the date for which you would like to register: </p>";
  echo "<p align=\"left\" class=\"style2 style4\">" . $_GET['classname'] . "</p>";
  echo "<table width=100% style=\"color:#FFFFFF\">";
  echo "<th></th>";
  echo "<th>Date</th>";
  echo "<th>Time</th>";
  echo "<th>Location</th>";
  echo "<th>Instructor</th>";
  while ($results = mysql_fetch_array($rs)){
      echo "<tr>";
      echo "<td><input type=\"radio\" name=\"checkbox\" value=\"" . $results['date'] . "|" . $results['time'] . "|" . $results['location'] . "|" . $results['instructor'] . "|" .   $results['course'] . "\"" . "></td>";
      echo "<td class=\"style11\">" . $results['date'] . "</td>";
      echo "<td class=\"style11\">" . $results['time'] . "</td>";
      echo "<td class=\"style11\">" . $results['location'] . "</td>";
      echo "<td class=\"style11\">" . $results['instructor'] . "</td>";
      echo "</tr>";
  }
  echo "</table>";
}
elseif (strpos($_REQUEST['classname'], "BloodBorne Pathogens Video"));
{
echo "Bloodborne Pathogens is exclusively offered online. Please <a href=../training/online_courses/Bloodborne/BB.html>click here</a> to take the course.";
}
else
{
echo "Please call the training department as there are no classes scheduled at this time."
}

Please let me know if this is even possible or if I'm off my rocker. I'm fairly new to the PHP world but not a newb

Thanks a bunch for your time!

Hi All,

pls help me with this
I have include a 'connect.php' but it resulted error

"mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\carpark\viewcars.php on line 21"

but if I dont use php include then everything works fine,,, below the code :

<?php


include "connect.php";

echo "<table border='1' id='position'>
<tr>
   <th>Ticket</th>
   <th>Car Name</th>
   <th>Car Out</th>
</tr>";

$result=mysql_query("select * from car");

while ($row=mysql_fetch_array($result))
   {

   echo "<tr>";
   echo "<td>".$row['ticket']."</td>";
   echo "<td>".$row['carname']."</td>";
   echo "</tr>";
}
echo "</table>";



mysql_close();
?>

connect.php
<?
$host="localhost";
$user="root";
$password="";

mysql_connect($host,$user,$password);

mysql_select_db("car");
?>

If I use below ,,everything works fine ... what went wrong ???

<?
$host="localhost";
$user="root";
$password="";

mysql_connect($host,$user,$password);

mysql_select_db("car");
echo "<table border='1' id='position'>
<tr>
   <th>Ticket</th>
   <th>Car Name</th>
   <th>Car Out</th>
</tr>";

$result=mysql_query("select * from car");

while ($row=mysql_fetch_array($result))
   {

   echo "<tr>";
   echo "<td>".$row['ticket']."</td>";
   echo "<td>".$row['carname']."</td>";
   echo "</tr>";
}
echo "</table>";
mysql_close();
?>

I am trying to insert a record into a mysql database which has a $ as part of the value of a field.  But it seems that when the INSERT query is processed its actually looking for a variable with that name and not just inserting the raw text.  Here is the insert query


$query = "INSERT mytable SET myfield='I would like to have this field contain this information with a $matches[1] showing in the field value as well'";


$matches[1] has no value.  Its not a variable which is in this script.  I am not trying to insert the value of it.  I just want to insert the actual text characters $matches[1]

How can I do that?

Hi,

This is an odd one (to me anyway). I've created an API for deploying gig information in either XML or JSON format.

It works fine as it is, both formats of output giving me what I want.

When I take out the mySQL login information and replace it with "include 'connect_include.php';" (where the file connect_include.php contains the exact login code that I replced).
The JSON output works fine but the XML output doesn't run.

What could be causing this??


JSON API: -http://www.api.the-guards.co.uk/jsontest.php?apikey=123456&format=json

XML API: - http://www.api.the-guards.co.uk/jsontest.php?apikey=123456&format=xml


API code:
Code: [Select]
<?php
if (($_GET['apikey'])==123456 and isset($_GET['format'])){

//Set variables
$format = strtolower($_GET['format']);

//Connect to the Database
 include 'connect_include.php';

//Run our query
$result = mysql_query('
SELECT * 
FROM tg_gig_list 
where
gl_date >= curdate()
and gl_publish = 1
order by gl_date

 ');

//Preapre our output
if($format == 'json') {

 while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{ 
$array[] = array($row['gl_date']=>($row['gl_venue'].', '.$row['gl_city']));
};


$output = json_encode($array);




//Output the output.
echo $output;
header('Content-type: application/json');

}

elseif($format == 'xml') {
header('Content-type: text/xml');
$output  = "<?xml version=\"1.0\"?>\n";
$output .= "<tggiglist>\n";

for($i = 0 ; $i < mysql_num_rows($result) ; $i++){
$row = mysql_fetch_assoc($result);
$output .= "<giglist> \n";
$output .= "<giglist_date>" . $row['gl_date'] . "</giglist_date> \n";
$output .= "<giglist_venue>" . $row['gl_venue'] . "</giglist_venue> \n";
$output .= "<giglist_city>" . $row['gl_city'] . "</giglist_city> \n";
$output .= "</giglist> \n";
}

$output .= "</tggiglist>";

}


}
else {
die ('no way');
}

//output the output
echo $output;
?>
Contents of 'connect_include.php:

Code: [Select]
<?php 
 
mysql_connect("database.lcn.com", "dbname", "password") or die(mysql_error()); 
mysql_select_db("db") or die(mysql_error()); 
 ?>
 .....this is the same code that I replaced.

Obviously, the 'connect' works ok as the JSON version runs fine. There's something being added to the scripting when I use the include file that isn't there when the code goes straight in.....I think????

I've a simple Inset List (jQuery Mobile) of several items with a Flip switch, Drop down, check box and Slider elements.

I have wrapped this Inset List inside a HTML Form.

<code>
<div data-role="fieldcontain">
      <ul data-role="listview" data-inset="true">
        <li data-role="list-divider"> Inhouse capabilities </li>
        <li> <label for="flip-b">Project Manager</label>
            <select name="slider" id="flip-b" data-role="slider">
                <option value="no">No</option>
                <option value="yes">Yes</option>
            </select>
         </li>   
        <li> <label for="flip-b">Site Supervisor</label>
            <select name="slider" id="flip-b" data-role="slider">
                <option value="no">No</option>
                <option value="yes">Yes</option>
            </select>
        </li>
         <li><label for="flip-b">Architect</label>
            <select name="slider" id="flip-b" data-role="slider">
                <option value="no">No</option>
                <option value="yes">Yes</option>
            </select>
          </li>
        <li><label for="flip-b">Builderworks</label>
            <select name="slider" id="flip-b" data-role="slider">
                <option value="no">No</option>
                <option value="yes">Yes</option>
            </select>
          </li>
          <li><label for="flip-b">Electrical</label>
            <select name="slider" id="flip-b" data-role="slider">
                <option value="no">No</option>
                <option value="yes">Yes</option>
            </select>
          </li>
          <li><label for="flip-b">Mechanical</label>
            <select name="slider" id="flip-b" data-role="slider">
                <option value="no">No</option>
                <option value="yes">Yes</option>
            </select>
          </li>
          <li><label for="flip-b">Hydraulics</label>
            <select name="slider" id="flip-b" data-role="slider">
                <option value="no">No</option>
                <option value="yes">Yes</option>
            </select>
          </li>
          <li><label for="flip-b">Joinery</label>
            <select name="slider" id="flip-b" data-role="slider">
                <option value="no">No</option>
                <option value="yes">Yes</option>
            </select>
          </li>
          <li>
                <label for="select-choice-1" class="select">Main Location:</label>
                   <select name="select-choice-1" id="select-choice-1">
                      <option value="NSW">NSW</option>
                      <option value="ACT">ACT</option>
                      <option value="VIC">VIC</option>
                      <option value="SA">SA</option>
                      <option value="QLD">QLD</option>
                      <option value="NT">NT</option>
                      <option value="WA">WA</option>
                      <option value="TAS">TAS</option>
                    </select>                     
          </li> <!-- Select Menus: Main Location-->

            <li>     
                <div  data-role="fieldcontain">
                <fieldset data-role="controlgroup">
                    <legend>CBA Reference</legend>
                    <input type="checkbox" name="checkbox-1a" id="checkbox-1a" class="custom" />
                    <label for="checkbox-1a">Commercial</label>
                    <input type="checkbox" name="checkbox-2a" id="checkbox-2a" class="custom" />
                    <label for="checkbox-2a">Retail</label>
                </fieldset>
                </div>
            </li>                         
 </ul>             
    </div> <!-- End of Field Contain div tag -->   
 <a href="#additionalinfo" data-role="button" data-inline="true" data-iconpos="left" data-theme="b">Additional Info</a>
<a href="./search2.html" rel="external" data-ajax="false" data-role="button" data-inline="true" data-icon="search" data-iconpos="left" data-theme="e">Search</a>
</code>

I want to know, how I can include only the elements the user selected in my SQL query.
Lets say, User wants to find the Electrical workers in QLD, then he will select Yes for Electrical and QLD as Main Location and the other items he would not touch.
Now, how can I include only those two values in the select clause.
Say, Select Electrical, Main Location from table where Main location='QLD'.
I used POST method to gather users input. I use PHP, MySQL for this project.
Any ideas on how to achieve this.

Regards Sandeep