PHP - How To Make A Questionnaire System & Record User Responses With Time Stamp?

I have this code to change the validity date of an account.
I do a check against timestamp and current validity which works  fine.
Then I have radio buttons you can check to choose to extend with one, three, six or 12 months through a form and a post variable - they work too.
When I write the variables out they look fine but when I want it in my database - nothing happens!
I mean the original data is never changed.
Can you see what is wrong?

I tried changing the data type from date to datetime to timestamp with the same result.
I suppose I will learn something new from phpfreaks today again.

Code is here for the 12 month radio button:
Code: [Select]
$newdate = strtotime ( '+12 months' , strtotime ($fromDate) ) ;
$newdate = date ('Y-m-d H:i:s', $newdate );
echo "$newdate";
$query = "UPDATE TABLE user_data SET paid_days='$newdate' WHERE user='$user'";
mysql_query($query);When I write the variable $newdate it shows up as 2013-01-10 21:55 (right now) which seems like a valid format to me.
Do I need to convert it somehow?

I am trying to enter a new time stamp into mysql database when a user logs in at my site.
I read on the update syntax but can't seem to get it to do it.. It reads the values just doesnt write the values into mysql.

$update_query = mysql_query UPDATE users SET (last_access, ip_address, browser, hostname) values ($date, $IP, $browser, $hostname) WHERE username = '$login'") or die("QUERY FAILED: " . mysql_error()); 
$update = ($update_query) or die ("QUERY FAILED: " . mysql_error()); 

Hello, i need a fast convertor that converts the date format 03-03-2008, 08:26 PM into a timestamp fast.
Like, you paste 03-03-2008, 08:26 PM into a post form, submit and it gives you the time stamp.

I made a convertor a whille ago, but you need to insert each numbers into a separate input box (day, months, year etc)
I cant remember how exactly it functions etc asi haventtouched PHP In a while.....

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=315056.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=306905.0

Code: [Select]
for ($z=1;$z<=30*365; $z++)
{
$bal[date('Y-m-d', strtotime("+ ". $z ." days"))] = $balance;//the balance of loan here.;
}

As you can see Im working on loading the daily balance of a 30 year loan in an array.

The code goes to hell in the year 2038.  I have scoured the internet for help.  I have gone to the wikipedia link and have looked at other posts but there isn't quite something that can help me.  How can I load dates beyond 01-18-2038 into my array?

I have heard of ways to do it with MySQL and the DATETIME() function, but that doesn't seem to make sense for what I am trying to accomplish.

Please point me in the right direction.

Thanks.

PHP date and time function is not showing correct time on my local system

I have the following php code

date_default_timezone_set("Africa/Lagos");

$date = date('d-m-y h:i:s');

echo "Server Time ".$date ."<br>";

echo "The time is " . date("h:i:sa")."<br>";

$current_datetime = date("Y-m-d") . ' ' . date("H:i:s", STRTOTIME(date('h:i:sa')));

echo "Current time1: ".$current_datetime . "<br>";

 

Output

Server Time 21-05-21 09:55:39
The time is 09:55:39am
Current time1: 2021-05-21 09:55:39

 

Expected Output

Server Time 21-05-21 10:55:39
The time is 10:55:39am
Current time1: 2021-05-21 10:55:3

 

Any help would be appreciated.

 

Edited May 21 by Ponel

I am having a problem with PHP displaying the correct date and time. It updates as it should, but is fast by 4min and is always displaying a date in 2004. I ran a basic php script to make sure the application im using itself is not wrong. go to lunenburgledger.com/time.php

Anybody had any ideas on where to check? The system time on the Windows Server 2003 is correct. The only thing I can think of is that it was converted to a virtual machine on vmware esxi, but the system time stayed right. Any ideas?

Thanks!

hi
my db table  has 2 field:

ID - Place
1     France
2     Germany

My form has 2 text field (printed with while cycle).

mysql_query("UPDATE mytable SET Place = '" . $_POST['place'] . "' WHERE ID=". $_POST['ID']." ");

This query doesn't work, because updates only the last record.

Where is wrong?

many thanks 

hello all,  I have a table comment as follow:

**Comment**

comment_id         cmt               followupid
1                 Hello              3
2                 hi                 4
3                 Hey                2
4                 wassup             1

My query is that I want to echo "Hello", "hi", "hey" , "Wassup" and other (the record continues) individualy, I have used

$comment = mysql_result($runQuery, $i,"cmt");
echo $comment;

which works fine but the problem is that it echoes all the comments at once, what I want is to echo all the comment but one at a time.  the comment are in  a div tag such that each the div appears only after 1 second the page is loaded. I want each comment to appear after different time interval

