[PHP] date formatting

[Mike Ryan]

I would like to have my users input the date formate as mm-dd- mysql
wants the data to come down as -mm-dd.

The question I have is how do I convert from the mm-dd- to -mm-dd so
that I can write it out to the database?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] keeping fields moving forward

[Mike Ryan]

I am creating a series of forms that collect information this covers 3
screens before I want to write it out to the database.  when I go from one
screen to the next I have tried hidden and readonly input boxes but the data
in the hidden and readonly fields from screen one do not make it to the
final page.

Is there a way to get the data from page one without letting the users
modify the information.  I guess I could write the data to the database but
how do I find the record number of the data I just wrote so that I can
update the information, will php tell me the record number? I am using php
5.2.1 and mysql 5.x

thanks for your help.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] keeping fields moving forward

[Mike Ryan]

Jim Lucas [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 Mike Ryan wrote:
  I am creating a series of forms that collect information this covers 3
  screens before I want to write it out to the database.  when I go from
one
  screen to the next I have tried hidden and readonly input boxes but the
data
  in the hidden and readonly fields from screen one do not make it to the
  final page.
 
  Is there a way to get the data from page one without letting the users
  modify the information.  I guess I could write the data to the database
but
  how do I find the record number of the data I just wrote so that I can
  update the information, will php tell me the record number? I am using
php
  5.2.1 and mysql 5.x
 
  thanks for your help.
 
 
 Are working with the data from Form 1 before going to form 2 and so forth?

 If you are not, then you could look into a three layered div with tabs and
keep it all on one page.

 -- 
 Jim Lucas

 Some men are born to greatness, some achieve greatness,
 and some have greatness thrust upon them.

 Twelfth Night, Act II, Scene V
  by William Shakespeare

yes I get information from form one transfers to form two ok but then does
not show up on form 3. form 1 and 2 do not then save to the database after
the last page of form 3.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: keeping fields moving forward

[Mike Ryan]

I think I have it fixed  I had some code wrong in my input hidden variable
this worked and did the job for me

I am an old time type of programmer who is not very good with the object
oriented programming and have not taken the time to learn some new tricks.
one day I will.



Mike Ryan [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 I am creating a series of forms that collect information this covers 3
 screens before I want to write it out to the database.  when I go from one
 screen to the next I have tried hidden and readonly input boxes but the
data
 in the hidden and readonly fields from screen one do not make it to the
 final page.

 Is there a way to get the data from page one without letting the users
 modify the information.  I guess I could write the data to the database
but
 how do I find the record number of the data I just wrote so that I can
 update the information, will php tell me the record number? I am using php
 5.2.1 and mysql 5.x

 thanks for your help.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] working with a pdf file and a mysql query

[Mike Ryan]

I have created a pdf form with php that prints out one record using
php_show_xy statements but when I try to print out a query with multiple
lines of data I get an error that reads

Fatal error: Uncaught exception 'PDFlibException' with message 'Function
must not be called in 'object' scope' in C:\xampp\htdocs\payment\html\php
code\dayrpt.php:60 Stack trace: #0 C:\xampp\htdocs\payment\html\php
code\dayrpt.php(60): pdf_show_xy() #1 {main} thrown in
C:\xampp\htdocs\payment\html\php code\dayrpt.php on line 60


This is the code I am trying, it works with just 1 item to return but not
with 2 or more items, to use any suggestions would be helpful.

$linenum = '600';
 while ($row = mysql_fetch_assoc($result)) {
  PDF_show_xy($pdf, $row['patname'] ,80,$linenum);
  PDF_show_xy($pdf, $row['pmtdate'] , 225, $linenum);
  PDF_show_xy($pdf, $row['checkamt'], 300,$linenum);
  PDF_show_xy($pdf, $row['cashamt'], 375,$linenum);
  Pdf_show_xy($pdf, $row['ccamt'], 450, $linenum);
  $total = $row['checkamt'] + $row['cashamt'] + $row['ccamt'];
  PDF_show_xy($pdf, $total,525,$linenum);
  $linenum = $linenum - '10';
}

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] pdf and send to printer question

[Mike Ryan]

I am trying to get a query to run and outputed to a pdf file I get the
following error

Fatal error: Call to undefined function pdf_begin_document()

in my php.ini I have php_cpdf.dll and php_pdf.dll enabled am I missing
something.?

also is there a way to send the document I create to the printer instead of
the screen?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] problems in WHERE statment

[Mike Ryan]

I am a newbie so please bear with me.

I get this error message when I try to run a query

Connected successfullyCould not successfully run query () from DB: Unknown
column '$today' in 'where clause'

this is the query command
 $query = 'SELECT *
FROM `job listing`
WHERE open =$today
LIMIT 0 , 30 ';

I have assigned $today this way $today=date(Y-m-d);

Can you tell me what I did wrong??

thanks for your help.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] format date field

[Mike Ryan]

I am reading in a date field from a mysql database the field on the screen
shows up as 2007-05-01  on the screen I would like the field to show
05-01-2007  currently I am issueing the following command  print
$row['open']; how can I format this field???

while I am at it how can I accept the date field as 05-01-2007;

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] date format from a database date field

[Mike Ryan]

Sorry I am a bit of a newbie with php and hope this has not been aswered a
million times, but here it goes

I have a date base with a couple of date fields when I pull up and display
the fields it show 2007-05-21. the question I have is how to convert the
field to 05-21-2007?

Currently the command I have is

print $row['open'];

any help would be apreciative.

thanks

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php