PHP - Php Pdo Variable Not Working In Query But Static Value Works

I'm trying to update every record where one field in a row is less than the other. The code gets each row i'm looking for and sets up the query right, I hope I combined the entire query into one string each query seperated by a ; so it's like
UPDATE `table` SET field2= '1' WHERE field1= '1';UPDATE `table` SET field2= '1' WHERE field1= '2';UPDATE `table` SET field2= '1' WHERE field1= '3';UPDATE `table` SET field2= '1' WHERE field1= '4';UPDATE `table` SET field2= '1' WHERE field1= '5';
this executes properly if i run the query in phpMyAdmin, however when I run the query in PHP, it does nothing... Any advice?

I have a need to do a special sorting for a bunch of leads. The person who sees the leads (l.user) is looking at leads that are for a few different people (l.team_id). When I run my query in sqlyog, it gives me the results I am looking for, where the rank is used to sort. When I run my query through phpMyAdmin, php, or the MySQL command line, all of the ranks are NULL, so nothing gets sorted. All of these attempts are on the same database, on the same computer (Windows 7). Any ideas or help is appreciated.

SELECT 
  x.lead_id,
  x.rank,
  x.team_id,
  x.status 
FROM
  (SELECT 
    l.lead_id,
    l.team_id,
    l.status,
    CASE
      WHEN @ps != l.team_id 
      THEN @rownum := 0 
      WHEN @ps = l.team_id 
      THEN @rownum := @rownum + 1 
      ELSE @rownum 
    END AS rank,
    @ps := l.team_id 
  FROM
    `system-leads` l 
  WHERE (l.user = 189905706)  
    AND l.status != "closed" 
  LIMIT 100000000 OFFSET 0) `x`
ORDER BY x.status ASC,
  x.rank ASC,
  x.lead_id ASC 

I wonder why it works in sqlyog and not the others, but I need it to work regardless of what client I am using.

I don't understand why "if(isSet($_GET['sid'])) " works before it is declared in the variable name(" $name = $_GET['sid'];"). 1. How does php store the date in this get statement? 2. Is GET an array?

Code: [Select]
if(isSet($_GET['sid']))
{
     echo "<h2>Exercise</h2>";
 
      $name = $_GET['sid'];
      $timein = time();
      $quest=1;
      $nextquest=2;

} else {
    echo "<h2>Enter Student Number:</h2>";
    $quest=0;
    $nextquest=0;
}

I'm having trouble with a simple SELECT query. I just cannot figure out what the problem is...
<?php
//Include database connection details
include 'login/config.php';

//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
die("Unable to select database");
}

$qry="SELECT * FROM members";
$result = mysqli_query($link, $qry);

                                echo "<table>";

while($row = mysqli_fetch_array($result, MYSQL_ASSOC))
{
$getid = ($row['member_ID']);
$firstname = ($row['firstname']);
$lastname = ($row['lastname']);
$email = ($row['email']);

echo "<tr><td>$firstname</td><td>$email</td></tr>"; 
}

echo "</table>";
?>

I know I have a connection to the DB, and I know that the query will return values as I have tested in in phpmyadmin.

Can anyone see anything obvious I am missing?

Thanks

I have a really weird problem.
I'm trying to run a mysql query that works fine in phpmyadmin but in php script is giving me an error.
The query is:

Code: [Select]
(SELECT DISTINCT art.`TEMPLATE`,gal.`ARTICLE_ID`,art.`TITLE`,art.`DESCRIPTION`,MATCH(art.`TITLE`,art.`DESCRIPTION`,gal.`CONTENT`) AGAINST ('WORD*' IN BOOLEAN MODE) AS score
FROM articles art,galeries gal
WHERE gal.`ARTICLE_ID`=art.`ARTICLE_ID` AND MATCH(art.`TITLE`,art.`DESCRIPTION`,gal.`CONTENT`)
AGAINST ('WORD* ' IN BOOLEAN MODE))
UNION
(SELECT DISTINCT `TEMPLATE`,`ARTICLE_ID`,`TITLE`,`DESCRIPTION`,MATCH(`TITLE`,`DESCRIPTION`,`CONTENT`)
AGAINST ('WORD* ' IN BOOLEAN MODE) AS score
FROM articles
WHERE (MATCH(`TITLE`,`DESCRIPTION`,`CONTENT`) AGAINST ('WORD* ' IN BOOLEAN MODE)))
ORDER BY score DESC LIMIT 0,30
Snipset from php script code:


