PHP - Storing Queries Into One Variable

Hopefully someone can help, firstly i am a newbie at php coding but keen to learn more.   Here is my problem    The database is built correctly with all the information i need, the first part is the dropdown menu which you select a car, next you choose a month and mileage - from there it shall show you the correct price for each one. There is columns for each price, mileage and months i just need to figure out how best to start this thing.   I first started by this   $query = "SELECT DISTINCT Full_Description FROM import"; 

Hi there,

I am working on a PHP web form and I have a very simple situation I guess, I have a variable named: $MyVal

When I do

print_r($MyVal);
To see whats inside, I get:

SimpleXMLElement Object ( [0] => 8.23 )
Now I am assigning this variable into a session variable so that I can do calculations with it.

So I assign:

$_SESSION['MySesVal'] = $MyVal;
But after assigning to session variable, when I do my calculations:

$finalValue = $_SESSION['MySesVal'] * 4;

I get 0. So is it because the actual $MyVal variable has some XML stuff as:

SimpleXMLElement Object ( [0] => 8.23 )

So what is the right way to properly assign $MyVal variable to a session variable to do calculations.

Please reply.

All comments and feedbacks are always welcome.

Thank you!

I have a submit.php file that includes the following jQuery code:

<script> [...] request.done(function( json ) { jQuery('input[name=thumbnail-url]').val(json.thumbnail_url); jQuery('input[name=job_title]').val(json.title); jQuery('textarea[name=htmlcode]').val(json.html); [...] </script>

I need to remove

jQuery('textarea[name=htmlcode]').val(json.html);

and pass the "json.html" value into a PHP variable in another php file (functions.php).

The code in the functions.php file is already there.

The thing i need to do (and i am seriously struggling with it) is placing the value of json.html into a $phpvariable that i can then call from the function.php file.

Do you need any more info for this issue?

Thanks.

Hi,

Hey guys - me again!

I have a discount box, where i wish to check two "if" queries.  These are i) the 'uniquecode' and ii) the 'uses' - so a code can only be used a set amount of times.

1) How do i state that question in php, bearing in mind the "if uses > 0" needs to relate to the same row as the unique code entered?

2) Also, i have stored the session price in $_SESSION['sessionprice'] - is this the best way to do this, and if not how should i store the current price. 

3) Lastly, and how do I do the php mathematics of "$_SESSION['sessionprice'] minus the discount" - again bearing in mind the "discount" needs to relate to the same row as the unique code entered? (as different codes will have different discounts).


This is how far i've gotten:

Code: [Select]
<?php
//connection settings bla bla bla

$uniquecode = $_POST['discountcode'];

