PHP - Date Output Error

I am getting syntax error, unexpected T_CONSTANT_ENCAPSED_STRING
on the date stamp line below but I can't see what is causing the problem.
when I comment it out the problem goes away so I know I it is there.
please help.
 
$email_message = "Form details below.\n\n";
 $email_message = date("m/d/Y")"\n";

I have a script that opens up a CSV file and outputs to a table for testing. It ultimately inserts into a MySQL but the code below literally duplicates every third row consistently. I'm 95% sure its in the "WHILE" area.  Is there enough code here for someone to point out an error. If not I can put the code up live and if you want a fee for fixing just PM me please.

Code: [Select]
$fp = fopen("residential-data.csv", "r");
$listings=-1;
function getZip($full)
{
$pieces = explode(' ', $full);
$zip = explode('(', $pieces[count($pieces)-1]);
$zip = explode(')', $zip[1]);
return $zip[0];
}

$pre="";
while (($data = fgets($fp,4096)) !== FALSE)
{
$data=str_replace("\r\n","",$data);
if(trim($data)=="" or substr($data,strlen($data)-1,1)!='"' or substr($data,strlen($data)-2,2)==',"')
{
$pre.=$data;
}

I use this code:
Code: [Select]
<?php
$databasehost = "localhost";
$databasename = "export_ajur";
$databasetable = "invoice";
$databaseusername ="root";
$databasepassword = "password";
$fieldseparator = ",";
$lineseparator = "\n";
$csvfile = "1.csv";

$addauto = 0;


$save = 1;
$outputfile = "output.sql";
if(!file_exists($csvfile)) {
echo "File not found. Make sure you specified the correct path.\n";
exit;
}
$file = fopen($csvfile,"r");

if(!$file) {
echo "Error opening data file.\n";
exit;
}

$size = filesize($csvfile);

if(!$size) {
echo "File is empty.\n";
exit;
}

$csvcontent = fread($file,$size);

fclose($file);

$con = @mysql_connect($databasehost,$databaseusername,$databasepassword) or die(mysql_error());
@mysql_select_db($databasename) or die(mysql_error());

$lines = 0;
$queries = "";
$linearray = array();

foreach(explode($lineseparator,$csvcontent) as $line) {

$lines++;

$line = trim($line," \t");

$line = str_replace("\r","",$line);


$linearray = explode($fieldseparator,$line);

$linemysql = implode("','",$linearray);

if($addauto)

$query = "insert into $databasetable values('$linemysql');";
else
$query = "insert into $databasetable values ('$linemysql');";

$queries .= $query . "\n";

@mysql_query($query);
}

@mysql_close($con);

if($save) {

if(!is_writable($outputfile)) {
echo "File is not writable, check permissions.\n";
}

else {
$file2 = fopen($outputfile,"w");

if(!$file2) {
echo "Error writing to the output file.\n";
}
else {
fwrite($file2,$queries);
fclose($file2);
}
}

}

echo "Found a total of $lines records in this csv file.\n";


?>

And th output is:

Code: [Select]
insert into invoice values ('ID_PURCHASE_INVOICE','DOC_TYPE_NAME','DOC_EXT_CODE','DOC_NUM','DOC_DATE','WOVAT_AMOUNT','VAT_AMOUNT','TOTAL_AMOUNT','CONTRAGENT_NAME','CONTRAGENT_BULSTAT','CONTRAGENT_VATNUMBER','CONTRAGENT_POST_ADDRESS','CONTRAGENT_ZIP','CONTRAGENT_CITY','CONTRAGENT_AREA','CONTRAGENT_STREET','CONTRAGENT_MOL','CONTRAGENT_PHONE','CONTRAGENT_BANK','CONTRAGENT_BANK_CODE','CONTRAGENT_BANK_ACCOUNT','CONTRAGENT_EXT_CODE','CONTRAGENT_EMAIL','PAYMENT_NAME','DOC_MARKER1','DOC_MARKER2','DOC_MARKER3','DOC_MARKER4','DOC_MARKER5','DOC_MARKER6','DOC_MARKER7','DOC_MARKER8','DOC_MARKER9','DOC_MARKER10');
insert into invoice values ('108826','ДАНЪЧНА ФАКТУРА','1','111366','2/15/2012','160.08','32.02','192.1','ПРЕЦИЗ ООД','103565237','BG103565237','ВАРНА ГЕН.КОЛЕВ 38','','','','','','','','','','','','БАНКА','','','','','','','','','','');
insert into invoice values ('108830','ДАНЪЧНА ФАКТУРА','1','1002304974','2/15/2012','872.33','174.46','1046.79','ОМВ БЪЛГАРИЯ ООД','121759222','BG121759222','','','СОФИЯ','','','','','','','','','','БАНКА','','','','','','','','','','');
insert into invoice values ('');

I need to remove last line ' insert into invoice values (''); . How to change my code?

Hi

Hope someone can help me please.

I have constructed an audio dictionary and have discovered an error now that I have added a few entries to the database.

A user can search the database and can click on a result to be taken to the content associated with the entry he chooses.

This is the search function;

Code: [Select]
$search=$_POST["search"];


//get the mysql and store them in $result

$result = mysql_query("SELECT word FROM pro_words WHERE word LIKE '%$search%'");
       
//get the db content that is specified above

if (mysql_num_rows($result) < 1) {

echo "<br><br><h2> We didn't find anything. Sorry - we did look though.</h2>";

}else {
         
echo '<table align="center" cellspacing="8" cellpadding="8" width="85%"><tr><td align="left"><b>Word</b></td></tr>';

echo "<br><br><h2>Success! Here's what we found:</h2><br>";

while ($r=mysql_fetch_array($result, MYSQLI_ASSOC))

echo '<h2><tr><td align="left"><a href="word.php?w=' . $r['word'] . '">' . $r['word'] . '</a></td></tr></h2>';

}

You will see that content is displayed in a new file called word.php.

This is relevant code from word.php

Code: [Select]

$query = "SELECT word,word_type1,sentence1,word_type2,sentence2,word_type3,sentence3 FROM pro_words";

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){


echo '<div class="colmask rightmenu">';
echo '<div class="colleft">';
echo '<div class="col1">';
echo '<p>Here are some example sentences that show how we use the word; </p>';
echo '<div id="small"><i> ' . $row['word_type1'] . '</i></div>';
echo '<p><div id="small">' . $row['sentence1'] . '</p></div>';
echo '<div id="small"><i> ' . $row['word_type2'] . '</i></div>';
echo '<p><div id="small">' . $row['sentence2'] . '</p></div>';
echo '<div id="small"><i> ' . $row['word_type3'] . '</i></div>';
echo '<p><div id="small">' . $row['sentence3'] . '</p></div>';

}

