PHP - Setting A Date Variable To Use In Mysql Query

I am trying to pass in a $string variable into my query like so but it is returning a warning:

Code: [Select]
$string = "clientName == '$input'";
$input = "Sam";

$table_id = 'booking';
$query ="SELECT *
FROM booking
WHERE. '$string' ";


$test = mysql_query($query);

echo $test;

Hi Members,   I am search for the reason for the problem why my mysql query cannot fetch data and store in file based on id in $variable form. For example, $sql="SELECT * FROM mytable WHERE mine_id='1234'"; works for me. But when i use $sql="SELECT * FROM mytable WHERE mine_id='$id'";, files are created as empty. I chanaged the quotes and could not store the data in file. So anyone please help me. For more clear, i attach the part of my code

for ($i=0;$i<=10;$i++)
    {

$id=$seqs[$i];
$dbo = new PDO($dbc, $user, $pass);
echo $sql = "SELECT * FROM mine_id WHERE locus_id='$id'";

$qry = $dbo->prepare($sql);
$qry->execute();
$data = fopen('file.csv', 'w');

   while ($row = $qry->fetch(PDO::FETCH_ASSOC))
              {
          fputcsv($data, $row);
             }
    }

Edited by phpnewbie007, 20 November 2014 - 02:17 AM.

I know the following simple demonstration fails and what to do to rectify it (though with a lot of additional code is necessary), but I don't know why this is the behaviour. It would be great if someone could explain to me why, and what the neatest way of fixing it would be.

Code: [Select]
+----------+--------------+------+-----+---------+
| Field    | Type         | Null | Key | Default |
+----------+--------------+------+-----+---------+
| Id       | int(11)      | NO   | PRI | NULL    |
| Name     | varchar(45)  | YES  |     | NULL    |     
| Number   | int(9)       | YES  |     | NULL    |         

Code: [Select]
$name = "Bradley Cooper";
$number = "";

$query = "INSERT INTO table (Id, Name, Number) VALUES (1, '$name', $number)";
mysql_query($query);

Because the $number variable is empty, this simple query fails. Logically, one would think that nothing or NULL gets inserted to that field since the MySQL structure rule states that default is NULL, and since nothing is fed to it in the query, I think that it would automatically be NULL since if the column is omitted, that is exactly the value that will be inserted.

Enclosing the variable with quotes is not preferable since this field accepts integers. Also, converting the variable to an integer by (int)$number results in a 0, which is not what I want either. Checking if the variable is empty of not, and if it is, assign $number = "''" so that the query would succeed by enclosing the empty string with single quotes. But this creates a lot of unnecessary code (some of my tables are 80 columns wide and the query therefore have equal amount of variables).

So to summarise, why is this happening and how do I neatly avoid assigning quotes to the empty strings? In other words, how do I insert nothing when variables that usually contain an integer is on occation empty?

i have this code to set a date to the 1st of the previous month --

SELECT DATE_FORMAT(DATE_SUB(tbl_col, INTERVAL 1 MONTH), '%Y-%m-01') FROM table

can it be changed to set date to first Monday in that month...?

Ok well i have a virtual world, my friendcoded the emulator. In PHP but he's on holiday for 2 weeks. I keep getting
Quote

