PHP - Nightmare With Cookies.

OK, I have been having issues with this query for some time now, I (finaly) have the query working absoloutly fine when run directly in the database, however, when I try and run it through a PHP page I just get a completly empty result set back.  I have done a print_r($row) and there is nothing, absoloutly nothing.  I have ran the SQL that comes from  print_r($sql) in the database and it's completly fine as well.  I was getting an error previously because I had missed the "IS" out before NOT NULL for the PadPrefix, so it is parsing the SQL to some level (I now have no errors showing either). 

I am wondering if there is something I am missing that is needed for when the SQL is creating cached tables and/or using a counter?

Here's the code, any and all suggestions welcome, Cheers
<?php
@SESSION_START();
require_once 'connect.php';
$bp = $_SESSION['bp'];
if ($_SESSION['id'] < 99){
$tbl_top = '<table><tr><th>SheetID</th></tr>';
$WHERE = " = '$bp'";
}
else{
$tbl_top = '<table><tr><th>SheetID</th><th>Prefix</th></tr>';
$WHERE = "IS NOT NULL";
}
$sql = "DECLARE @badSheets TABLE (ID int, batchMax int) ".
"DECLARE @list TABLE (maxsheet int, lastsheet int) ".
"DECLARE @sheet int ".
"DECLARE @batch int ".       
"DECLARE @endBatch int ".
"declare @batchIndex int ".
"INSERT INTO @list (maxsheet, lastsheet) ". 
"SELECT sheetList.maxsheet, padlist.lastSheet ".
" FROM( ".
" SELECT sheet.padID, MAX(sheet.SheetID) as maxsheet FROM jim.dbo.sheet as sheet ". 
" INNER JOIN jim.dbo.files as files on sheet.sheetID = files.sheetid ".
" where sheet.sheetid > 100000 ".
" group by sheet.padID) ".
"AS sheetList ".
"INNER JOIN( ".
 "SELECT pads.padID, pads.padID+(count(pads.padID)-1) as lastSheet ".
 "From jim.dbo.sheet as pads ".
 "Group By pads.PadID) ". 
"AS padList ".
"ON (sheetList.padID = padList.padID) ".
"WHERE maxsheet != lastSheet ".
"DECLARE bad_batch CURSOR FOR ".
"SELECT DISTINCT maxsheet FROM @list ORDER BY MaxSheet ".
"OPEN bad_batch ".
"FETCH NEXT FROM bad_batch ".
"INTO @batchIndex ".
"WHILE @@FETCH_STATUS = 0 ".
 "BEGIN ".
  "SELECT @batch = lastSheet FROM @List where maxsheet= @batchIndex ".
  "SELECT @sheet = maxSheet FROM @List where maxsheet= @batchIndex ".
  "WHILE (@sheet <= @batch) ".
    "BEGIN ".
    "INSERT INTO @badsheets(ID, batchMax) VALUES (@sheet, @batch) ".
    "SET @sheet = (@sheet + 1) ".
    "END ".
  "Fetch Next FROM bad_batch INTO @batchIndex ".
  "END ".
"close bad_batch ".
"deallocate bad_batch ".
"SELECT sheetID, padprefix ". 
"FROM JIM.dbo.sheet AS sheet LEFT OUTER JOIN jim.dbo.pad AS pads ".
   "ON sheet.padID = pads.padID ".
   "WHERE ( ".
"(padprefix $WHERE) ".
"AND (sheet.sheetID > 100000) ".
"AND (sheet.SheetID NOT IN (SELECT SheetID FROM jim.dbo.files)) ". 
"AND (sheet.sheetID NOT IN (SELECT ID FROM @badSheets)) ".
")";
$result = sqlsrv_query($sqlConnect, $sql) or die("error running : $sql <br><br>".print_r( sqlsrv_errors(), true));
echo "<table border=\"1\">";
echo $tbl_top;
WHILE ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)){
  if ($_SESSION['id'] < 99){
  $tbl_content = "<tr><td>{$row['sheetID']}</td></tr>";
  echo $tbl_content;
  }
  else{
   $tbl_content = "<tr><td>{$row['sheetID']}</td><td>{$row['padPrefix']}</td></tr>";
   echo $tbl_content;
  }
  
  echo $tbl_content;
  }
