PHP :: Date Increment

Auto Increment By More Than 1
I have a table that I want to automatically generate an account number. I previously developed a simple database using appleworks that allows one to enter the amount she needs to add to the ID field with each new record. MySQL does not allow for this so I figure I must add it to the PHP script. PHP Code:

What Will The Next Auto Increment Be?
I have a MYSQL table with a field that auto increments 'ID'. I need to know what the next ID will be. Is there a simple way to do this?

One solution I've thought of is to query all the records and sort it by ID, and then just take the last record +1. But that seems awfully inefficient. Does anybody have any other suggestions or know of any functions that will do this?

UPDATE And Increment By 10
i want to update each field in a database table and increment by 10.

so it will look like

10, 20, 30, 40, 50

Increment (++) Question
I'm using the following code

<?php
header("Cache-Control: no-cache, must-revalidate");
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
error_reporting(0);
$incrementfilename = $_GET['textfilename'];
$handle = fopen($incrementfilename, 'w');
$incrementcontents = file_get_contents($incrementfilename);
$incrementcontents = $incrementcontents + 1;
fwrite($handle,$incrementcontents);
fclose($handle);
chmod($incrementfilename,0777);
?>

Auto Increment
how when you have an auto-incremented mysql list? And you know how when you delete an entry, the entry's auto-increment value just gets dropped and skipped? What I need to know is if there is a way to sort of re-number the list, preferably using a Query, such as an ALTER command or something. Code:

Increment Number
How do I create a link, that when clicked, increments a number value stored in a database?

Increment Numbers
i use a java scrip to expand content from a rss feed. It doesn't work because when all feed are showing, all javascrit have the same ID and each ID shoud be unique,
can i create with php or javascritp a new ID for each java script created in this php loop with my result? Like increment by one for each result?

I can add php into result because it's not inside javascript. like:

maintab1
maintab2
maintab3

But each element are not in the same php bloc code.

Getting Last Id Of The Auto-increment Key
I have two tables and I need to get the last id of the primary key in one of the tables. I did some searching and found a solution that works.

$sql=mysql_query("INSERT INTO (table) (column) VALUES ('test')") or die (mysql_error());
$insert_id=mysql_insert_id();
$num = $insert_id + 1; //need to increase the last id by one to match new entry in other table

This works well. The downside is in order for this to work an actual value is filed into a new row of (table) after the last id found in (column) thus giving me a blank row. While this isn't too bad, I could imagine I'll end up with a bunch of empty rows in my table. Is there a way to prevent this from happening -- i.e., a bunch of empty rows?

Getting An Auto-increment Id?
When someone creates a topic, the following is executed:

$sql = mysql_query("INSERT INTO `reflexproj`.`topics` (`topic_name`, `topic_desc`, `poster`, `forumid`) VALUES ('". $posttitle ."', '". $desc ."', '". $sessionu ."', '". $forum ."');");

This inserts the topic into the topic table. However, then this is executed:

$sql = mysql_query("INSERT INTO `reflexproj`.`posts` (`poster`, `post`, `topicid`) VALUES ('". $sessionu ."', '". $fp ."' '". $id ."');");

This is meant to insert a post into the posts table that starts the topic. However, this is a problem. The problem is, that $id hasn't been defined.

My question is this, really: How do I get $id? Basically, I've got to find a way of getting an auto_increment value from a database. Anyone any ideas?

Get Last Auto-increment Number
I am inserting related data into 2 tables. The first table I insert into has an auto-incremented field. The second table i insert into has a field which needs to hold the same number as the number in the auto-increment field from the first table. I cannot auto-increment the field in the second table because the number will occur more than once in the second table.

How can I retrieve this auto-incremented number from the first table?

Auto-increment Field
I have query which returns the value of a auto-increment field last entered. That is:

$sqlquery = "SELECT MAX(field-id) from table";
$result = mysql_query($sqlquery);

The query itself seams to work fine alone, but when I run it in a php script and try to print $result it returns "Resource id #6" . No idea what this is or where it came from.

Auto-Increment And Deleting
When i delete a record from my MySQL database it works fine, but then when i reload the form to Insert another record, it sticks the record into the database but at the position where i deleted the record. Can someone show me a way of keeping the autoincrement at the last record in the database even after i delete a record?

How To Increment Variables In Smarty
how to increment variables in smarty

{assign var="i" value=$i|default:0} {if $i lt 3} {$i|assign:$i+1} {/if} if $i is lessthan 3, i want to increment $i . it is possible or not ...

MySQL Auto Increment
I have a site that is about to go into production
and it has a couple of tables that it uses that
could get quite large once in full swing, most of
them have a column called "id" and it auto
increments every time a new row is added. When
setting this up, what do you recommend using at
the column type and size. atm I have gone for a
big-int with the size of 20. I wonder over time
will 20 be enough... Should I just think of a big
number and use it?

