Pahelped naman Dito Sa PHP Coding Mga Master Na>

[buhayko]

ito po yung picture sana matulungan nyo ako sa time and Date ,,nais ko sana mang yari kapg my nag post sa website makikita yung Date at Time kailan xia ngcomment,,


View attachment 272013 View attachment 272014
-----------------------------------------------------------------------------
ito naman yung Code sa submit.phph>>
-----------------------------------------------------------------------------
<?php
include("db.php");
if($_SERVER["REQUEST_METHOD"] == "POST")
{
$name=mysql_real_escape_string($_POST['name']);
$email=mysql_real_escape_string($_POST['email']);
$subject=mysql_real_escape_string($_POST['subject']);
$message=mysql_real_escape_string($_POST['message']);
if(strlen($name)>0 && strlen($email)>0 && strlen($subject)>0 && strlen($message)>0)
{
$time=time();
mysql_query("INSERT INTO contact (name,email,message,subject,created_date) VALUES('$name','$email','$message','$subject','$time')");
}
}
header("Location: http://mypersonalinfo.esy.es/MyPersonalInfo/index.html?msg='.$msg.'");
$msg= "Thank you For comment";
?>




--------------------------------------------
at ito index.html>>> lalagyan kurin ba ng Date code dito or hindi na>>
----------------------------------------
<div class="contact-form">
<form name="form" id="form" action="submit.php" method="post">
<ul id="ngothastyle3">
<li>
<label><font color="green">Name</label></font><br>
<input type="text" name="name" class="" maxlength="40" required />
</li>
<li>
<label><font color="green">Email</label></font><br>
<input type="text" name="email" class="" maxlength="100" required />
</li>
<li>
<label><font color="green">Subject</label></font><br>
<input type="text" name="subject" class="" maxlength="100" required />
</li>
<li>
<label><font color="green">Message</label></font><br>
<textarea name="message" rows="5" cols="45" class=""></textarea>
<label> </label>

<input type="submit" value="Submit">
</ul>
</form> </div>

 

[regie180]

time stamp

 

[buhayko]

yung tamang coding po ayaw kasi gumana sa akin nyan e

 

[guys69]

ito po yung picture sana matulungan nyo ako sa time and Date ,,nais ko sana mang yari kapg my nag post sa website makikita yung Date at Time kailan xia ngcomment,,


View attachment 1127949 View attachment 1127950
-----------------------------------------------------------------------------
ito naman yung Code sa submit.phph>>
-----------------------------------------------------------------------------
<?php
include("db.php");
if($_SERVER["REQUEST_METHOD"] == "POST")
{
$name=mysql_real_escape_string($_POST['name']);
$email=mysql_real_escape_string($_POST['email']);
$subject=mysql_real_escape_string($_POST['subject']);
$message=mysql_real_escape_string($_POST['message']);
if(strlen($name)>0 && strlen($email)>0 && strlen($subject)>0 && strlen($message)>0)
{
$time=time();
mysql_query("INSERT INTO contact (name,email,message,subject,created_date) VALUES('$name','$email','$message','$subject','$time')");
}
}
header("Location: http://mypersonalinfo.esy.es/MyPersonalInfo/index.html?msg='.$msg.'");
$msg= "Thank you For comment";
?>




--------------------------------------------
at ito index.html>>> lalagyan kurin ba ng Date code dito or hindi na>>
----------------------------------------
<div class="contact-form">
<form name="form" id="form" action="submit.php" method="post">
<ul id="ngothastyle3">
<li>
<label><font color="green">Name</label></font><br>
<input type="text" name="name" class="" maxlength="40" required />
</li>
<li>
<label><font color="green">Email</label></font><br>
<input type="text" name="email" class="" maxlength="100" required />
</li>
<li>
<label><font color="green">Subject</label></font><br>
<input type="text" name="subject" class="" maxlength="100" required />
</li>
<li>
<label><font color="green">Message</label></font><br>
<textarea name="message" rows="5" cols="45" class=""></textarea>
<label>?</label>

<input type="submit" value="Submit">
</ul>
</form> </div>

okay lang naman yang code mo, na timestamp ang iniistore mo, kung i reretrieve mo yan, use DATE FORMATS in PHP

 

[buhayko]

paano sir ayaw pumaxok kasi sa database yung time and date kasi

 

[ditchx]

Change:

$time=time();

to:

$time= date('Y-m-d H:i:s');

 

[eugcar]

yung table mo! gawin mo datetime and then sundin mo itong code ni ditchx

$time= date('Y-m-d H:i:s');

 

[buhayko]

tnx tlga master sa tulong ninyo..gumana nga xia

 

[eugcar]

ok good kung ganun

 

[madamt0001]

mysql_query("INSERT INTO contact (name,email,message,subject,created_date) VALUES('$name','$email','$message','$subject',NOW())");

yung $time => NOW() function sa sql

eto kasi gamit ko. sana makatulong