mysql_connect($localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$discountcodecheck = mysql_query("SELECT uniquecode FROM discounttable WHERE uniquecode = '".$uniquecode."'");
$remainingusescheck = mysql_query("SELECT uses FROM discounttable WHERE uniquecode = '".$uniquecode."'");

if (mysql_num_rows($discountcodecheck) > 0) and if (mysql_num_rows($remainingusescheck) > 0)  // <-- this "and if" doesn't work
{
// discount calculation:
// session price minus the unique code's corresponding discount
// update $_session['discountammount']

}
else
{
?><script type="text/javascript">
alert("Discount Code Entered Is Either Not Valid Or Has Been Previously Used.");
        history.back();
      </script><?php
}

// rest of code and close connection
?>

Any help or comments will, as always be politely welcomed and appreciated

Cheers,

Tom.

ive had these queries working okay until i checked on it today, it's not working anymore..
these are the errors:::
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\arrastre\add.php on line 105
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\arrastre\add.php on line 117


if(isset($_POST['add'])){
if($billnmbr=="" or $orno=="" or $payor=="" or $arrastre=="" or $wharfage=="" or $total=="" or $date=="" or $tcl==""){
echo "At least one field was left blank.";
}
else{
$query = mysql_query("select * from `arrastre` WHERE `billnmbr`='$billnmbr'"); /*****************this is my line 105************/
$count = mysql_num_rows($query);
if($count==1){
echo "This billnumber is already in the database.";
}

else{
$bll = strtoupper($billnmbr);
$payr = strtoupper($payor);
$query="insert into `arrastre` (`billnmbr`, `orno`, `payor`, `arrastre`, `wharfage`, `total`, `date`, `tcl`)
values ('$bll', '$orno', '$payr', '$arrastre', '$wharfage', '$total', '$date', '$tcl')";
$result=mysql_query($query);

$query = mysql_query("select * from `arrastre` where `billnmbr`= '$billnmbr'", $link); /************and this is my line 117*************/
$count = mysql_num_rows($query);
if($count==1){
echo "last bill number added: ".$billnmbr;
}
}
Thank you very much for your time and have a nice day.

noob question: I have following two queries I'd like to combined into one - how is this done?

$temp = @mysql_query("SELECT * FROM purchased_leads WHERE leadID = '{$_REQUEST[leadid]}'");

"SELECT refundNotes FROM leads WHERE leadID = '{$_REQUEST[leadid]}'"

Good day everyone. I go by the nickname Sbosh and I am a newbie in PHP.

I am currently learning php using video tutorials. I need help with regards to php queries.

I have the following code:

"SELECT 'food', 'calories' FROM 'diet' ORDER BY 'id'"

which is supposed to display content from a table inside phpmyadmin which i created manually using phpmyadmin. But It gives an error saying i must check the MariaDB version on how to right this query, something like that.

Please assist on the proper way of writing this code. Again I am a newbie in PHP and just starting to learn, so your help will be highly appreciated.

Hello all,

I've tried several ways to calculate a commission in the multi level marketing script, but it all ended up with nothing, recursive functions, nested sets nothing worked, and i'm running out of time to keep trying

I've made multiple queries on the same table, and it's working, but only the first 3 queries, not more, I tried to perform it 4 times (although I need the queries to be performed 13 times) but still only 3 times

example: A recruited B and C, and B recruited D, and D recruited E.... what's supposed to happen is A takes a commission on B, C, D, and E
but now it only takes commission on the first three, and no commission for anyone comes after that, and the same for B, C, D, and E each takes commission on only 3 members down the line, and no more

here is the queries

Code: [Select]
<?
 $result = mysql_query("SELECT * FROM users");


echo "<table width='589' border='1'>
<tr>
<th>ID</th>
<th>Name</th>
<th>National ID</th>
<th>Commission</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
 
$query = mysql_query("SELECT * from users where recruiteris = '".$row['id']."'");
$num_rows=mysql_num_rows($query);

              $id1 = $row['id']; 
               
                $commission = $num_rows;
               
               
            $_SESSION['id1'] = $id1;
               
  echo "<tr>";
  while ($roww = mysql_fetch_array($query))
  {
  $querry=mysql_query("select * from users where recruiteris = '".$roww['id']."'");
    $num_rowss = mysql_num_rows($querry);
  while ($rowws= mysql_fetch_array($querry))
   { $var3= '10';

  $querrys=mysql_query("select * from users where recruiteris = '".$rowws['id']."'");
    $num_rowsss = mysql_num_rows($querrys);
   while ($rowwss= mysql_fetch_array($querrys))
   
   {
    $querryss=mysql_query("select * from users where recruiteris = '".$rowwss['id']."'");
    $num_rowssss = mysql_num_rows($querryss);
   while ($rowwsss= mysql_fetch_array($querryss))
   {
   
   
    $querryr=mysql_query("select * from users where recruiteris = '".$rowwsss['id']."'");
    $num_rowssr = mysql_num_rows($querryr);
    }
    }
    }
    }
    $total= ($commission + $num_rowws + $num_rowwss + $num_rowwsss + $num_rowss + $num_rowssr) * $var3;
 echo  "<td><a href=\"user.php?id=".$row['id']."\">".$row['id']."</a></td>";
echo "<td>" . $row['fname'] .''. $row['lname'] ." </td>";
 echo"<td> ". $row['nid'] ." </td>";
  echo  "<td>".$total."</td>
   </tr>";
  }
 
echo "</table>";
        ?> 

Hi, I am trying two compare to dates but have not been successful.

A row is filled in Mysql database called htime with   $check=mktime(17,0,0,04,10,2011);

My first question is  that in the mktime function I have entered 17 which is hours. I would like to know if thats like the 17th hour of the given day or thats not how it works?

My second question is it a valid query to use <= or >= or < in a  mysql query for example.

$query="SELECT * FROM hdb WHERE htime <='".time()."'";

Thirdly I want to know if a row is filled with mktime(17,0,0,04,10,2011);  for example How can I only extract the day from the database based on the time has passed? This is because my own query doesnt seem to be working which is the query above I have no errors but the results dont seem to be right. Any help is much appreciated thanks.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=331128.0

The first query goes through but the second does not just seeing if I'm missing something.

<?php

// Include the database page
require ('../inc/dbconfig.php');

if (isset($_POST['submittitle'])) {
    $titlename = mysqli_real_escape_string($dbc, $_POST['titlename']);
    $titleshortname = mysqli_real_escape_string($dbc, $_POST['titleshortname']);
    $titlestyle = mysqli_real_escape_string($dbc, $_POST['titlestyle']);
    $titlestatus = mysqli_real_escape_string($dbc, $_POST['titlestatus']);

    $query = "INSERT INTO `titles` (titlename, titleshortname, style_id, status_id, creator_id, datecreated) VALUES ('$titlename','$titleshortname','$titlestyle','$titlestatus', 1, NOW())";
    mysqli_query($dbc, $query);
    $query_id = mysqli_insert_id($dbc); 
    $query1 = "INSERT INTO `champions` (title_id) VALUES ('$query_id')";
    mysqli_query($dbc, $query1);  
}
?>

Here is the original query:

Code: [Select]
$query_extract = mysql_query("SELECT downloads,date,title,username,views,id FROM skins ORDER BY id DESC LIMIT 100");

Is it possible to also grab the row username from the table users, without making multiple queries?

Can any boy clarify these queries.
How do I find out if an array has values posted to each of its elements? I need to know that EVERY element has been filled out.
How can I send variables from a PHP script to another URL using POST without using forms and hidden variables?

UPDATE: If I remove lastedit = NOW() from the query, and just leave SET content = $var, it works. :/

If already double checked to see if a user would make it to this point in the code, and they do. And the variable $pid IS assigned a value. I've also done a quick check and changed the UPDATE queries to SELECT queries, and then echoed out the number of rows and it returned a successful result. Yet, people still can't seem to have their posts updated...why?

My code:

//if it's a thread, update the thread, if it's a post, update the post
if($type == 2)
{
//update thread
mysql_query("UPDATE threads SET lastedit = NOW() AND content = '{$content}' WHERE id = {$id}") or die(mysql_error());

//send them to their post
redirect('viewthread.php?forum='. $forum_id .'&id='. $id .'&page='. $page);
}
else
{
//update post
mysql_query("UPDATE posts SET lastedit = NOW() AND content = '{$content}' WHERE id = {$pid}") or die(mysql_error());

//send them to their post
redirect('viewthread.php?forum='. $forum_id .'&id='. $id .'&page='. $page .'&post='. $post);
}