Random Problem with Variable

[LunarIsSexy]

So this is my code and for some reason nothing displays on the screen at all. It should echo $page or $latestpage and that should be a link it saved in the database but it didn't save anything to the database and it didn't echo anything.

 

Any clue?

<?php
include 'connect.php';
include 'main.php';
$id=$_SESSION['id'];
$page = "http://localhost/page1.php";
$sql="UPDATE math SET latestpage=$page where id='$id'";
mysql_query($sql);
$result3 = mysql_query("SELECT * FROM html where id='$id'");
while($row3 = mysql_fetch_array($result3))
{
$latestpage=$row3['latestpage'];
echo $latestpage;
?>

[DFulg]

Where is your debugging code?

[LunarIsSexy]

  On 9/21/2013 at 12:21 AM, DFulg said:

Where is your debugging code?

 

I'm not very great with PHP but this would be the correct function to call a debug on a variable right?

<?php
function debug_view ( $page ) {
    echo '<pre>';
    if ( is_array( $page ) )  {
        print_r ( $page );
    } else {
        var_dump ( $page );
    }
    echo '</pre>';
}
?>

At the moment I don't have any debug code.

[DFulg]

  On 9/21/2013 at 12:25 AM, LunarIsSexy said:

I'm not very great with PHP but this would be the correct function to call a debug on a variable right?

<?php
function debug_view ( $page ) {
    echo '<pre>';
    if ( is_array( $page ) )  {
        print_r ( $page );
    } else {
        var_dump ( $page );
    }
    echo '</pre>';
}
?>

At the moment I don't have any debug code.

No.

include 'connect.php';
include 'main.php';
$id = $_SESSION['id'];
$page = "http://localhost/page1.php";
$sql = "UPDATE math SET latestpage=$page WHERE id='$id'";
mysql_query($sql) or die("MYSQL Query Failed : " . mysql_error());
$result3 = mysql_query("SELECT * FROM html WHERE id='$id'") or die("MYSQL Query Failed : " . mysql_error());
while($row3 = mysql_fetch_array($result3))
{
$latestpage=$row3['latestpage'];
echo $latestpage;

Note: mysql is deprecated and will be removed in a future version of PHP. Use mysqli or PDO instead.

[LunarIsSexy]

  On 9/21/2013 at 12:31 AM, DFulg said:

No.

include 'connect.php';
include 'main.php';
$id = $_SESSION['id'];
$page = "http://localhost/page1.php";
$sql = "UPDATE math SET latestpage=$page WHERE id='$id'";
mysql_query($sql) or die("MYSQL Query Failed : " . mysql_error());
$result3 = mysql_query("SELECT * FROM html WHERE id='$id'") or die("MYSQL Query Failed : " . mysql_error());
while($row3 = mysql_fetch_array($result3))
{
$latestpage=$row3['latestpage'];
echo $latestpage;

Note: mysql is deprecated and will be removed in a future version of PHP. Use mysqli or PDO instead.

 

Thankyou for that!

 

It now debugs saying this.

 

MYSQL Query Failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '://localhost/page1.php WHERE id='8'' at line 1

 

I think this is due to the fact that there are no values or anything data saved under html, so it can't find anything with the ID 8.

 

Any idea what to do next? I guess instead of updating its going to have to just add a new one and if there is already something with that ID it will just update it. Any idea?

Edited September 21, 2013 by LunarIsSexy

[PaulRyan]

On the first query, you need to surround the $page variable with quotes.

[LunarIsSexy]

  On 9/21/2013 at 12:48 AM, PaulRyan said:

On the first query, you need to surround the $page variable with quotes.

 

That got rid of the error but this code still doesn't work. This is what I have 100% and nothing happens. Blank page and nothing shows up in database.

<?php
include 'connect.php';
include 'main.php';
$id = $_SESSION['id'];
$page = "http://localhost/page1.php";
$sql = "UPDATE html SET id='$id', lastpage='$page' WHERE id='$id'";
mysql_query($sql) or die("MYSQL Query Failed : " . mysql_error());
$result3 = mysql_query("SELECT * FROM html WHERE id='$id'") or die("MYSQL Query Failed : " . mysql_error());
while($row3 = mysql_fetch_array($result3))
{
$lastpage=$row3['lastpage'];
echo $lastpage;
}
?>

Edited September 21, 2013 by LunarIsSexy

[PaulRyan]

Echo out both queries to make sure they contain exactly what you expect.

Then check the database for the id you are updating/selecting.

[LunarIsSexy]

I made it so when you register it will just set your ID inside the table and set the lastpage as page1.php.

 

This is a very weird way to do it but it works out!

Thanks for all your guys help!

[LunarIsSexy]

  On 9/21/2013 at 1:18 AM, PaulRyan said:

Echo out both queries to make sure they contain exactly what you expect.

Then check the database for the id you are updating/selecting.

The data wouldn't update in the database at all because there was no default data for that ID. When I updated it I was updating it based on whatever column had the ID field matching the session ID. Idk how else to do it so I just set a default by clicking insert in PHPMyAdmin. Any ideas?

[mac_gyver]

there's an INSERT ... ON DUPLICATE KEY UPDATE query that will do what you want - http://dev.mysql.com/doc/refman/5.6/en/insert-on-duplicate.html