Updating an image

[sumithar]

I have a php application which has a page where some personal details
can be updated. One of the details is a photo.
The backend is mysql.

My question has to do with how best to code for this. Since the image
is not changed often, do I have 2 mysql update statements in the code?

Something like this

$var1 = $_FILES['photo']['name'];

if ($var1)
{ sql update statement that includes the photo column as
well}
else
{sql update statement that doesn't include the photo column}

Is there another approach to accomplish this?

[sheldonlg]

sumithar wrote:

I have a php application which has a page where some personal details
can be updated. One of the details is a photo.
The backend is mysql.

My question has to do with how best to code for this. Since the image
is not changed often, do I have 2 mysql update statements in the code?

Something like this

$var1 = $_FILES['photo']['name'];

if ($var1)
{ sql update statement that includes the photo column as
well}
else
{sql update statement that doesn't include the photo column}

Is there another approach to accomplish this?

Yes and no. Yes, that is one way. No, since this is for an existing
entry (you are using UPDATE), you obviously have already done a select
to get the existing properties. Pull in the photo location with that
call and put its value in some variable. If you do a new upload of a
photo to replace it, then change that variable's value. Then all you
have to do is do the update with that variable's value.

[Captain Paralytic]

On 11 Jun, 15:25, sumithar <[e-mail]:

I have a php application which has a page where some personal details
can be updated. *One of the details is a photo.
The backend is mysql.

My question has to do with how best to code for this. *Since the image
is not changed often, do I have 2 mysql update statements in the code?

Something like this

*$var1 = $_FILES['photo']['name'];

*if ($var1)
* * * * * { *sql update statement that includes the photo column as
well}
*else
* * * * * {sql update statement that doesn't include the photo column}

Is there another approach to accomplish this?

I tend to code using the INSERT INTO ... SET ... ON DUPLICATE KEY
UPDATE ...
syntax (of MySQL). Where I actually store the contents of a file in
the database (in a BLOB field), in response to a possible file upload,
my code only includes the LOAD_FILE(contents) part of the statement,
if I actually have that to insert. Since I am building the query
dynamically, it is up to me whether or not it includes that part of
the statement. This is true for any database SQL syntax. If you build
the query dynamically you get to choose what goes in it.

[Jerry Stuckle]

sumithar wrote:

I have a php application which has a page where some personal details
can be updated. One of the details is a photo.
The backend is mysql.

My question has to do with how best to code for this. Since the image
is not changed often, do I have 2 mysql update statements in the code?

Something like this

$var1 = $_FILES['photo']['name'];

if ($var1)
{ sql update statement that includes the photo column as
well}
else
{sql update statement that doesn't include the photo column}

Is there another approach to accomplish this?

Maybe. So you already have the photo filename, i.e. from a previous
SELECT statement? If so, you can just insert it as the default value,
then if they upload a new photo, replace the default value with the new
one. Then go ahead and update the database. It won't hurt to update a
a column with the same data which was already there (in fact, MySQL will
ignore a such a change for that column).

If you don't already have the photo filename, then go ahead and use a
second UPDATE statement. It will be better than having to fetch just
the photo filename so you can (not) change it.

Or, create an object for the table which does this for you :-)

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[The Natural Philosopher]

sumithar wrote:

I have a php application which has a page where some personal details
can be updated. One of the details is a photo.
The backend is mysql.

My question has to do with how best to code for this. Since the image
is not changed often, do I have 2 mysql update statements in the code?

Something like this

$var1 = $_FILES['photo']['name'];

if ($var1)
{ sql update statement that includes the photo column as
well}
else
{sql update statement that doesn't include the photo column}

Is there another approach to accomplish this?

I update images entirely sperately, depending on whether the $_FILES
array has anything in it.

Its easy enough to check

[sumithar]

On Jun 11, 2:33*pm, The Natural Philosopher <[e-mail]:

sumithar wrote:

I have a php application which has a page where some personal details
can be updated. *One of the details is a photo.
The backend is mysql.

My question has to do with how best to code for this. *Since the image
is not changed often, do I have 2 mysql update statements in the code?

Something like this

*$var1 = $_FILES['photo']['name'];

*if ($var1)
* * * * * { *sql update statement that includes the photo column as
well}
*else
* * * * * {sql update statement that doesn't include the photocolumn}

Is there another approach to accomplish this?

I update images entirely sperately, depending on whether the $_FILES
array has anything in it.

Its easy enough to check

Thanks all!

Actually in my initial SELECT to display the values on the form, I
don't include the photo column. I have a separate database call for
that like so:
<img src="dispphoto.php?id="<?php echo $player_id; ?>"" width="80"
height="60">

And dispphoto.php just SELECTs the photo column from the table and
"echo"es it.

Captain- sorry you lost me completely. Dynamic SQL was taboo in the
world I come from ;-)

Jerry- I have just a nodding acquaintance w/ OO-PHP. Are you
suggesting the use of some Object-Relational mapper tool? My java
developer friends use something called Hibernate. Is that what you
are talking about?

Doing the update of image alone as a separate statement looks a good
option based on whether the $_FILES has a value in it. Better than 2
long update statements. Though it will be one DB call extra but this
is a low volume environment.

[Jerry Stuckle]

sumithar wrote:

On Jun 11, 2:33 pm, The Natural Philosopher <[e-mail]:

>sumithar wrote:

>>I have a php application which has a page where some personal details
can be updated. One of the details is a photo.
The backend is mysql.
My question has to do with how best to code for this. Since the image
is not changed often, do I have 2 mysql update statements in the code?
Something like this
$var1 = $_FILES['photo']['name'];
if ($var1)
{ sql update statement that includes the photo column as
well}
else
{sql update statement that doesn't include the photo column}
Is there another approach to accomplish this?

I update images entirely sperately, depending on whether the $_FILES
array has anything in it.

Its easy enough to check

Thanks all!

Actually in my initial SELECT to display the values on the form, I
don't include the photo column. I have a separate database call for
that like so:
<img src="dispphoto.php?id="<?php echo $player_id; ?>"" width="80"
height="60">

And dispphoto.php just SELECTs the photo column from the table and
"echo"es it.

Captain- sorry you lost me completely. Dynamic SQL was taboo in the
world I come from ;-)

Jerry- I have just a nodding acquaintance w/ OO-PHP. Are you
suggesting the use of some Object-Relational mapper tool? My java
developer friends use something called Hibernate. Is that what you
are talking about?

Doing the update of image alone as a separate statement looks a good
option based on whether the $_FILES has a value in it. Better than 2
long update statements. Though it will be one DB call extra but this
is a low volume environment.

Nor familiar with Hibernate. You should learn about OO programming.
There are a number of books out there.

Remember - OO is a design methodology - and is, as such, relatively
language independent (as long as you have a language which supports OO).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================