benanamen

Most likely {$row['id']}
 
Whatever your ID column is named.
echo "<tr><td><a href=\"kf_orders_entered_detail.php?id={$row['id']}\">{$row['ompCreatedBy']}</td>";

echo "<td width=\"100\"><div align=\"center\"><img src=\"http://www.brickbybricks.ca/php/images/{$row['Color_Name']}/{$row['PartID']}.gif\"></td>";  The only thing about that is you have no choice but to escape and concatenate the variables instead of doing {$row['Color_Name']} (Curly Syntax, my preference). 

Ok, we are getting somewhere.
 
Now, just use this code alone while you get things going. The difference is I have now added what is called a "Positional Placeholder" for username which is the question mark. There is another way to do it called "Named Parameters" but we can get into that another time. The code will now give you the individual column data.
 
This is complete standalone with the connection code. Just practice with this. you can integrate it later. Set the connection parameters to your DB.
 
 
<?php
error_reporting(-1);
ini_set('display_errors', '1');

$hostdb   = 'localhost';
$dbname   = 'phphelp_joe';
$username = 'root';
$password = '';

if (!empty($_GET['username']))
    {  
    $pdo = new PDO("mysql:host=localhost;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    $sql  = "SELECT username, firstname, lastname, email FROM users WHERE username=?";
    $stmt = $pdo->prepare($sql);
    $stmt->execute(array(
        $_GET['username']
    ));
    $row = $stmt->fetch();
    echo "{$row['username']} {$row['lastname']} {$row['email']}";
    }
else
    {
    echo 'No username in URL';
    }
?>

Add this to your query
AND t1.`data_prevista` <> '0000-00-00' SELECT t1.`id_plano`,         t1.`atividade`,         t1.`data_prevista`  FROM   `new_pae` AS t1  WHERE  t1.`id_user` = '$idUser'         AND t1.`data_prevista` <= Curdate()         AND t1.`data_prevista` <> '0000-00-00'         AND ( t1.`realizado` IS NULL                OR Length(t1.`realizado`) = 0 )

You might want to just use a date-picker that will put the date format you want into a read only field. Dont allow the user to enter it wrong in the first place.

You can have millions of records in a table. You should first learn Database Normalization and you will have a better idea how to do your tables. The amount of records you have wont even tickle a database.

Ok, looka here young man, see what you did?
 
$row2 = mysql_fetch_array($r2, MYSQLI_ASSOC);    
 
You do remember you are using Mysqli right?
 
 
I think we should get you on PDO, it's just better. Not an opinion, it just is.

OP, so your not confused,
 
 
$checkbox1 = isset($_POST['checkbox1']) ? 1 : 0;
 
does the same exact thing as
 
 
 
What I showed you is a Ternary Operator. It would behoove you to know how to use it. There is no need to have a value for the form check box.
 
$checkbox1 = isset($_POST['checkbox1']) ? 'this_is_my_check_box_insert_value_not_a_number' : 0;
 
A string will require to be quoted, a number no quotes.

You dont use var_dump as part of your code. That is for debugging.
 
 
 
Per the manual:
var_dump — Dumps information about a variable
 
 
 
  $email = 'email@email.com';   echo $key = sha1($email.'my_super_duper_secret_sauce_here'.microtime());    // YOU HAVE TO DO THIS IN THE BROWSER. You also need to save the key to a DB. The key constantly changes so you cant compare what is generated directly. It will NEVER match. //https://www.mysite.com?k=0281cdeb4fa63c4ca087e8052b0c1685fc0a51e6   if ($key_from_db==$_GET['k']){ echo 'Match'; } else { echo 'No Match'; }

Try this:
if($adminString == "False"){ die(header("Location: /path_to_file/error.php")); } Another thing you could do is just redirect them back to your main page and not even show an error to the user.

I will leave it up to you to handle the dates
 
 
<?php $url  = "http://ichart.finance.yahoo.com/table.csv?s=f"; $file = file($url); foreach ($file as $value)     {     if (stristr($value, '2015-09-10'))         {         echo $value;         }     } ?>

$cars = array ( array("Volvo",22,18), array("BMW",15,13), array("Saab",5,2), array("Land Rover",17,15) ); function r_implode( $glue, $pieces ) { foreach( $pieces as $r_pieces ) { if( is_array( $r_pieces ) ) { $retVal[] = r_implode( $glue, $r_pieces ); } else { $retVal[] = $r_pieces; } } return implode( $glue, $retVal ); } echo r_implode( '||', $cars ) Result: Volvo||22||18||BMW||15||13||Saab||5||2||Land Rover||17||15
 
Source:http://www.craiglotter.co.za/2010/04/09/php-implode-a-multi-dimensional-array/