Anyone else in this situation and what would you do?

PHP / MySQL - Auto Increment Id
I just did my first PHP/MySQL database (a simple survey) that works
fine. It is ordered by an id field that auto increments. Apparently, one
entry repeated (I'm thinking the user hit the submit button twice). So,
I deleted a record. My question is, how do I make it so the next entry
will use the id# that I deleted, so there won't be a gap in the id numbers?

Increment Counter Via GET-Request?
this is my situation:

I have a counter on my MAIN page. It is incremented by requesting a certain
"picture" which is the output of a script. I can do this manually with:

http://www.mydomain.com/script.php?id=123456&vid=987654

This increments the counter.

This is my wish:

I have another page with a discussion board. The address is something like
http://board.mydomain.com. Now I want to add these hits to those of the
counter.

My idea is to write a script which does something like:

<?php
send GET-request to increment the counter (invisible for the user);
redirect to the board;
?>

Is this possible? How do I do this?

Resetting Auto Increment
I have a table in MYSQL which has a row which is set to auto increment. Because I've been testing my system out so much the id is at around 100 or something.

I tried deleting everything from the table but then when I make a new news story the id carries on from where it left off, how can I make it start again from 1?

MySQL Auto-increment
When using an "INSERT INTO" statement, what should I put as the value for an auto incrementing cell?

ex: "INSERT INTO content VALUES (' [auto-incrementing field] ', '$content')";

Would I just leave it empty?

Auto Increment Updating...
I have a database with a table 'pages' in it. Inside pages is the row 'ID_MAIN'. It's got 5 entries in it with values of 1 to 5. I want to create a new entry in between entry 2 and 3 with a value of 3, there by updating 3 to 4 and so on.

This is the script I came up with, however I'm completely new with this and... well it didn't work. And info as to how to correct this would be greatly welcomed. Code:

Increment A Text Field In A Form
I am creating an intranet which shows active projects and allows people to add new projects. If users want to add a new project, they fill in a form but what I want the form to display in the ProjectNumber field (which is a var char field & not the primarykey) is the last Job Number incremented by 1.

For example if the last ProjectNumber was TS0014, then the default value in the ProjectNumber field should be TS0015 - this way users know what the next job number is.
At present, the last job number in my table is TS0014. Below is the code i'm using but for some reason in the Job Number field in the form Im getting TS001? WHY? Code:

Keep A Accurate Auto Increment In MYSQL
i'm wondering how to keep a accurate auto increment in MYSQL. For example say I had an ID field "INT" thats auto increment and I have 5 rows:

|ID 1| Row 1
|ID 2| Row 2
|ID 3| Row 3
|ID 4| Row 4
|ID 5| Row 5

Now say I delete "Row 4":

|ID 1| Row 1
|ID 2| Row 2
|ID 3| Row 3
|ID 5| Row 4

So my question is how do I keep the ID# with the corresponding row#? Is it possible to do this, and how so? If not is their another way to accomplish this?

Phpbb Auto Increment Question?
Is anyone familiar with the way phpbb works in terms of adding a new user to the database. If i am right it doesnt seem to auto increment?

When a new user registers fir my site, I also have an sql insert into the phpbb_user table too so they can then logon to the forum.

But the id seems to go in as just 0 and wont increment! Is there any reason for this?

Session Variable Increment Problem
session_start();
$_SESSION['visits']++;
print 'You have visited here '.$_SESSION['visits'].' times.'

why the visit variable is not incremented the next time i enter.

Notice: Undefined index: visits in C:Program FilesApache
GroupApache2htdocssessioncookie2.php on line 3
You have visited here 1 times.

Grabbing An Auto Increment Number??
I am entering information in to a database. Everything enters 100% fine, the first column is an auto_increment id number. What I want to do is enter information in to another table, but I need to use that id number that is generated in one of the columns. (and it has to be pretty much instant with the first one, its for a register form) Is this possible? If so, how would I do it?

Auto Increment + Deleting A User
On my User table, occasionally, I will have to delete a member. ID is set to auto_increment, so, each time information is imported, that number will increase by one...

However. There is one issue. When I delete a row from the table (so, I deleted a user), that ID becomes unavailable for use. So, there is three members. I delete the third one. When another user registers, I want them to have the ID that was deleted beforehand, which would be three. However, the user will have four.

Session Counter Won't Increment But Registered Fine?
I eagerly started the devshed tutorial on sessions and discovered I cannot get the simple counter script to work. I have read a bunch of other posts and I am still not exactly sure why things aren't working. I have the session directory set in php.ini, I have cookies enabled in my browser.

Here are two files which I have changed around in various ways, paying attention to putting the session_register in different spots.

PHP/mySQL Insert Into Statement With Auto Increment
When i use mysql from the linux command line it is just plain simple to add an row into a table, even with php this isn't a problem. But when the table has aan field with auto_increment php won't allow to insert a new row in the table. I'll get an invalid query back.. In don't understand how to insert a new row into a table with the auto increment. Btw this is also the primary key: Code:

Printing Mysql Auto-increment Key Value On A Form
i need to print off the auto increment key value on a form. How does the syntax go to accompish this. Field name is rrn. Output only.

Increment A Counter In MySQL Every Time A Picture Is Viewed.
I have a picture heavy website that works from a MySQL database, pages are created on the fly as a thumbnail picture is clicked on.

Is there any way to increment a MySQL counter every time the thumbnail picture is clicked on, therefore giving an individual hit count for each large picture and it's automatically created page? If there is a way of doing this can someone please point me in the right direction with regards to coding this?

Inserting Data Into A Table With Auto Increment In One Field
i have a table with several fileds in and with the first one being an auto increment field. I want to know what my SQL query should be when inserting data. Here's my current one: Code:

$SQL = mysql_query("INSERT INTO $usertable2 VALUES('$subject', '$newstext', '$date', '$usrname')";

The auto increment field is the first in the table and is called 'postid'. can someone give me the correct query please? also do i need the first entry in the table to be a blank one with just the postid entered at one?

Retrieve MySQL Row's Auto-increment In Query
I've only been working with PHP and MySQL for about the last month and half and have done fairly well but have run into a problem that I hope has an answer.

I'm working on a simple, small animation showcase site where people I know (animators) can post their animations/movies. Visitors can then "tag" their movies with descriptive words.

If I submit a form to insert the mysql row that has an auto-incrementing ID # on it into a table, is there a way to retrieve that ID immediately and use it in that same query to insert the ID # into another table (which I use to cross-reference the table that contains all of my movies's info and the table that contains the information I want to be able to relate to that user)?

SO, more plainly I want to:
- Retrieve from a form/page the movieID and tag
- Insert "tag" into "tags" table of my database, which automatically assigns each tag row an ID
- Pull the tagID for the tag row that was just created from the tags table <- Where I need the help
- Insert the tagID and movieID into a crossref table

Check Date From Input Must Greater Or Equal Today Date?
I have 3 select box. Code:

<select name="day">
<option value="1">1</option>
<option value="2">2</option>
.......
<option value="31">31</option>
</select>

<select name="month">
<option value="01"> Jan </option>
<option value="02"> Feb </option>
.....
</select>

<select name="year">
<option value="2002">2002 </option>
<option value="2003">2003</option>
</select>

When I select and click submit in form. I will have 3 variable :

$day, $month and $year

How can I check the day that I choose in form must equal or greater than today date? If it less than today date. I must print error message to user.

Date Is Not Being Pulled From MYSQL Database, Instead Current Date Is Displayed!
I am having trouble pulling a date from a database using PHP at the <a
href="http://www.mytuneslive.com/ameshkin69/"> following page.</a>

Here is the code. As you can see, it is just making the date the
current time. The values in the database are UNIX timestamp, and the
DATE() function is used to convert from UNIX to readable date. Can

<td width="55%" align="left" valign="top"><?php
$row_comment['timestamp'] = date("n d Y g:i A");.....

Read Today's Date Print Tomorrow's Date
I've got a small script that writes a random number and the date to a text file. Then the script opens this text file and if date = date from this text file something must happen.
If something happened this script must open this text file again and replace it with a new random number and tomorrow's date.

<?php

$date = date("d-m-Y");
mt_srand((double)microtime()*10000000000);
$num=mt_rand(0, 20);
if ($num == $num && $date == "$tomorrowdate") { echo"$num -- $date";}
else
echo " ";?>

So if the script gets activated on the 05-05-2003 it must write tomorrow's date into the text file (06-05-2003). How will I get tomorrow's date today?

Help: Date Function Not Returning Correct Date & Time
I have just notices that the date() function is not returning the correct
date/time on my "server".

I am running apache2 on my winxp pro laptop.

My system clock is set to the correct date, time and timezone, get the
results returned by date() are 11 hours behind.

PHP Date Question: How To Determine The Date Each Of The Past 3 Sundays
How can I determine what the date was (in YYYY-MM-DD format) last
Sunday, and the Sunday before that?

For example:

Today is Thursday, August 18, 2004 (2004-08-18). I would like to have
the following variables:

$this_past_sunday = 2004-08-14
$two_sundays_ago = 2004-08-07
$three_sundays_ago = 2004-07-31

etc. etc.

Save Date To Table Field Date Type
I have a calendar picker on a form that fills a text box with XX/XX/XXXX date format. If I run a insert statement the date field in the database shows 0000-00-00. If i change the field type to varchar the correct format displays.

What is the correct way to save a date to a mysql database? Furthermore to query on the date how about a select * from db_name where servicedate >= $startdate and servicedate >= $enddate I supose this will not work
Any pointers?

Date Dropdown From Mysql Date Entries
For the PHP gurus out there, here is what I want to do: create a dropdown list of available dates from a mysql database date entries. But the dropdown/s should have 3 separate fields in month, day and year which in effect shows only those months, days and years that have corresponding entries from the database.

Planning to use this in the archive section of an online news publication so people can select issues to view via dropdown list that have corresponding entries only.

Start Date - End Date = Number Of Days
I have a starting date for var 1 and today’s date for var 2. I need to calculate how many days are between those two dates.

02/24/03(today) - 01/14/2002(start date) = number of days.

In theory this is easy but there are many instances were I could get an inaccurate answer. For example one consideration is that some months have 30 days others have 31. exc.

My question is, is there an easier way to solve this problem other than using endless if statments to error handle all possible instances? Does PHP4 have any built in functions that could calculate this formula correctly?

UNIX Mktime To MySQL Date Or Date
A form that sends a starting date and an ending date. I have figured out how to tell the difference between the two and even rip the difference into an array because I need to compare the individual dates against a mySQL database to pull results from a particular date in a series. This is no problem. My problem is that teh mySQL database uses DATE as a field definition and this can not be changed. I managed to pull the date differences using some cleaver mktime stuff but no I do not know how to get this 1072242000 into this 2003-12-24...

Is there a function that reverses the mktime result into a usable date format? I would take anything at this point and I can explode and then array it to get what I want - but there has to be something. Code:

Formatting Date From MYSQL Date Field
i've got a date field in my table, but the default format is YYYY-MM-DD... is there any way i can pull the date out of the database and format it differently... like DD.MM.YYYY or like April 13, 2003?

Counting Days From $date To Current Date
how to count the time between two variable dates? Such as someone inputting 6/8/1991 in a form and it comparing that to todays date... then getting the number of seconds elapsed... I know I have to use the mktime() function to get the seconds.. but not quite sure how.

The Server Date Cant Match With My Country Date.
which using Date()
the server date/time can not match with my country date/time
eg server time: 1.30pm ..but my localtime already 3.3pm

Date() Gives Me Yesterday's Date And Not Today's - Why?
$result[$i]->record_entered contains the current date as set up by
MySQL (entered as "now()").

I verified that in the database the date is "now()", which in this case
will be "2/9/2006".

However, when viewing the page using the display:

Code: ( php )

Begin Date And End Date, But No Weekends!
I am making a system to plan my work days.
If i begin on a project on 01-10-2007, and the project is 100 hour and i work 10 hours a day, it will cost 10 days for me too work.

The answer is simple, project is done @ 10-10-2007, but i dont work in the weekend.
So it must be 12-10-2007, i got the following script;, but it aint working right.

Because when the begin date and end date is more then 2 weeks, and more than 2 weekends, it doenst count the weekends good. Can someone help me, or is there somebody with a better solution? I am working two days on it, but i cant get it right

<?php

$begin_date = strtotime( date( '2007-10-01' ) );

$hours = 100;
$workdays = 10;

$total_days = $hours / $workdays;
$total_days *= (60 * 60 * 24);

$weekend = $total_days / 7 * 2;

$enddate = $begin_date + $total_days + $weekend;

if( date('D', $enddate ) == 'Sat' ) {
echo 'End date <b>' . date('d-m-Y', $enddate + (2*86400)) . '</b> 2 days<br /><br />';
}

elseif( date('D', $enddate ) == 'Sun' ) {
echo 'End date <b>' . date('d-m-Y', $enddate + (1*86400)) . '</b> 1 day<br /><br />';
}

else
{
echo 'End date <b>' . date('d-m-Y', $enddate) . '</b><br /><br />';
}

?>

Date Conversions ( Date, Mktime )
I have a date in three pieces dd mm yyyy.
I'm just wondering the best way to convert this for inserting into a
DATETIME field and then back again when displaying it.

I have tried date, strtotime mktime but it keeps inserting a blank
date. i.e. 00:00:00 00:00...

I've been looking through the php manual but I can't seem to get this
working.
Also would I be better off using the UNIX_TIMESTAMP function?

Date Increment

I have a value stored in variable $date and want to increment this date by one day, something like: $date = $date + 1; I cannot find a date increment function in the PHP help file. I thought that this would be quite a commonly used function but maybe I am looking in the wrong place.

I have a value stored in variable $date and want to increment this date by one day, something like:

$date = $date + 1;

I cannot find a date increment function in the PHP help file. I thought that this would be quite a commonly used function but maybe I am looking in the wrong place.