function search($start_row,$ammount,$search_key,$pages){
        $start_row = intval($start_row) * $ammount;

        $return_val = "";
        $symbols = array('/','\\','\'','"',',','.','<','>','?',';',':','[',']','{','}','|','=','+','-','_',')','(','*','&','^','%','$','#','@','!','~','`'

);//this will remove punctuation
        $pattern = "#[^(\w|&#945;|&#946;|&#947;|&#948;|&#949;|&#950;|&#951;|&#952;|&#953;|&#954;|&#955;|&#956;|&#957;|&#958;|&#959;|&#960;|&#961;|&#963;|&#964;|&#965;|&#966;|&#967;|&#968;|&#969;|&#913;|&#914;|&#915;|&#916;|&#917;|&#918;|&#919;|&#920;|&#921;|&#922;|&#923;|&#924;|&#925;|&#926;|&#927;|&#928;|&#929;|&#931;|&#932;|&#933;|&#934;|&#935;|&#936;|&#937;|&#962;|&#940;|&#941;|&#972;|&#943;|&#973;|&#974;|&#942;|&#970;|&#971;|&#912;|&#944;|&#902;|&#904;|&#908;|&#906;|&#910;|&#911;|&#905;|&#938;|&#939;|\d|\'|\"|\.|\!|\?|;|,|\\|\/|\-|:|\&|@)]+#";

        $search_key = greek_text::to_upper($search_key);
        $wc = strip_tags($search_key);
        $wc = preg_replace($pattern, " ", $wc);

        for ($i = 0; $i < sizeof($symbols); $i++) {

                $wc = str_replace($symbols[$i],' ',$wc);
        }

        $wc = str_replace("&#900;", " ", $wc);
        $wc = str_replace(chr(162), " ", $wc);

        if( !$keep_numbers ) {
            $wc = preg_replace('#(^|\s+)[\d\s]+(\s+|$)#',' ',$wc);
            $pattern = '#(^|\s+)([0-9]+[a-zA-Z&#945;&#946;&#947;&#948;&#949;&#950;&#951;&#952;&#953;&#954;&#955;&#956;&#957;&#958;&#959;&#960;&#961;&#963;&#964;&#965;&#966;&#967;&#968;&#969;&#913;&#914;&#915;&#916;&#917;&#918;&#919;&#920;&#921;&#922;&#923;&#924;&#925;&#926;&#927;&#928;&#929;&#931;&#932;&#933;&#934;&#935;&#936;&#937;&#962;&#940;&#941;&#972;&#943;&#973;&#974;&#942;&#970;&#971;&#912;&#944;&#902;&#904;&#908;&#906;&#910;&#911;&#905;&#938;&#939;]+\s*)+(\s+|$)#';
            preg_match($pattern,$wc,$aa);
            $wc = preg_replace($pattern, " ", $wc);
        }
        $wc = trim(preg_replace("/\s\s+/", " ", $wc));
        $wc = explode(" ", $wc);
        $cleaned_keyword = array_filter($wc);

        $cleaned_keyword = greek_text::removeStopWordsFromArray($cleaned_keyword);
        $stemmed_keywords = greek_text::stemWordsArray($cleaned_keyword);

        $query = "(SELECT DISTINCT art.`TEMPLATE`,gal.`ARTICLE_ID`,art.`TITLE`,art.`DESCRIPTION`,MATCH(art.`TITLE`,art.`DESCRIPTION`,gal.`CONTENT`) AGAINST ('";

        while(list($key,$val)=each($stemmed_keywords)){
                if($val<>" " and strlen($val) > 1){
                        $query .= $val."*";
                        $search_keys .= $val."* ";

                }
        }

        $query .= "' IN BOOLEAN MODE) AS score FROM articles art,galeries gal WHERE gal.`ARTICLE_ID`=art.`ARTICLE_ID` AND MATCH(art.`TITLE`,art.`DESCRIPTION`,gal.`CONTENT`) AGAINST ('".$search_keys."' IN BOOLEAN MODE))";
        $query .= " UNION (SELECT DISTINCT `TEMPLATE`,`ARTICLE_ID`,`TITLE`,`DESCRIPTION`,MATCH(`TITLE`,`DESCRIPTION`,`CONTENT`) AGAINST ('".$search_keys."' IN BOOLEAN MODE) AS score FROM articles WHERE (MATCH(`TITLE`,`DESCRIPTION`,`CONTENT`) AGAINST ('".$search_keys."' IN BOOLEAN MODE))) ORDER BY score DESC LIMIT ".intval($start_row).",".$ammount;
                
        $rs = $this->dbActions->execQuery($query);
        $this->dbActions->execQuery("INSERT INTO searches (`KEY`,`DATE`,`RESULTS`) VALUES ('".$search_key."',NOW(),".$pages.")");
        $search_results = "<div id='results'>";
        while($row = mysql_fetch_array($rs)){           
           $search_results.= "<div id='result'>";
           $search_results.= "<div class='result_title'><h4><a href='article.php?articleId=".$row["ARTICLE_ID"]."'>".$row['TITLE']."</a></h4></div>";
           $search_results.= "<div class='result_description'>".$row['DESCRIPTION']."</div>";
           $search_results.= "</div>";
           $search_results.= "<div class='result_seperator'></div>";
        }
        $search_results .= "</div>";
        $return_val = $search_results;

        return $return_val;
    }