PHP Warning:  PHP Startup: It is not safe to rely on the system's timezone setti
ngs. You are *required* to use the date.timezone setting or the date_default_tim
ezone_set() function. In case you used any of those methods and you are still ge
tting this warning, you most likely misspelled the timezone identifier. We selec
ted 'Europe/London' for '0.0/no DST' instead in Unknown on line 0
PHP Warning:  eval(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/London' for '0.0/no DST' instead in C:\inetpub\wwwroot\main\server\chapat
iz.php(2) : eval()'d code on line 4


But there are only 4 lines in chapatiz.php and it has nothing to do with it i think
Quote

<?php
eval(file_get_contents('serv_original.ini'));
?>



Here's chapatiz.php
(Its attached since its big)
Quote


//config

$socketurl = "munizonline.co.uk;
$httpurl = "munizonine.co.uk;
$rootPath = "c:/inetpub/wwwroot/";

// SQL SETTINGS
$host = 'localhost';
$user = 'root';
$dbname = 'chapatiz';
$password = '---';




$sqli = new mysqli("p:". $host, $user, $password, $dbname); // create a persistant sql connexion (keepAlive)



$banned_ips = array();
///// ADD BAN BY IP FROM HTACCESS
$filename = $rootPath.".htaccess";
$handle = fopen($filename, "r");
$contents = fread($handle, filesize($filename));
fclose($handle);
$contents = utf8_decode($contents);
$ex = explode("\n", $contents);
$exf = array();
foreach ($ex AS $k => $str) {
if(preg_match('`deny from (.*?) \#`', $str, $sortie)) {
$return = $sortie[1]; array_push($exf, $return);
}
}
foreach ($exf AS $k => $str) {
array_push($banned_ips, $str);
}

// LOG ALL ACTIONS
function dolog($text)
{
$myFile = "c:/inetpub/wwwroot/main/log/chat.txt";
$fh = fopen($myFile, 'a');
fwrite($fh, $text. "\n");
fclose($fh);
}


function serve($r)
{
return file_get_contents('C:/inetpub/wwwroot/main/server/serve/'. $r. '.php');
}





function getitems($name)
{
return file_get_contents('http://munizonline.co.uk/main/items.php?u='. $name);
}


function haveitem($name, $item)
{
$c = file_get_contents('http://munizonline.co.uk/main/items.php?u='. $name);
$pattern = '/"'. $item .'"/'; $pattern2 = '/"0'. $item .'"/';
if ((preg_match($pattern, $c)) OR (preg_match($pattern2, $c)))
{
return true;
}
else
{
return false;
}
}



function dotag($tag)
{
$tag = explode('##', $tag);
$tags = array();
foreach ($tag AS $k => $v)
{
list($name, $value) = explode('=', $v);
$tags[$name] = $value;   
}
return $tags;
}


function updatetag($tags, $tochange, $value)
{
$tags[$tochange] = $value; $new = "##";
foreach ($tags AS $k => $v)
{
$new .= $k. "=". $v. '##';
}
return $new;
}



ini_set('display_errors', '1');

error_reporting(0);

$quete8 = $sqli->query('UPDATE phpbb_users SET online = 0');
function cmd()
{
return false;
}
$modee = false;
session_start();
$_SESSION['start'] = "yess";
$mainsock = socket_create(AF_INET, SOCK_STREAM, 0);
  //modifiez la prochaine ligne si besoin

$pport = rand(81, 8000);
while (!socket_bind($mainsock, $socketurl, $pport))
{
$pport = rand(81, 8000); echo "\n port modified to ". $pport. "\n";
}

$myFile = $rootPath."main/server/socket.php";
$fh = fopen($myFile, 'w+') or die("can't open file");
fwrite($fh, $socketurl. ":". $pport);
fclose($fh);


socket_set_nonblock($mainsock);
socket_listen($mainsock);

$clients=Array();
$compteur=0;
$write = NULL;
$except = NULL;
$lol = NULL;
$race = "0";
$flag = "0";
date_default_timezone_set('Europe/London');
$ok_marry = "0";
$ok_pv = "0";

function random($car) {
$string = "";
return $string;
}


function random3($car3) {
$string3 = "";
return $string3;
}

function random2($car2) {
$string2 = "";
return $string2;
}

function random1($car1) {
$string1 = "";
return $string1;
}

echo("Waiting for players!\n");

$file = file_get_contents($rootPath.'main/server/server_while.php');
$lasteval = time();
while(true){
if ($lasteval <= strtotime('-1 minute'))
{
if (file_exists($rootPath."main/server/server_while.php")) {
$file = file_get_contents($rootPath.'main/server/server_while.php');
}
$lasteval = time();
echo "\neval again\n\n";
}
eval($file);
}



I have no clue whats wrong it use to work.

 v=$("#txtusername");
  $.post('../actions/check.php',{user:v.val().toLowerCase()},function(d){
  if(d=='available'){
    $("#usernamemessage").html("<span style='color:green;'>Username is available</span>");
   }else  if(d=='not-available'){
  $( "#txtusername" ).effect( "shake" );
$('#txtusername').css('border', 'solid 2px blue');
 var iserror = '1'
 alert(iserror);
}
});

alert(iserror);

The first alert displays '1', however, the second displays 'undefined'. Why is this?

Thanks

I have tried a large number of "solutions" to  this but everytime I use them I see 0000-00-00 in my date field instead of  the date even though I echoed and can see that the date looks correct.

Here's where I'm at:
I have a drop down for the month (1-12) and date fields (1-31) as well as a text input field for the year.  Using the POST array, I  have combined them into the xxxx-xx-xx format that I am using in my field as a date field in mysql. 

<code>
$date_value =$_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];
echo $date_value;
</code>

This outputs 2012-5-7 in my test echo but 0000-00-00 in the database.

I have tried unsuccessfully to use in a numberof suggested versions of:
strtotime()
mktime

Any help would be extremely appreciated.
I am aware that I need to validate this data and insure  that it is a valid date. That I'm okay with. I would like some help on getting it into the database.

I have a form where users enter name, username, password etc. The values are posted to a MySQL table where I also have a field called 'ID' that auto increments. I want to store that ID in a SESSION variable that I can carry over to other pages. Need help in doing this please.