The problem is that every entry on the database is echoed in word.php whereas I would like only the entries for the word selected to appear.

Thanks in advance for any help; do say if you need more info.

Hello,

The below code works on my home machine.. but not on my Linux machine, I am unable to figure out the problem, please help

Code: [Select]
require_once("dbconnection.php");

function coun_list()
{
$rs=mysql_query("select name from timezones") or die(mysql_error());
while($row=mysql_fetch_row($rs))
  {
   $tzone=$row[0];
   if($tzone=='Asia/Calcutta') $tzone='Asia/Kolkata';
   try {
       $tz = new DateTimeZone("$tzone");
       $lt=$tz->getLocation();
       $lat=$lt['latitude'];
       $lon=$lt['longitude'];
       echo "$tzone";
       }
      catch (Exception $e) {
        echo 'Caught exception: ',  $e->getMessage(), "\n";
       }
  }
}

coun_list();


I get the below error on my Linux machine,
Code: [Select]
Caught exception: DateTimeZone::__construct() [datetimezone.--construct]: Unknown or bad timezone ()
Please help me to figure out the issue..

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.

My script reports the time with a six minute error added to the current time. I can't figure out why.

I wrote a different script for solar calculation and get a 7 minute error subtracted. I'm hoping a response to this post will help me solve both problems.

I abbreviated the six minute error script to simplify the problem.

=====================================================

date_default_timezone_set("America/New_York");
$date = new DateTime();
$date4 = new DateTime();
echo(date("Y-m-d H:i:s"))."    date\n";
$now = new DateTime();
$timestring = $now->format('Y-m-d H:i:s');
echo($timestring)."    timestring\n";
$date2=date_create(date("y-m-d"));
$date4=date_create(date("y-m-d"));
date_add($date,date_interval_create_from_date_string("0 Hours"));
date_add($date4,date_interval_create_from_date_string("06 Hours"));
echo date_format($date2,"Y-m-d, H:m:s")."    date2\n";
echo date_format($date4,"Y-m-d, H:m:s")."    date4\n";

=======================================================

Here is the code im using

$dateOfBirth = '';

