[RESOLVED] 2 things: email notify / prefix upload

moonbrat

Hi,

I've got a question...two actually:

Does anyone know where I can find a tutorial on how to send an email notification to admin when a new user joins/updates a member site? I can't seem to find one and I'm pretty new at email notify on sign up and update.
Also, if there's about 1 to 30 people in the database how do I email all members in the db?
How can I upload an image to a folder via a form, put the filename (only) into the db but AFTER it's prefixed with a number then stores it in the folder.

e.g.

image.gif => submit => 1_image.gif (fileNAME only in db) => 1_image.gif => /images/ (folder)

Because I'd like user1 to have 1 prefixed to their image, user2 to have 2 prefixed to their image and so on...

So, when it's echoed onto my website instead of writing out 1_image.gif etc. all I have to is write a php code that's generic to use on all users...so there's no altering the code individually.

bogu

moonbrat wrote:
1. Does anyone know where I can find a tutorial on how to send an email notification to admin when a new user joins/updates a member site? I can't seem to find one and I'm pretty new at email notify on sign up and update.

Where a user register to your site, u make an insert in DB tables, if the insert is success this means the user register successfully and u send an email to the admin that a new user has register... [[man]mail[/man]]

moonbrat wrote:
Also, if there's about 1 to 30 people in the database how do I email all members in the db?

U extract all the email emails from your DB and while u parse them, send them an email ...

moonbrat wrote:
2. How can I upload an image to a folder via a form, put the filename (only) into the db but AFTER it's prefixed with a number then stores it in the folder.

To find the the next autoincrement:

SHOW TABLE STATUS LIKE `table`

moonbrat

Ok I got the mailing thing worked out, thanks ^_

But for the image prefixing, hmn...I don't qite understand, sorry--not feeling all that well so I can't really think today; this is a section of my coding:

$filename=$_POST['user_id']."_".$_FILES['image']['name'];

move_uploaded_file($_FILES['image']['tmp_name'],$directory.$filename);
  chmod($directory.$filename,0644);

  $user_id=(int)$_POST['user_id'];
  mysql_query("INSERT INTO images (user_id,filename)VALUES($user_id,'".mysql_real_escape_string($filename)."')");

So, I'd need to either a) auto icrement my imagefile field in my db cos at the moment I have user_id (autoincremented) as the prefix which returns myimage.gif (without any number prefixed ><) into my db as a file name and uploads the image to my images folder as myimage.gif

Or do use the LIKE db function in my coding?

Roger_Ramjet

If you are not getting the user_id prefixed to the filename it is because the user_id is not being posted with the form. Nothing else wrong with that code so it must be that $_POST['user_id'] is empty.

You could use sessions to store the user id, OR add a hidden element to the form with the user id as it's value.

moonbrat

oops, ok that's where I went wrong, I forgot to call it from session >_< thanks.