for e.g:
 
Hello  to appear at        5pm    (not necessarily the corect time it can be just an int)
hi                         5.10 pm
hey                        6.30 pm

Please Help!

1
Total number of likes work, but I'm guessing it can be done differently, any input would be appreciated.
 
/controllers/indexController.php

$posts = Post::find('all', [
      'limit' => 4,
      'include' => ['likes']
    ]);
    
    foreach ($posts as $post) {
      $post->assign_attribute('likeCount', count($post->likes));
    }
}

 
/models/Post.php

class Post extends ActiveRecord\Model {
  
  static $has_many = [
    ['comments', 'class_name' => 'PostComments'],
    ['likes', 'class_name' => 'UserLikePosts']
  ];
  
}

 
/models/UserLikePosts.php

class UserLikePosts extends ActiveRecord\Model {
    
  static $belongs_to = [
    ['user'],
    ['post']
  ];

}

2
The big question is, how can I get a true/false for "if current user has liked post"? I was thinking something like this, but using vars won't work here, and I would have to use a ternary or a function call to do it like this as the session var might not be set (guest).
 

class Post extends ActiveRecord\Model {

  static $has_many = [
    ['comments'],
    ['likes', 'class_name' => 'UserLikePosts'],
    ['user_likes', 'class_name' => 'UserLikePosts', 'conditions' => ['user_id = ?', [$_SESSION['user']['id']]]
  ];

}

Edited by JimL, 21 June 2014 - 03:36 PM.

Hey guys, I can't wrap my head around how to make this work right...

I have three tables:
Code: [Select]
CREATE TABLE `games` (
  `g_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`g_id`));

CREATE TABLE IF NOT EXISTS `game_player` (
  `r_id` int(11) NOT NULL AUTO_INCREMENT,
  `p_id` int(11) DEFAULT NULL,
  `g_id` int(11) DEFAULT NULL,
  `bool` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`r_id`));

CREATE TABLE IF NOT EXISTS `players` (
  `p_id` int(11) NOT NULL AUTO_INCREMENT,
  `playerid` varchar(150) NOT NULL,
  PRIMARY KEY (`p_id`),
  UNIQUE KEY `playerid` (`playerid`));

The players table is my list of users, and they're tied to the list of games via the game_player table.

So here's my issue... I'm trying to show the full list of games, and then check mark each record where the player does play it. 
This is what I have so far - it shows all the games,  but it's not checking the boxes.

Code: [Select]
$result = mysql_query("SELECT * FROM games") or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$newquery = "SELECT * FROM game_player, players
WHERE game_player.p_id = players.p_id
AND game_player.g_id = ".$row['g_id']. "
AND players.playerid = {$userid}";
$query = mysql_query($newquery) or die(mysql_error());
if($query['bool'] == 1) { $set_checked = " CHECKED";
}
else{ $set_checked = "";
}
echo "<input type=\"checkbox\" name=\"box1\" value=\"".$query['g_id']."\"" . $set_checked . "/>".$row['name']."<br />\n";
}

I'm trying to teach myself how to use functions and includes in my scripts.  As an exercise I am trying to create a registration system that I can re-use on other future projects.
I have my main register.php page as follows:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Register</title>
</head>
<body>

<?php
ini_set('display_errors', 1); 
ini_set('log_errors', 1); 
ini_set('error_log', dirname(__FILE__) . '/error_log.txt'); 
error_reporting(E_ALL);

// Check to see if query string is set, if not pass empty array to function.
if((!isset($_GET['success'])) && (!isset($_GET['active'])) && (!isset($_GET['valid'])))
{
include ('registerform.php');
$invalidcode = array();
regform($invalidcode);
} 

//If success is set, use value to determine response
if(isset($_GET['success']))
{
if($_GET['success'] == "false")
{
echo "There has been an error with your registration. You will be redirected to the registration page in 5 SECONDS.";
echo "<meta http-equiv=refresh content =\"5; URL=index.php\">";
}
if($_GET['success'] == "true")
{
echo "Thanks for registering. An activation email has been sent to your registered email address.<br />";
echo "Please check you email and follow the activation link contained within it.";
} 
}

//if active is set, determine response (note: code to be added here in future)
if(isset($_GET['active']))
{
if($_GET['active'] == "true")
{
echo "Thank you for activating this account.<br />";
echo "You may now return to the home page and login!";
}
}

//if valid is set there was a problem with the form validation.
//get valid from query string, convert back to an array and pass array to the form display script
if(isset($_GET['valid']))
{
$invalidcode = $_GET['valid'];
$invalidcode = unserialize(urldecode($invalidcode));
include ('registerform.php');
regform($invalidcode);
}

?>
</body>
</html>

When the page loads it first checks for any variables passed in the url to determine action.
Heres the code for the function regform():
<?php
function regform($errors)
{
//set variables to initial value to prevent undefined variable error
$errors0 = 0;
$errors1 = 0;
$errors2 = 0;
$errors3 = 0;
$errors4 = 0;
$errors5 = 0;
$errors6 = 0;
$errors7 = 0;

//check to make sure the array that was passed was not empty
//from my validation script the errors are in matching order to the display on this page.
//I have only prepared 2 errors for this inital testing, there will be one for each field on the form.
$i = count($errors);
if($i > 0){
$errors0 = $errors[0];
$errors1 = $errors[1];

//$errors2 = $errors[2];
//$errors3 = $errors[3];
//$errors4 = $errors[4];
//$errors5 = $errors[5];
//$errors6 = $errors[6];
//$errors7 = $errors[7];

}
echo "<form id='register' name='register' method='post' action='doreg.php' >";
echo "<table>";

//if the variable = 1 there was an error validating the field in the validate script

if($errors0 == 1){
echo "<tr><td><font color='red'>First Name</font></td><td><input type='text' name='firstname' /></td><tr>";
} else {
echo "<tr><td>First Name</td><td><input type='text' name='firstname' /></td><tr>";
}
if($errors1 == 1){
echo "<tr><td><font color='red'>Last Name</font></td><td><input type='text' name='lastname' /></td><tr>";
} else {
echo "<tr><td>Last Name</td><td><input type='text' name='lastname' /></td><tr>";
}

//additional errors to be added, as per abov,e for the code below

echo "<tr><td>Email Address</td><td><input type='text' name='email' /></td><tr>";
echo "<tr><td>Password</td><td><input type='password' name='password1' /></td><tr>";
echo "<tr><td>Confirm Password</td><td><input type='password' name='password2' /></td><tr>";
echo "<tr><td></td><td></td><tr>";
echo "<tr><td>Accept Terms?</td><td><input type='checkbox' name='accept' /></td><tr>";
echo "<tr><td>Security String</td><td><input type='text' name='secstring' /></td><tr>";
echo "<tr><td></td><td><input type='submit' name='submit' value='submit' /></td><tr>";
echo "<tr><td></td><td><input type='hidden' name='form_submit' value='1' /></td><tr>";
echo "</table>";
echo "</form>";
}
?>

So the form takes the array ?valid passed to the register page and determines which fields had a validation error and highlights them red. (I'll modify this highlighting to be what ever I need later...just testing my logic )

The form then calls doreg.php on submit.
This will firstly run the validate script, then perform DB actions if all ok, else it will return to register with the error array passed in a query string:

<?php
if($_POST['form_submit'] == 1)
{
include ('validate.php');

//the validate script returns $errorarray. Need to figure out better way to test values to determine if any error flags are set

if(($errorarray[0]!=0) or ($errorarray[1]!=0) or ($errorarray[2]!=0))
{
$errorarray = urlencode(serialize($errorarray));
echo "<meta http-equiv=refresh content=\"0; URL=register.php?valid=$errorarray\">" ;
} 

echo "<meta http-equiv=refresh content=\"0; URL=register.php?success=true\">"; 
}

?>
php]
And finally there is the actual validation script. I was hoping to be able to use this for all form validations across the site. I'll just add if(isset) for the various form fields and make sure I standardize my field names across my sites forms.
[php]
<?php
$errorarray = array();

if($_POST['firstname'] == "") {
$errorarray[0] = 1; 
} else {$errorarray[0] = 0; }

if($_POST['lastname'] == "") {
$errorarray[1] = 1; 
} else {$errorarray[1] = 0; }

if($_POST['email'] == "") {
$errorarray[2] = 1; 
} else {$errorarray[2] = 0; }



return $errorarray;
?>

For this example I have just done simple empty string checks.


I'd really appreciate any advice on the code I've written to date. Im quite sure there are more elegant ways to achieve what these scripts do and I would greatfully accept any feedback. (Be gentle...I'm new )

Thanks

Hi I was curious as to if you guys could possibly point me in the right direction so I can learn what is needed in order to implement a system on my website that allows users to login and then I could make only certain users have access to certain pages and etc, I don't have any mysql knowledge at all and I'm pretty sure I'm going to need to know that so if anyone could point me in the right direction and put me on on the right track to learning this or a guide I could go off of and see how everything works, I appreciate it.

Thanks!

CLUEL3SS