FUDforum

Post Form

You are not currently logged in, the message will be posted anonymously.

Forum:

Test Forum

Title:

Poll:

Message Icon:

No Icon

Smiley Shortcuts:
[ list all smilies ]

Formatting Tools:

Body:

Forum Options:
HTML code is off
BBcode is on
Images are on
Smilies are on
Editing Time Limit: Unlimited

File Attachments:

Allowed File Extensions: jpg jpeg png gif txt doc gz bz2 inc php zip diff
Maximum File Size: 25KB
Maximum Files Per Message: 3

Verification:

 $         $$$$$   $$$$$$$$  $$       
 $    $   $     $  $$        $$       
 $    $   $     $  $$        $$       
 $    $    $$$$$$  $$$$$$    $$       
 $$$$$$$        $  $$        $$       
      $   $     $  $$        $$       
      $    $$$$$   $$$$$$$$  $$$$$$$$

Options:

Disable smilies in this message

Topic View

php script for insert avatars into mysql

Tue, 17 December 2002 19:18

Anonymous

is that cool ?[ 0 votes ]
1.	yes	0 / 0%
2.	no	0 / 0%
3.	equal	0 / 0%
4.	who matters	0 / 0%

<?
$user = "user";
$password = "password";
$hostname = "localhost_or_IP";
$path = 'images/avatars/';
mysql_connect($hostname, $user, $password)
or die("Unable to connect to SQL server");
$this_id = mysql_insert_id();
$dir_handle = @opendir($path) or die("Unable to open $path");
while($file = readdir($dir_handle)) {
if (substr($file, -3) == 'jpg') {
$result = mysql_db_query("fudforum", "INSERT INTO fud23_avatar (img) VALUES ('$file')");
} }
closedir($dir_handle);
?>

Current Time: Sun Dec 22 21:58:08 GMT 2024

Total time taken to generate the page: 0.02467 seconds