Attempting to set a variable = NOW() + INTERVAL 90 DAY;
I can run SELECT DATE_ADD(NOW(), INTERVAL 90 DAY using MYSQL, but don't know how to move result to a variable.

Hi girls and boys

I am trying to set a variable if a session OR a cookie has been set, but am unsure on how to write the statement...

if (isset($_SESSION['name'])||isset($_COOKIE['name'])) {$variable = $_SESSION['name']||$_COOKIE['name'];}

Obviously not working there, but just need a pointer here.
any help is appreciated...

i'm creating a page counter which updates a value in a database each time the page is loaded.
I'm trying to make it so that it checks to see if a session has been set, if not, it updates the database, and then sets the session. This way it wont update every time someone refreshes the page.

$id=$_GET['id'];
if(!isset($_SESSION[$id])){
$_SESSION[$id]= $id;
$views = $row['views'] + 1;
$update_views=mysql_query("UPDATE topic SET views='".$views."' WHERE topic_id='".$id."'")

i want to set the session variable as that of the page id ($id)
The problem is that it keeps updating the database everytime the page is reloaded. I'm not sure if i'm setting the session variable correctly.
Any ideas would be great

Thanks

Hi there,

I have a string '12/04/1990', that's in the format dd/mm/yyyy.

I'm attempting to convert that string to a Date, and then insert that date into a MySQL DATE field.

The problem is, every time I try to do so, I keep getting values like this in the database: 1970-01-01.


Any ideas?


Much appreciated.

Here is my code:
// Start MySQL Query for Records
$query = "SELECT codes_update_no_join_1b" .
"SET orig_code_1 = new_code_1,
       orig_code_2 = new_code_2" .
"WHERE concat(orig_code_1, orig_code_2) = concat(old_code_1, old_code_2)";
$results = mysql_query($query) or die(mysql_error());
// End MySQL Query for Records


This query runs perfectly fine when run direct as SQL in phpMyAdmin, but throws this error when running in my script??? Why is this???

Code: [Select]
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 '= new_code_1, orig_code_2 = new_code_2WHERE concat(orig_code_1, orig_c' at line 1

If you also have any feedback on my code, please do tell me. I wish to improve my coding base.

Basically when you fill out the register form, it will check for data, then execute the insert query. But for some reason, the query will NOT insert into the database. In the following code below, I left out the field ID. Doesn't work with it anyways, and I'm not sure it makes a difference.

Code:

  Code: [Select]
mysql_query("INSERT INTO servers (username, password, name, type, description, ip, votes, beta) VALUES ($username, $password, $name, $server_type, $description, $ip, 0, 1)");
Full code:

Code: [Select]
<?php
include_once("includes/config.php");
 
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><? $title; ?></title>
<meta http-equiv="Content-Language" content="English" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="style.css" media="screen" />
</head>
<body>
 
<div id="wrap">
 
<div id="header">
<h1><? $title; ?></h1>
<h2><? $description; ?></h2>
</div>
 
<? include_once("includes/navigation.php"); ?>
 
<div id="content">
<div id="right">
<h2>Create</h2>
<div id="artlicles">
<?php
 
if(!$_SESSION['user'])
{
 
        $username = mysql_real_escape_string($_POST['username']);
        $password = mysql_real_escape_string($_POST['password']);
        $name = mysql_real_escape_string($_POST['name']);
        $server_type = mysql_real_escape_string($_POST['type']);
        $description = mysql_real_escape_string($_POST['description']);
 
        if(!$username || !$password || !$server_type || !$description || !$name)
        {

        echo "Note: Descriptions allow HTML. Any abuse of this will result in an IP and account ban. No warnings!<br/>All forms are required to be filled out.<br><form action='create.php' method='POST'><table><tr><td>Username</td><td><input type='text' name='username'></td></tr><tr><td>Password</td><td><input type='password' name='password'></td></tr>";
        echo "<tr><td>Sever Name</td><td><input type='text' name='name' maxlength='35'></td></tr><tr><td>Type of Server</td><td><select name='type'>
       
        <option value='Any'>Any</option>
        <option value='PvP'>PvP</option>
        <option value='Creative'>Creative</option>
        <option value='Survival'>Survival</option>
        <option value='Roleplay'>RolePlay</option>
       
        </select></td></tr>
       
        <tr><td>Description</td><td><textarea maxlength='1500' rows='18' cols='40' name='description'></textarea></td></tr>";
        echo "<tr><td>Submit</td><td><input type='submit'></td></tr></table></form>";
        }
        elseif(strlen($password) < 8)
        {
        echo "Password needs to be higher than 8 characters!";
        }
        elseif(strlen($username) > 13)
        {
                echo "Username can't be greater than 13 characters!";
        }
        else
        {
                $check1 = mysql_query("SELECT username,name FROM servers WHERE username = '$username' OR name = '$name' LIMIT 1");
               
                if(mysql_num_rows($check1) < 0)
                {
                        echo "Sorry, there is already an account with this username and/or server name!";
                }
                else
                {
                        $ip = $_SERVER['REMOTE_ADDR'];

                        mysql_query("INSERT INTO servers (username, password, name, type, description, ip, votes, beta) VALUES ($username, $password, $name, $server_type, $description, $ip, 0, 1)");
                        echo "Server has been succesfully created!";
                }
        }
       
}
else
{
        echo "You are currently logged in!";
}
 
?>
</div>
</div>
 
<div style="clear: both;"> </div>
</div>
 
<div id="footer">
<a href="http://www.templatesold.com/" target="_blank">Website Templates</a> by <a href="http://www.free-css-templates.com/" target="_blank">Free CSS Templates</a> - Site Copyright MCTop
</div>
</div>
 
</body>
</html>