php-windows Digest 6 Apr 2003 12:29:43 -0000 Issue 1670
Topics (messages 19320 through 19323):
Re: PHP MySQL question
19320 by: H Marc Bower
Re: PHP with PDFlib installation on Windows
19321 by: Francesco Pondrano
display errors using iniset
19322 by: Elja
Re: Subject: PHP MySQL question
19323 by: Neil Smith
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
Using an UPDATE statement in mysql you can make any number of changes to the
record at one time. What I've done in the past is read in all the fields
from a record, on the webpage displayed the fields that are editable, then
sent all of the variables back through as an update. You'll need to read
the record first (obviously), then any fields that aren't going to be
modifiable you can either leave out or add them in as hidden form elements.
You can put the data from the fields that you read in as the default data in
the form fields for the user to modify. When the Submit button is clicked,
then you initiate the update statement (you can find out the full syntax in
the mysql manual) - or run it through a data verification page first,
however you are taking in the data - that includes all of the modifiable
fields, even if some of them weren't changed.
(V)
----- Original Message -----
From: "ODCS" <[EMAIL PROTECTED]>
To: "PHP Windows" <[EMAIL PROTECTED]>
Sent: Saturday, April 05, 2003 6:41 PM
Subject: [PHP-WIN] PHP MySQL question
> I have a database of user inputted information and need to create a page
> where the user can update their information. The user will log in using
> their name and password and then be forwarded to a form with all the
fields
> they can update - but what is the best way to write the records to the
> database. Lets say the user wants to update 3 out of ten fields - would I
> have to write a query for each field and write them one by one, or is
there
> a better way to do this. Any thoughts on this are appreciated.
>
> B.
--- End Message ---
--- Begin Message ---
Well,
PDFlib is normally included in the PHP distribution for Windows.
You can check if it's properly configured with phpinfo(), just scroll down
until you see the table "PDF support"...
I also had throubles at the beginning, you should check your script for
correct
use of the pdf functions. You should also check the version of PDFlib
working on your server because latest versions of PDFlib have different
functions.
On phpbuilder.com you can find a useful template and further information
can be seeked on pdflib.com
I hope this could be useful to you.
Francesco
P.S.
Please note that I'm using PHP 4.2.0 on Windows Xp Professional using
Apache as web server.
On Thu, 3 Apr 2003 12:42:36 -0700, Bill Hudspeth <[EMAIL PROTECTED]> wrote:
Hello,
I am having problems getting the PDF extension to work with PHP on
Windows.
I am running PHP 4.2.3 on Windows NT 4.0 using IIS as my internet server.
I
have enabled the PDF extension in the php.ini file, with no apparent
success. When I try to load the page, I get an empty screen (i.e., no
error
messages or undefined functions). It was my understanding that the
Windows
module version of PHP had PDFLib libraries already built in. What might
be
my problem?
Thanks, Bill
--- End Message ---
--- Begin Message ---
Hi,
I want to set up my php.ini with the display_errors setting off, and put in
my script
a iniset('display_errors',"1"); so i will only see errors of the script
that i'am working on.
I can't get it to work. It seems (when i call phpinfo() after the iniset)
that i changed the local
value but i don't see any errormessages.
When i adjust the setting in the php.ini file it will show the error
(ofcourse).
Does anybody know what i'am doing wrong?
(got a apache and php 4.3.1)
Elja
--- End Message ---
--- Begin Message ---
Surely it would be easier to just write one query which updates the whole
entry, regardless of which items have changed ? Might cost a few more
electrons, but hey, saves making work for yourself :-)
Just make sure to populate your form with the existing data then submit the
lot as if it was a new entry (but send the entry ID so you can do the
update). Sorry can't be more specific, but your question was rather wooly.
Cheers,
Neil Smith
At 23:49 05/04/2003 +0000, you wrote:
Message-ID: <[EMAIL PROTECTED]>
From: "ODCS" <[EMAIL PROTECTED]>
To: "PHP Windows" <[EMAIL PROTECTED]>
Date: Sat, 5 Apr 2003 18:41:57 -0500
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Subject: PHP MySQL question
I have a database of user inputted information and need to create a page
where the user can update their information. The user will log in using
their name and password and then be forwarded to a form with all the fields
they can update - but what is the best way to write the records to the
database. Lets say the user wants to update 3 out of ten fields - would I
have to write a query for each field and write them one by one, or is there
a better way to do this. Any thoughts on this are appreciated.
--- End Message ---