dbactions class:


require 'includes/errors.php';
error_reporting(0);

class DBActions{

var $dbCon;

var $errorHandler;

function DBActions(){

$this->dbCon = $this->dbCon();

$errorHandler = new errors(1);

}

private function dbCon(){

require 'conf/configuration.php';

$dbcon = mysql_connect($dbUrl,$dbUser,$dbPass);

if(!$dbcon)trigger_error("Unable to connect to database $dbUrl for user $dbUser",E_USER_ERROR);

mysql_select_db($dbName);

mysql_query("SET NAMES 'UTF8'");

mysql_query('set character set utf8');

return $dbcon;

}

function dbClose(){

if($this->dbCon)

mysql_close($this->dbCon);

}

function execQuery($query){

              
                $result = mysql_query($query,$this->dbCon);
                                               

$msg = "Unable to execute query ".$query;
                if(mysql_num_rows($result) > 0)

return $result;

else if($result == false)

trigger_error($msg,E_USER_ERROR);

else

return $result;

}

function send_error_mail(){

$this->errorHandler->sendErrorEmail();

}
}


I've try everything but can't get this working..
Any healp whould be really appreciated.

Thanks in advance.

Good Afternoon Team,

Am sitting with something simple using the language below. If I copy the echo output of my query as included below it works perfectly in phpmyadmin but doesn't work on a website. Variables all seem to echo consistently/correctly and POST checks seem to verify this is working correctly as well. I worry the error comes with the syntax I used in combining the sql queries. That, or perhaps LAST_INSERT_ID does not work in the php script as well as it does in phpmyadmin. All help appreciated.

if(isset($_POST[`region_id`])) {
    $competition_id = htmlentities($_POST[`competition_id`],ENT_QUOTES,`UTF-8`);
    $division_name = htmlentities($_POST[`division_name`],ENT_QUOTES,`UTF-8`);
    $region_id = htmlentities($_POST[`region_id`],ENT_QUOTES,`UTF-8`);
    $division_edit_submit = "INSERT INTO division_table (competition_id,division_name) VALUES (`$competition_id`,`$division_name`);
    INSERT INTO region_assignment_table (division_id,region_id) VALUES ((LAST_INSERT_ID()),`1`)";    
    mysqli_query($connection,$division_edit_submit);
    echo $division_edit_submit;
    }

 

Hi, I'm new to PHP/MySQL and need some help getting my query to work for my selection list:

The selection list is built with:
<form action='processformmissing.php' method='POST'>
<fieldset>
<legend>Choose Department</legend>
<select name='depart'>
<option value=''></option>

<?php
while ($row = mysqli_fetch_array($result))
{
extract($row);
echo "<option value='$department'>$department</option>\n";
}
?>
</select>
<p><input type='submit' value='Select Department' /></p>
</fieldset>

</form>

The data is then sent to:

$depart = $_POST['depart'];
$deptlike = "%".$depart."%";

echo "<p>$depart</p>";
echo "<p>$deptlike</p>";

$query = "SELECT * FROM lifecerts INNER JOIN employees ON lifecerts.cid = employees.cid WHERE department LIKE '$deptlike' ORDER BY employees.name";



Hitting the submit button from my selection list form seems to be working fine because when I echo my data ($depart and $deptlike) it is giving me the correct value, but the query doesn't give me any results. However, if my post data comes from a text box instead of a selection list, my query works fine. Any thoughts on what I'm doing wrong???

Many thanks!

Hi, this query runs fine when I run it from PHPMyAdmin:
 

UPDATE `tran_term_taxonomy` SET `description` = (SELECT keyword from `good_keywords` ORDER BY RAND() LIMIT 1,1) WHERE `tran_term_taxonomy`.`taxonomy` = 'post_tag' AND `tran_term_taxonomy`.`description` = "" LIMIT 1

