Remove Date() fucntion

[dr_aybyd]

Hi, I need to remove the date function on this script

<?php
    include("config.php");
    
    $name       = addSlashes($_POST['name']);
    $email      = $_POST['email'];
    $comment    = addSlashes($_POST['comment']);
    $date_added = time();
    
    $check = mysql_query("insert into comment(name,email,comment,date_added) values('$name','$email','$comment','$date_added')");
    
    $date_added = date("l j F Y, g:i a",time());

    if($check)
        echo $date_added;
    else
        echo "0";
?>

and here is the ajax script for that

$.ajax({
               type: "POST",
               url: "ajax_server.php",
               data: "name="+name+"&email="+email+"&comment="+comment,
               success: function(date_added){
                  if(date_added != 0)
                   {
                       structure = '<div class="comment_holder"><div id="photo"><img src="images/user.gif" width="60" height="70"><br>'+name+'</div><div id="comment_text"><div id="date_posted">'+date_added+'</div>'+comment+'</div></div>';                      
                       $(".no_comments").fadeOut("slow");
                       $("#ajax_response").prepend(structure);
                       $(".comment_table").find('textarea, input:text').each(function () {
                           $(this).val("");
                       });
                   }
                  else
                      alert("Unexpected error...!");
                        $("#loading").css("visibility","hidden");
               }
             });
      }
  }); 

I need to remove Date function on saving into my database.. I don't want to include system date value.. coz I change my data value to auto time_stamp on my phpmyadmin.

[kows]

well, just remove it then.

<?php 
    include("config.php"); 
     
    $name       = addSlashes($_POST['name']); 
    $email      = $_POST['email']; 
    $comment    = addSlashes($_POST['comment']); 
     
    $check = mysql_query("insert into comment (name, email, comment) values('$name', '$email', '$comment')"); 
    
    $date_added = date("l j F Y, g:i a"); 
    if($check) 
        echo $date_added; 
    else 
        echo 0; 
?>

[dr_aybyd]

@kows

I tried your codes but it give me this error

Warning: date() [function.date]: 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 'America/Los_Angeles' for '-7.0/DST' instead in C:\xampp\htdocs\Comment\ajax_server.php on line 10

And that is pointing in this line

$date_added = date("l j F Y, g:i a");

And no data saved into database.

[kows]

then go into your php.ini file and set a default timezone (date.timezone setting), or call the function date_default_timezone_set().

date_default_timezone_set('America/Los_Angeles'); 

[dr_aybyd]

still getting error

Since Date is set in my phpmyadmin for automatic
I remove this part

    $date_added = date("l j F Y, g:i a",time());

    if($check)
        echo $date_added;
    else
        echo "0";

When I submit a data to my database

I got this error

"Unexpected error...!"

So I need to modify this part too

$.ajax({
               type: "POST",
               url: "ajax_server.php",
               data: "name="+name+"&email="+email+"&comment="+comment,
               success: function(date_added){
                  if(date_added != 0)
                   {
                       structure = '<div class="comment_holder"><div id="photo"><img src="images/user.gif" width="60" height="70"><br>'+name+'</div><div id="comment_text"><div id="date_posted">'+date_added+'</div>'+comment+'</div></div>';                      
                       $(".no_comments").fadeOut("slow");
                       $("#ajax_response").prepend(structure);
                       $(".comment_table").find('textarea, input:text').each(function () {
                           $(this).val("");
                       });
                   }
                  else
                      alert("Unexpected error...!");
                        $("#loading").css("visibility","hidden");
               }
             });
      }
  });

I think I need to remove this part too

function(date_added){
                  if(date_added != 0)
                   {

But I don't know the proper way..I am new in php and ajax ;(

[kows]

no, you don't need to remove any of the things that you removed. all of those things are needed because those are the key things that make this work. you don't seem to really know how AJAX works.

"Unexpected error..!" is a message that gets displayed because $check is false (meaning the query failed); this means there is a problem with your query, not anything else.

make a MySQL dump of your table (in phpMyAdmin, export your table's structure), and post it here.

[dr_aybyd]

its working now...thanks kows