echo "</table>";
?>

I have the " or the ' all wrong.  Can someone tell me how to do the quoation marks correctly so I dont get a syntax error:

as can be seen, the date 10/5/14 is not a variable but I want to convert it to a format that can go into a DATE field.

Code: [Select]
$query = "update table set expir_date = date("Y-m-d", 10/5/14) where id = '$id' ";

Hey guys,

Been developing a bespoke "helpdesk" system for work and, while it works well on the whole, I am having major problems with base64 encoded email bodies.

Admittedly, this might be due to my misunderstanding of imap body parts. It seems in my current setup, the system thinks that all mails are either "type" 0 or 4. As a result, base64 emails don't get decoded and display as an unreadable long string.

Here is what my code for the body decoding looks like just now - can provide more on request.

$from=$overview[0]->from; 
    $subject=$overview[0]->subject; 
    $subdb=mysql_real_escape_string($subject); 

    $lookingfor=explode("~#",$body); 

    $result=$from; 

    $find=strrpos($ir, $lookingfor[1]); 

    $findreplystream=mysql_query("SELECT * FROM tickets WHERE ticket_md5='$lookingfor[1]'") or die(''.mysql_error().''); 

    $stream=mysql_fetch_array($findreplystream); 

    $now=time(); 

    if($structure->encoding == 0){ 
     
        $arr1=array("=A3", "=80"); 
        $arr2=array("&pound;", "&euro;"); 
        $newcontent=$explodeunder[0]; 
        define("CHARSET", "ISO-8859-1"); 

        $dbcontenta=str_replace($arr1, $arr2, $newcontent); 
        $r=mb_detect_encoding($dbcontenta); 

        if($r=="UTF-8"){ 

            $dbcontents=mb_convert_encoding($dbcontenta, "ISO-8859-1", "UTF-8"); 
            $dbcontent1=addslashes($dbcontents); 
            $dbcontent2=strip_tags($dbcontent1); 

            } 

        elseif($r=="ASCII"){ 

            $dbcontentb=mb_convert_encoding($dbcontenta, "UTF-8", "ASCII"); 
            $dbcontents=mb_convert_encoding($dbcontentb, "ISO-8859-1", "UTF-8"); 
            $dbcontent1=addslashes($dbcontents); 
            $dbcontentf=strip_tags($dbcontent1); 
            $dbcontent2=quoted_printable_decode($dbcontentf); 
             }  

    } elseif($structure->encoding  == 4) { 

    $dbcontent=$explodeunder[0]; 

    $dbcontentf=quoted_printable_decode($dbcontent); 
    $dbcontent2=mb_convert_encoding($dbcontentf, "ISO-8859-1", "UTF-8"); 
    } 

    elseif($structure->encoding == 3) { 

    $dbcontent2=imap_base64($explodeunder[0]); 

    } elseif($structure->encoding == 1){ 

        $dbcontent3=imap_8bit($explodeunder[0]); 
        $dbcontent2=quoted_printable_decode($dbcontent3); 
    } 


Can anyone advise me with this?

I'd be greatful for any assistance at all, as it's causing me nightmares!

All the best

Hi all,

Experimenting with this instant search buzz only I cant seem to replicate the function!
I think my PHP may be cocking up but Ive been staring for too long to see anything.

Could anybody take a quick glance and see if they can see anything?

Code: [Select]
<?php
if(!empty($_GET['q'])) {
    search();
}

