Help! How do I remove the time in this PHP Script?

stennchau · March 8, 2007

Hi,

I am new to PHP and I need help to remove the time (but keep the date).

Here is the script. Thank You in advance for your help.

<?php

require_once('../config/config.php');

require_once('../config/func.php');

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

</head>

function check(id)

{

if (confirm('Are you sure?'))

{

window.location='news.php?action=del&id=' + id;

}

function clear_form(form)

{

form.elements[0].value='';

form.elements[1].value='';

form.text.value='';

}

</script>

<body>

<?php

$form=$_GET['form'];

if (auth())

{

if (!empty($_GET['action']))

{

$action=$_GET['action'];

if ($action=='add' || ($action=='edit' && strlen($_POST['id'])))

{

if (!empty($_POST['tytul']) && !empty($_POST['data']) && !empty($_POST['text']))

{

$tytul=str_replace('"', '"', $_POST['tytul']); $data=str_replace(",", "", $_POST['data']); $text=str_replace('"', '"', $_POST['text']);

if (preg_match("/[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}/", $data))

{

if ($action=='add')

$sql="INSERT INTO `news` VALUES ('', '$tytul', '$data', '$text')";

else

{

$id=$_POST['id'];

$sql="UPDATE `news` SET `tytul`='$tytul', `data`='$data', `tresc`='$text' WHERE `id_news`='$id'";

}

if (mysql_query($sql))

{

switch_page('news.php?form=' . (($action=='add') ? 'add' : 'edit/delete'), (($action=='add') ? 'Added' : 'Updated') . ' news!');

}

else

error('Error in SQL query! MySQL: ' . mysql_error() . '

<a href="javascript:history.go(-1)">return[/url]');

}

else

error('Wrong date format (yyyy-mm-dd, hh:mm:ss)! <a href="javascript:history.go(-1)">return[/url]');

}

else

error('<div class="error">Fill all fields! <a href="javascript:history.go(-1)">return[/url]');

}

elseif($action=='del' && strlen($_GET['id']))

{

$id=$_GET['id'];

if(mysql_query("DELETE FROM `news` WHERE `id_news`='$id'"))

{

switch_page('news.php?form=edit/delete', 'Deleted news from database');

}

else

error('Error in SQL query! MySQL: ' . mysql_error() . '

<a href="javascript:history.go(-1)">return[/url]');

}

else

{

if ($form=='add')

{

?>

<?php

if (($_GET['mode']=='edit') && (strlen($_GET['id'])))

{

$id&=$_GET['id'];

if($result=mysql_query("SELECT tytul, data, tresc FROM news WHERE `id_news`='$id'"))

{

$t=@mysql_result($result, 0, 0);

$d=@mysql_result($result, 0, 1);

$text=@mysql_result($result, 0, 2);

$read=false;

if (strlen($t) && strlen($d) && strlen($text))

$read=true;

else

error('Error while trying to read data. Cannot display information!');

}

else

error('Error in SQL query! MySQL: ' . mysql_error() . '

Cannot display data!');

}

?>

<?php if($read && ($_GET['mode']=='edit')) echo '<input type="hidden" name="id" value="'.$id .'">'; ?>

<tr>

<td>Title:</td><td><input type="text" name="tytul" maxlength="100" size="50" value="<?php if($read && ($_GET['mode']=='edit')) echo $t; ?>"></td>

</tr>

<tr>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

</tr>

<tr>

<td></td><td><input <?php echo (($read && ($_GET['mode']=='edit')) ? 'type="button"' : 'type="reset"'); ?> value="RESET" onClick="clear_form(this.form);">

</tr>

</form>

</table>

<?php

}

elseif($form=='edit/delete')

{

?>

<td width="250">Title</td>

</tr>

<?php

if ($result=mysql_query('SELECT `id_news`, `tytul`, `data` FROM `news` ORDER BY `data`'))

{

if (mysql_num_rows($result) > 0)

{

while($row=mysql_fetch_assoc($result))

{

echo '<tr onMouseOver="style.background=\'#eeeeee\'" onMouseOut="style.background=\'#ffffff\'" style="cursor: default">

<td>' . str_replace(' ', ', ', $row['data']) . '</td>

<td>' . $row['tytul'] . '</td>

</tr>';

}

else

error('<tr><td colspan="3">No news in database table</td></tr>');

}

else

error('<tr><td colspan="3">Error in SQL query! MySQL: ' . mysql_error() . '</td></tr>');

mysql_free_result($result);

?>

</table>

<?php

}

?>

</body>

</html>

HaLo2FrEeEk · March 8, 2007

#
#-----[ FIND ]------------------------------------------
#

else print date("Y-m-d, H:i:s", time()); ?>

#
#-----[ IN-LINE, FIND ]------------------------------------------
#

date("Y-m-d, H:i:s", time())

#
#-----[ REPLACE WITH ]------------------------------------------
#

date("Y-m-d")

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM

Should solve your problem.

Please post all code inside [ code] and [/ code] (without spaces) tags, it helps people find what we are looking for inside the code.

stennchau · March 8, 2007

Hi HaLo2FrEeEk,

Thank you... But there is another problem....

It comes out like this "2007-03-07 00:00:00" on my website!!

How do I remove all the time??

HaLo2FrEeEk · March 12, 2007

Sorry it took so long to reply, after doing the previous one, try this:

#
#-----[ FIND ]------------------------------------------
#

else print date("Y-m-d, H:i:s", time()); ?> (yyyy-mm-dd, hh:mm:ss)

#
#-----[ IN-LINE, FIND ]------------------------------------------
#

(yyyy-mm-dd, hh:mm:ss)

#
#-----[ REPLACE WITH ]------------------------------------------
#

(yyyy-mm-dd)

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM

I don't know if that will work, I'd need to see the page you are working on before I an really know what to do, also, try using single quotes for the date instead of double quotes, that might work.

Hope this helps.

stennchau · March 13, 2007

Thank You...I got it now

Sign In

Help! How do I remove the time in this PHP Script?

Recommended Posts

stennchau

Link to comment

Share on other sites

HaLo2FrEeEk

Link to comment

Share on other sites

stennchau

Link to comment

Share on other sites

HaLo2FrEeEk

Link to comment

Share on other sites

stennchau

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information