However, when I run the same query in a PHP file on my server, the page doesn't load at all. The message I get is: www.somesite.com is currently unable to handle this request. HTTP ERROR 500. This is my PHP code:

<?php 
include("/database/connection/path/db_connect.php"); 

$result4 = mysqli_query($GLOBALS["___mysqli_ston"], "UPDATE `tran_term_taxonomy` SET `description` = (SELECT keyword from `good_keywords` ORDER BY RAND() LIMIT 1,1) WHERE `tran_term_taxonomy`.`taxonomy` = 'post_tag' AND `tran_term_taxonomy`.`description` = "" LIMIT 1");
echo $result4;

?>

So how do I make this query work please? Thanks for your guidance.

I have a script that adds points together based upon the placing. This is the actual script:

Code: [Select]
<? $points = 0;

if($place === '1st') {$points = $points + 50;}
elseif($place === '2nd') {$points = $points + 45;}
elseif($place === '3rd') {$points = $points + 40;}
elseif($place === '4th') {$points = $points + 35;}
elseif($place === '5th') {$points = $points + 30;}
elseif($place === '6th') {$points = $points + 25;}
elseif($place === '7th') {$points = $points + 20;}
elseif($place === '8th') {$points = $points + 10;}
elseif($place === '9th') {$points = $points + 10;}
elseif($place === '10th') {$points = $points + 10;}
elseif($place === 'CH') {$points = $points + 50;}
elseif($place === 'RCH') {$points = $points + 40;}
elseif($place === 'TT') {$points = $points + 30;}
elseif($place === 'T5') {$points = $points + 30;}
elseif($place === 'Champion') {$points = $points + 50;}
elseif($place === 'Reserve Champion') {$points = $points + 40;}