preg_match('|Born on ([a-zA-Z]*\s[0-9]*,\s[0-9]*)\\\u003c\\\/span>|', $page, $match);
    if($match && count($match)>0) {
      

$date = str_replace(",","",$match[1]);

blue($date);

$timestamp = strtotime($date);  
        $dateOfBirth = date('Y-m-d',$timestamp); // 1994-03-23 

    }

else

{

red("No Age is set on profile");

continue;

}

im getting a match like this
March 9, 1993

When i run my script im getting this error

[2048] strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable 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 'America/Chicago' for 'CST/-6.0/no DST' instead
Error: [2048] date() [function.date]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable 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 'America/Chicago' for 'CST/-6.0/no DST' instead

What could be the problem??

Well I have a script that executes a scan on a system set to run infinitely, and I need it to echo out a message each time it loops through, but I don't want it to echo out the message with the next loop message below it, and the next one below that etc... I've tried using the flush(); function and been messing around with that with no luck. For security reasons I don't want to release any of the processing code, but here is the basic construction of the script:

<?PHP
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
$RepeatIt = -1;
for($g=1; $g!=$RepeatIt+1; $g++)
{
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***

$ScanMessage = ":.:.: SCANNING THE HITLIST FOR MOBSTER: ".$MobName." (SCAN #$g) :.:.:"."<br/><br/>";
echo $ScanMessage;

***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
}
?>

At the moment it's returning:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #1) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #2) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #3) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #4) :.:.:

So what I want it to do is just delete the scanning message and replace it with the next scan message so while running this script you would see just the number increment on the same line.

Any suggestions?

Thanks.

Hey,

I'm using a script which allows you to click on a calendar to select the date to submit to the database.

The date is submitted like this: 2014-02-08

Is there a really simple way to prevent rows showing if the date is in the past?

Something like this:
if($currentdate < 2014-02-08 || $currentdate == 2014-02-08) {

}

Thanks very much,
Jack

Hello. I'm new to pHp and I would like to know how to get my $date_posted to read as March 12, 2012, instead of 2012-12-03.
Here is the code:
Code: [Select]
<?php

$sql = " SELECT id, title, date_posted, summary FROM blog_posts ORDER BY date_posted ASC LIMIT 10 ";

$result = mysql_query($sql);

while($row = mysql_fetch_assoc($result)) {
$id = $row['id'];
$title = $row['title'];
$date_posted = $row['date_posted'];
$summary = $row['summary'];

echo "<h3>$title</h3>\n";
echo "<p>$date_posted</p>\n";
echo "<p>$summary</p>\n";
echo "<p><a href=\"post.php?id=$id\" title=\"Read More\">Read More...</a></p>\n";
}

?>
I have tried the date() function but it always updates with the current time & date so I'm a little confused on how I get this to work.

Alright, I have a Datetime field in my database which I'm trying to store information in. Here is my code to get my Datetime, however it's returning to me the wrong date. It's returning:
1969-12-31 19:00:00

$mysqldate = date( 'Y-m-d H:i:s', $phpdate );
$phpdate = strtotime( $mysqldate );
echo $mysqldate;


Is there something wrong with it?

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.

(continuing from topic title)
So if I set a date of July 7 2011 into my script, hard coded in, I would like the current date to be checked against the hard coded date, and return true if the current date is within a week leading up to the hard coded date.

How could I go about doing this easily?

I've been researching dates in php but I can't seem to work out the best way to achieve what I'm after.

Cheers
Denno

Hi,

I have a job listing website which displays the closing date of applications using:

$expired_date

(This displays a date such as 31st December 2019)

I am trying to show a countdown/number of days left until the closing date.

I have put this together, but I can't get it to show the number of days.

                    <?php 
                    $expired_date = get_post_meta( $post->ID, '_job_expires', true );
                    $hide_expiration = get_post_meta( $post->ID, '_hide_expiration', true );
                    if(empty($hide_expiration )) {
                        if(!empty($expired_date)) { ?>
                                <span><?php echo date_i18n( get_option( 'date_format' ), strtotime( get_post_meta( $post->ID, '_job_expires', true ) ) ) ?></span>
                    
                    <?php
                                        $datetime1 = new DateTime($expired_date);
                                        $datetime2 = date('d');
                                        $interval = $datetime1->diff($datetime2);
                                        echo $interval->d;

                     ?>
                        <?php }
                    } 
                    ?>

Can anyone help me with what I have wrong?

Many thanks