function search() {
    $con = mysql_connect('localhost','login', 'pass');
    mysql_select_db('db', $con);

    $q = htmlspecialchars($_GET['q'],ENT_QUOTES);

    $sql = mysql_query("
        SELECT
            post_title as post
        FROM wp_posts
        WHERE post_title LIKE '%{$q}%' OR post_title LIKE '%{$q}%'
        ");

    
    $results=array();
    while($v = mysql_fetch_object($sql)){
        $results[] = array(
          'title'=>$v->title,
          'post'=>$v->post
        );
    }

  
    echo json_encode($results);
}
?>

Hi, I am currently trying to build an Artist's website, the artist wanted a CMS that was completely customized to the site (so no Wordpress, Joomla, Drupel, etc) - because of this I am having to create a CMS completely from scratch.   The problem I am having is with the database connection (hence the topic title), other sites that I have built with this same code work fine - however this particular site does not seem to want to play ball. It keeps giving me this error:  

SQLSTATE[HY000] [1045] Access denied for user 'web113-janesart'@'10.0.44.113' (using password: YES)

  I have tried obvious things such as spelling mistakes, wrong password/username/db name, nothing seems to get rid of this error.   Any help on what else this could be would be appreciated.

Hi all, im trying to shorten this string which cnotains about 1000 characters, to say 250
Code: [Select]
<?php echo $row_Best_Sellers['experience_name']; ?>
Ive tried using the below to no avail, can anybody give me some advice?

Code: [Select]
<?PHP
$small = some_function($row_Best_Sellers['experience_description']);
echo $small;

function some_function($string){
     $string = substr($string,0,100);
     $string = substr($string,0,strrpos($string," "));
     return $string;
}
?>

This has been driving me crazy for hours!
I am trying to set a cookie:  setcookie("username", $_POST['user']); 
And for a while it wasn't working, then it started randomly working. Now, when I try to use  if(isset($_COOKIE['username']))
PHP is saying the cookie does not exist. PLEASE help! Thanks.

i'm trying to set a cookie value to a result from a query, but its not working. all of the other cookies are being set, except for one. any ideas why?

<?php 

//Checks if there is a login cookie 
if(isset($_COOKIE['ID_forum'])) 

//if there is, it logs you in and directs you to the members page 
{ 
$username = $_COOKIE['ID_forum']; 
$pass = $_COOKIE['Key_forum']; 
$user_level = $_COOKIE['Forum_level'];
$check = mysql_query("SELECT * FROM users WHERE username = '$username'")or die(mysql_error()); 
while($info = mysql_fetch_array( $check )) 
{ 
if ($pass != $info['password']) 
{ 
} 
else 
{ 
header("Location: index.php"); 
} 
} 
} 
 if (isset($_POST['submit'])) { // if form has been submitted 
// makes sure they filled it in 
if(!$_POST['username'] | !$_POST['pass']) { 
die('
<h2> You did not fill in all of the fields</h2>
<p<a href="login.php">Return to login page</a>
'); 
} 
// checks it against the database 
$check = mysql_query("SELECT * FROM users WHERE username = '".$_POST['username']."'")or die(mysql_error()); 
//Gives error if user dosen't exist 
$check2 = mysql_num_rows($check); 
if ($check2 == 0) { 
die('
<h2> That user does not exist in our database.<br/> </h2>
<p<a href="login.php">Return to login page</a>
'); 
} 
while($info = mysql_fetch_array( $check )) 
{ 
$_POST['pass'] = mysql_real_escape_string($_POST['pass']); 
$info['password'] = mysql_real_escape_string($info['password']); 
$_POST['pass'] = md5($_POST['pass']); 
//gives error if the password is wrong 
if ($_POST['pass'] != $info['password']) { 
die('
<h2> Incorrect password, please try again</h2>
<p<a href="login.php">Return to login page</a>
'); 
} 
else 
{ 
$_POST['username'] = mysql_real_escape_string($_POST['username']);
$_POST['user_level'] = mysql_real_escape_string($_POST['user_level']); 
$hour = time() + 3600; 

setcookie(ID_forum, $_POST['username'], $hour); 
setcookie(Key_forum, $_POST['pass'], $hour);
setcookie(Forum_level, $_POST['user_level'], $hour);  //this cookie is not being set
setcookie(test, 'test cookie', $hour);  // testing that cookie is being set - this works

header("Location: index.php"); 
$query2 = mysql_query("SELECT * FROM users WHERE username = ".$_POST['username'])or die(mysql_error());   
setcookie(Level_forum, $query2['user_level'], $hour);
} 
} 
} 
else 
{     
// if they are not logged in 
?> 

//form code is here. i have not included it to save space
<?php 
} 

?> 

Thanks

Okay im having a problem with cookies so if anyone can help i would be grateful.

When you login you can choose how long to stay in for. For testing purposes the choices a

Forever 1 Hour 1 Day Never
Based on your choice i am setting the cookie expiration as follows:

if ($_POST['remember_me'] == '1')
{
setcookie('remember', time() + 99999999999999);
}
elseif ($_POST['remember_me'] == '3600')
{
setcookie('remember', time() + 3600);
}
elseif ($_POST['remember_me'] == '84600')
{
setcookie('remember', time() + 84600);
}
elseif ($_POST['remember_me'] == '0')
{
setcookie('remember');
}
echo $_COOKIE['remember']; 
}

Then for testing I am echoing the cookie at the head of the document:

echo "Cookie: " . @$_COOKIE['remember'];

The problem is that when the browser is closed the cookie is gone. Only the last option "never" is set as a session cookie which means the others
should stay active even when the browser is closed shouldnt they?

Anything i have missed here?

The code below is the only part of my script failing and I have no clue why. I even tried setting the TestCookie for 352 days. What boggles my mind is that this code used to work and is now failing. Has something changed?

$value = "wtf";
setcookie("TestCookie",$value, time()+3600*24);

setcookie("user", $name1, time()+14400);
setcookie("userid", $uid1, time()+14400);
setcookie("coid", $coid1, time()+14400);
setcookie("login", "yes", time()+14400);
setcookie("status", $status1, time()+14400);

Hi guys,

I am having a sticky problem with Cookies.
Basically, I've had to change the settings of my CMS which has resulted in me now having the same cookie names for the cookie domains .domain.com and www.domain.com.

I know I can just clear my cookies and the problem will be sorted, but it's not feasible for me to expect users of my site to clear their cookies.

So my question is this.
How can I delete the cookies created using www.domain.com with PHP?
Everytime I set the expiry date of the cookies, it only applies it to those on .domain.com.

Any help would be gratefully appreciated!!

Hey all,

http://www.adamrowden.co.uk/photo-searchr.asp


If you visit this link, you'll see on the left side you have a few photos. If you click a photo from that page and then go back to the link i've provided you'll see that it shows you your 'recently viewed photos'. I'm wanting to do exactly that and need some pointers on how i would!?

I'd be very grateful for any help

Thanks, Jimmy m

I have this page where I  create two cookies with the username and passwords of the users for the website.

Code: [Select]
$equipa = $_POST['equipa'] ;
$pass = $_POST['codigo'] ;

setcookie("equipa", "$equipa", time() + 3600) ;
setcookie("codigo", "$pass", time() + 3600) ;
In the next page, I can have access to the cookie, with this script :
Code: [Select]
<?php

$equipa = $_COOKIE['equipa'] ;
echo $equipa ;
$pass = $_COOKIE['codigo'] ;
echo $pass ;

?>
But in this page you have to fill a form and send it, going to a new page. In this new one, with the exact same code, I can't access the cookie.

If anyone could please help me and tell me why.....
Thanks for the help

hello;

it seems strange that php can set cookies, since php is on the serer-side, but the cookies are on the client-side ... is there something that I am missing?

Hello all,

I hope someone can shed some light/point me in the right direction.

I have a site that allows you to search for a customer then view and change their detail.

page 1 has a search box for name entry.
page 2 displays all the matches retrieved from a db table that match. The user selects which customer is the correct 1 and sets a cookie containing the selected customers unique id.
page 3 allows changing of the customers details.

now the problem I have:
If a user navigates to page 3 and has a customers details on page for viewing all is well.
If they open a new tab (leaving page 3 open on first tab) and go to page 1, search for another customer, page 2 select another customer (which overwrites cookie) then to page 3. They now have two tabs open on page 3 both displaying different customer details.
If they return to the first tab and change some detail, when they save it actually updates the users details that corrispond to the second tab. I know this is because the cookie has been changed that holds the unique id that is required for the update query.

How can I prevent this?
I've looked at sessions but it would seem the same issue would excist. Am I wrong?

Many Thanks

I hope I made sense.