PHP - Compare Result Of Mysql Statement To String In Php

Hi All,

I have a select statement

	$stmt = $conn -> prepare('
	                         SELECT u.user_firstname, u.user_lastname, so.staff_id, r.role_name
	                         FROM ssm_staff_order so
	                         INNER JOIN ssm_user u on so.staff_id = u.user_id
	                         INNER JOIN ssm_role r on u.user_role_id = r.role_id
	                         WHERE job_id = ?
	                         ');
	$stmt -> bind_param('i', $jid);
	$stmt -> execute();
	$stmt -> bind_result($fn, $ln, $id, $role);

The result looks like this

+----------------+---------------+----------+-----------+
| user_firstname | user_lastname | staff_id | role_name |
+----------------+---------------+----------+-----------+
| FName          | LName         |        8 | Chef      |
| jon            | smith         |       15 | Manager   |
| Chelsea        | Hockley       |        2 | Manager   |
+----------------+---------------+----------+-----------+

I am wanting to build an array so that i can foreach the result with the people under the header of their role.

I know this is not difficult but i am going around and around with it and clearly missing the key part.

As always your help is appreciated.

Hey, I'm new to this stuff. But I'm calling a Table with a list of products, I want people to be able to compare the products they checked. what is the best way of doing this with the code below?
I put "blah" for everything except for the compare table and calls. This code seemed to work the best for the look I wanted for it. They all call the checkbox from 'Compare' in the mysql table.

Thanks!

$result = mysql_query("SELECT * from Compare_Tool ORDER BY Blah ASC");
//Table starting tag and header cells

echo "<table border='1'><tr><th>Compare</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th><th>blah</th></tr>";

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

?>

<tr>

<td align="center"><input name="checkbox[]" type="checkbox" Compare="checkbox[]" value="<? echo $row['Compare']; ?>"></td>

<td ><? echo $row['blah']; ?></td>

<td ><? echo $row['blah']; ?></td>

<td ><? echo $row['blah']; ?></td>

<td ><? echo $row['blah']; ?></td>

<td ><? echo $row['blah']; ?></td>

<td ><? echo $row['blah']; ?></td>

<td ><? echo $row['blah']; ?></td>

<td ><? echo $row['blah]; ?></td>

<td ><? echo $row['blah]; ?></td>

<td ><? echo $row['blah]; ?></td>

<td ><? echo $row['blah]; ?></td>

</tr>

<?php }  echo "</table>";

?>

Has anyone got any script or refence to a tut where i can find a script that compares two mysql database (current) and outdated db and then takes the current db and updates the outdated one to match accordingly. Thanks

Hi,

I need to compare records in a table based on the 'datetime' field, like if the difference between time is less than 15min.

need to combine the records(rows) as a single resultant row until the time difference between them  is less than 15min and when a record's time difference is >15min that should return as another row and so on. Please find following sample table and the required output format

Sample Table:

Code: [Select]
ID NAME DATETIME
1   aaa    2011-10-10 06:30:00
2   bbb    2011-10-10 06:33:00
3   ccc    2011-10-10 06:38:00
4   ddd    2011-10-10 06:40:00
5   eee    2011-10-10 07:10:00
6   ffff    2011-10-10 07:14:00
7   sss    2011-10-10 08:16:00
8   jjj    2011-10-10 08:26:00
9   kkk    2011-10-10 08:28:00
10  mm    2011-10-10 09:46:00
11  ppp    2011-10-10 09:49:00
12  qqq    2011-10-10 09:52:00


Output Needed :

Code: [Select]
IDs START DATETIME END DATETIME
1,2,3,4 2011-10-10 06:30:00 2011-10-10 06:40:00
5,6 2011-10-10 07:10:00                      2011-10-10 07:14:00
7,8,9 2011-10-10 08:16:00 2011-10-10 08:28:00
10,11,12 2011-10-10 09:46:00                      2011-10-10 09:52:00

You can see 1st row in the output table having IDs 1,2,3,4 coz the time difference between them is less than 15minutes (it doesn't means time difference between start and end; it is actually the  time difference between current record and previous one ; ie; ID-1 and ID-2 have difference less than 15min and ID-2 & ID-3 have difference less than 15min and ID-3 & ID-4 have difference less than 15min, so those 4 records combine together as a single row also shows their start time and end time. Then you can see diff between ID-4 and ID-5 is greater than 15 min so it should display as new row, and so on)

How can I acheive above Output with mysql query ??

Please help..

I am retrieving a rowfrom a table and when I post the row variable it doesnt read it.
___
$query = "SELECT * FROM $tbl_name";
   
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
   echo $row['name'];
   echo "<br />";

$postinfo = 'p_doctor_name=' . $row .'&p_name_type=A&p_search_type=BEGINS';
__
This outputs p_entity_name=&p_name_type=A&p_search_type=BEGINS
Note that it is missing $row

Do I need to put it in an array?

I need an if statement, but i have no idea how or if it can be done.

If a text string is greater than 10 characters, {echo $string}   else{  print $error }
<?php

$string = '1900800008';
$error = 'String isn't long enough';
if(  ?????????  ){echo $string}
else{  print $error }

?>

Hello again.

I run a sports league website and registrations received after a certain date need to have their league fees calculated to add 10%.  someone wrote this for me a couple of years ago, but I have since then lost the full code.  Need to know how to add a date to the follow statement that would automatically add the 10%. 

Can someone look at this for me and fill me in on what's missing?
Thanks!
Code: [Select]
    /*
     * Calculate fees
     */
    $intSize = intval($arrLeagueSearch['size']);
    switch($intSize)
    {
        case 2:
            $dblBase = 150.00;
            $intBSize = 3;
            break;
        case 4:
            $dblBase = 330.00;
            $intBSize = 6;
            break;
        case 6:
            $dblBase = 550.00;
            $intBSize = 10;
            break;                       
        default: die("Invalid league size");
    };
 
    $dblEarlyTeam = $dblBase;
    $dblEach = $dblEarlyTeam / $intPlayers;
/*
    $dblLateTeam = $dblEarlyTeam * 1.10;
    $dblLateEach = $dblLateTeam / $intPlayers;
*/

I am trying to figure out how to have an if statement in the middle of strings I am trying to concatenate. I have a from that has a address1 and address2, where address2 often does not exist. So I want to only add that line if there is actually content. I was trying something like the following, but that is giving me an error. I am pretty new to php, so I can't seem figure it out. Any help would be greatly appreciated.

Code: [Select]
"<p><strong>Address 1: </strong><br>" . $address1 . "<br>"
if ( isset($address2) ) { echo . $address2 . "<br>" }
. $city . ", " . $state . " " . $zip . "</p>"

Hi,
My issue here is that I cant get my query string variables to ONLY feed into if/else statement  on my secondary page. I include my secondary page (fine.php) from my index page. My query string variables keep being fed back into my original if/ese statement on index.php.

here is the if/else on index.php (these links work fine):

<?php
if($_SERVER['QUERY_STRING']=='/index.php' || $_SERVER['QUERY_STRING']=='')
{
include 'port.php';
}

elseif (isset($_GET['pos'])){
include 'pos.php';
}

elseif (isset($_GET['web'])){
include 'web.php';
}

elseif (isset($_GET['fine'])){
include 'fine.php';
}

        else {include '404.php';}






here is the if/else on my secondary page (fine.php). These links are supposed to alert the if/else in the next table cell. However, they instead alert the if/else in index.php.


<td><br/>
<a href="?backset"><img src="fine/thumbs/x-backset.jpg" border="0"></a><br/><br/> 
<a href="?backside"><img src="fine/thumbs/x-backside.jpg" border="0"></a><br/><br/> 
<a href="?bannerprint"><img src="fine/thumbs/x-bannerprint.jpg" border="0"></a><br/><br/> 
<a href="?chopu"><img src="fine/thumbs/x-chopu.jpg" border="0"></a><br/><br/> 
</td>
<td><br/>
<div id="DivPiece" align="left">
<?PHP 

if (isset($_GET['backset'])){
       include 'fine/backset.php';
}

elseif (isset($_GET['backside'])){
     include 'fine/backside.php';
}

elseif (isset($_GET['bannerprint'])){
     include 'fine/bannerprint.php';
}

elseif (isset($_GET['chopu'])){
include 'fine/chopu.php';
}

?>
</div>
</td>



How can I get the links on the secondary page to only alert the if/else statement on that page, and BLOCK the if/else statement on index.php from seeing them? I still want to use the query string though.

Thanks!
[/quote]

How can I check if a returned mysql value is equal to '' i.e. nothing?

I keep getting an error where the page won't load because the returned value is '' so i need to check for it

Hi,

I don't know anything about php and Mysql but I found a tutorial for a shopping cart and everything is working.
The only thing is they don't have the email part in the totorial so I'm kind of stuck with my file.
Anyone know how to email the resul to me via email with this code?

<?
   include("includes/db.php");
   include("includes/functions.php");
   
   if($_REQUEST['command']=='update'){
      $name=$_REQUEST['name'];
      $email=$_REQUEST['email'];
      $address=$_REQUEST['address'];
      $phone=$_REQUEST['phone'];
      
      $result=mysql_query("insert into customers values('','$name','$email','$address','$phone')");
      $customerid=mysql_insert_id();
      $date=date('Y-m-d');
      $result=mysql_query("insert into orders values('','$date','$customerid')");
      $orderid=mysql_insert_id();
      
      $max=count($_SESSION['cart']);
      for($i=0;$i<$max;$i++){
         $pid=$_SESSION['cart'][$i]['productid'];
         $q=$_SESSION['cart'][$i]['qty'];
         $price=get_price($pid);
         mysql_query("insert into order_detail values ($orderid,$pid,$q,$price)");
      }
      die('Thank You! your order has been placed!');
   }
?>
<!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>Billing Info</title>
<script language="javascript">
   function validate(){
      var f=document.form1;
      if(f.name.value==''){
         alert('Your name is required');
         f.name.focus();
         return false;
      }
      f.command.value='update';
      f.submit();
   }
</script>
</head>


<body>
<form name="form1" onsubmit="return validate()">
    <input type="hidden" name="command" />
   <div align="center">
        <h1 align="center">Billing information</h1>
        <table border="0" cellpadding="2px">
           <tr><td>Total:</td><td><?=get_order_total()?></td></tr>
            <tr><td>Name :</td><td><input type="text" name="name" /></td></tr>
            <tr><td>Address :</td><td><input type="text" name="address" /></td></tr>
            <tr><td>Email :</td><td><input type="text" name="email" /></td></tr>
            <tr><td>Phone :</td><td><input type="text" name="phone" /></td></tr>
            <tr><td>&nbsp;</td><td><input type="submit" value="Place Order" /></td></tr>
        </table>
   </div>
</form>
</body>
</html>

Hello, i created this script for a client and have ran into an annoying error with the results displaying on a new line for each result instead of side by side, any help is welcome

Cheers

Code: [Select]
  <?php
  $subcat = mysql_real_escape_string(strip_tags(htmlspecialchars(protect($_GET['subcat']))));
  $cat =  mysql_real_escape_string(strip_tags(htmlspecialchars(protect($_GET['cat']))));
$sql = @mysql_query("SELECT * FROM cakes WHERE category =\"$cat\" AND sub_cat=\"$subcat\" ORDER BY id DESC");
while ($row = mysql_fetch_array($sql)) {
$reference = $row['reference'];
$image = $row['image'];
echo ("<p><img src='./images/cakes/$image' height='289px' width='177px' alt='IMAGE OF CAKE'></img><br />");
echo ("<b>Reference:</b>$reference"."</p>");
}
if (!$reference) {
echo 'There are no cakes in this category yet.';
}
?>
I know the errors only going to be something small i'm missing, but i've been coding all day

Im not sure where to post this but since it includes php il post it here instead of in the mysql forum.

ok so, i have a table and i get the values using while($row = mysql_fetch_array($result)){ and then echo them in rows.

that works fine but i need to add a class to the last row of my table. I would need somehow to fetch the last row of the array and make it echo something different.

Any help is appreciated

Thank you

hello
I'm using this code:
Code: [Select]
$query="SELECT * FROM `second_content` WHERE CHANGED =0 limit 0,1";to query first row data when I want see it and echo it I recived :
Code: [Select]
Resource id #2can anyone help me ?


thank you

Hello Everyone,
I have a quick question for you all, I think its fairly simple...
I have created a database and I am using PHP to grab the data:


$usera = $_SESSION['username'];
$query2 = "SELECT * FROM tracker WHERE id = '$usera', hidden = yes";
mysql_query($query2) or die('Error, query failed : ' . mysql_error()); 


This hopefully will return multiple rows which look like this in the database.

id username date reps hidden 1 supremebeing 2011-01-02 30 yes 4 supremebeing 2011-04-02 46 yes
How would i turn each result into a variable eg:


$date1 =  2011-01-02;
$date2 =  2011-04-02;
$reps1 = 30;
$reps2 = 46;


I think i have explained that well enough for you to understand, please reply if not though and i will provide more information.

Thanks in Advance