echo "Total HF Points: $points";
?>What it *should* do (my friend's script works the same way and it works) it starts at points = 0, than if there is a first place, it adds 50, and so forth until it reaches the end.

It is included into a file, in this area:

Code: [Select]
<div class="tabbertab">
<h2>Records</h2>
<? $query92 = "SELECT * FROM THISTABLE WHERE VARIABLE='$id' OR VARIABLE = '$name' ORDER BY ABS(VARIABLE), VARIABLE";
$result92 = mysql_query($query92) or die (mysql_error());

echo "<table class='record'>
<tr><th>Show</th> <th>Class</th> <th>Place</th></tr>
";

while($row92 = mysql_fetch_array($result92)) {
$class = $row92['class'];
$place = $row92['place'];
$entries = $row92['entries'];
$race = $row92['show'];
$purse = number_format($row92['purse'],2);

echo "<tr><td>$race</td> <td>$class</td> <td>$place</td></tr>";
}
?>
<tr><td colspan='3'><div align='right'><? include('includes/points.php'); ?></div></td></tr>
</table>
</div>

This is the code that is relevant. When ended here, it echoes the last place that appears in the results (such as a 5th place echoing 30 points). When I move it to be included in the while loop, it shows Total Points: 50 Total Points: 25 Total Points: 10 (depending on the results displayed on that page). What am I doing wrong?

Hello everyone,

I can get Test 2 to successfully operate the if statement using a variable variable.

But when I try the same method using a session variable (Test 1) the if statement is not executed. Please could you tell me why the if statement in Test 1 is not being executed?

Code: [Select]

<?php
# TEST 1
$_SESSION[test_variable] = "abcd";
$session_variable_name = "_SESSION[test_variable]";
if ($$session_variable_name == "abcd")
{
echo "<br>line 373, abcd<br>";
}

# TEST 2
$test_variable = "efgh";
$test_variable_name = "test_variable";
if ($$test_variable_name == "efgh")
{
echo "<br>line 379, efgh<br>";
}

?>
Many thanks,

Stu

hi i have the script below which copies data from one table to another but will only insert new data update current data or delete old data from tempproducts to products then it will delete the tempproducts from the db however i keep getting this error:

Warning: mssql_query() [function.mssql-query]: Query failed in E:\UpdateProducts.php on line 33

updateproducts.php
Code: [Select]
<?php
include('../../otherscripts/functions.php');
$log = new Logging(); 

// create DB connection
 $host = "localhost";
 $user = "user";
 $pass = "pass";
 $mydb = "db";

 $db = mssql_connect($host,$user,$pass);
 
//Select Database
 mssql_select_db($mydb);
 

 // delete all old data
    $sql0 = "SELECT * FROM tempproduct";
    $sql1 = "INSERT INTO products SELECT * FROM tempproduct WHERE manf_part_no NOT IN (SELECT manf_part_no FROM products) AND supp_id NOT IN (SELECT supp_id FROM products)";
    $sql2 = "DELETE FROM products WHERE manf_part_no NOT IN (SELECT manf_part_no FROM tempproduct) AND supp_id NOT IN (SELECT supp_id FROM tempproduct)";
    $sql3 = "UPDATE p1 SET p1.avail_qty = t1.avail_qty, p1.cost_price = t1.cost_price, p1.rrp = t1.rrp, p1.date_added = t1.date_added, p1.description = t1.description FROM Products p1 INNER JOIN tempproduct t1 ON (p1.manf_part_no = t1.manf_part_no AND p1.supp_id = t1.supp_id)";
    $sql4 = "TRUNCATE TABLE tempproduct";

//If tempproduct is empty done Execute Commands if it is full then execute commands

$query = mssql_query($sql0) or die($log->lwrite('Failed to select for count from db'));
$rowcount = mssql_num_rows($query);

if($rowcount == 0){
$log->lwrite('Teh tempproduct am emptyish');
}
else{
   mssql_query($sql1) or die($log->lwrite('Failed to insert to db'.$sql1));
   mssql_query($sql2) or die($log->lwrite('Failed to Delete from db'));
   mssql_query($sql3) or die($log->lwrite('Failed to Update db'));
   mssql_query($sql4) or die ($log->lwrite('Failed to TRUNCATE db'));
}
?>

if i run $sql1 command in the sql manager it runs fine and no errors occur?

For years I have used a simple captcha application displaying a simple combination of letters and numbers.   All has worked fine except that my hosting company upgraded some of their servers from PHP 5.2.17 to PHP 5.4.29.  The numbers now down't display and I can submit the form without filling any captcha into the text box.   On the otherhand, I have a couple of sites on different servers, (same hosting company) using PHP 5.2.17 and the captcha application works perfectly.   The code to make the captcha works uses $HTTP_SESSION_VARS and I understand it is deptrecated with newer versions of PHP so I changed to $_SESSION.   If I fill out the form and leave the captcha blank it will default to the error message and require a return to the form page to fill in the captcha.  Once filled in and the form submitted, it goes to the default message.   It appears that the session variable is not passing to the page and recognized.

Hi all,    I'v table called vehicles with
id (int auto_increment) and
plate_number (varchar 150).   the plate_number have records like (a a a 1 1 1 1) (b b b 2 2 2 2), three chars and four numbers spliced by spaces.   I'v php search page with url like this:

http://localhost/vehicles/show.php?plate_number=f%20f%20f%205%205%205%205

search about plate_numbet = f f f 5 5 5 5

my php code:

// pdo connection.

// first sql test 
$sql = "SELECT * FROM vehicles WHERE plate_number LIKE '%".$_GET['plate_number']."%'"; 

// second sql test
// $sql = "SELECT * FROM vehicles WHERE plate_number = '".$_GET['plate_number']."'";

$db->query($sql); 
if($db->rowcount() > 0){ 
// print all results... 
}else{
echo "There are no results.";
}

The query result is: There are no results..   But, when I copy the sql statements into phpmyadmin it is works fine. (there is a result). like this:

SELECT * FROM vehicles WHERE plate_number LIKE '%f f f 5 5 5 5%';

OR 

SELECT * FROM vehicles WHERE plate_number = 'f f f 5 5 5 5';

Also i used string functions (htmlspecialchars, rawurldecode, ... ), still not work.   any suggestion to solve this issue?   Thanks to all  

 

$id = '9';

$MyQuery = "SELECT * FROM bookings WHERE id = '$id'";
$retrieve = mysql_query($MyQuery) or die(mysql_error());
if(mysql_num_rows($retrieve) != 0):
$row = mysql_fetch_assoc($retrieve);
else:
echo 'No Information';
endif;

echo 'Full Name: ' . ($row['fullname']) . '<br><br>';

The above code is working for me however when I change it to what I do...

$id = ($row['id']);

It tells me I have an undefined row variable... What will fix this? Thanks in advance...

I have this variable that I need to get into my database and I just can't think through it. Here is the code.


$sql = "INSERT INTO names (id, name, color, uploaddate) VALUE (NULL,'$master[2]['dbid']','$color','$time')";


I know I need to escape those quotes around dbid somehow, but I can't seam to get it figured out.  If I have to I will set it = to a different variable, but I don't want to do it that way if I don't have to