Upload a file

**Aravinthan** · 10-14-2008 06:14 PM

Hi,
My guild asked recently started a in-guild league. And to ease up the leader's work I proposed to help him manage it. As he was doing everything manually changing points, adding game and all, I proposed to change the whole thing to databases. Everything went well, I've been able to add a way to add a player to the league, give him is win/defeat, give him is points. Update his recent games played. Now I am wondering how I can upload the recording of the games. Its a file that I would like to store in the database.
Here is the code I have so far:
THe form:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<TITLE>Insert New Game</TITLE>
<META NAME="Generator" CONTENT="TextPad 4.6">
<META NAME="Author" CONTENT="?">
<META NAME="Keywords" CONTENT="?">
<META NAME="Description" CONTENT="?">
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#FF0000" VLINK="#800000" ALINK="#FF00FF" BACKGROUND="?">
<form name="ladder Update" action="http://www.aoe3clan.com/index.php?na...1&file=update2" method="post" ENCTYPE="multipart/form-data">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
Game ID:
</td>
<td>
<input type="text" name="gameid">
</td>
</tr>
<tr>
<td>
Player 1:
</td>
<td>
<input type="text" name="player1">
</td>
</tr>
<tr>
<td>
Player 2:
</td>
<td>
<input type="text" name="player2">
</td>
</tr>
<tr>
<td>
Winner:
</td>
<td>
<input type="text" name="winner">
</td>
</tr>
<tr>
<td>
Map:
</td>
<td>
<input type="text" name="map">
</td>
</tr>
<tr>
<td>
Record File:
</td>
<td>
<input type="file" name="file" id="file" />
</td>
</tr>
<tr>
<tr>
<td>
<input type="submit" name="submit" value="Submit">
<input type="reset" name="reset" value="Reset">
</td>
</tr>
</table>
</form>
</BODY>
</HTML>

And the update file:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<TITLE>Player Updated</TITLE>
<META NAME="Generator" CONTENT="TextPad 4.6">
<META NAME="Author" CONTENT="?">
<META NAME="Keywords" CONTENT="?">
<META NAME="Description" CONTENT="?">
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#FF0000" VLINK="#800000" ALINK="#FF00FF" BACKGROUND="?">
<?php
$gameid = $_POST['gameid'];
$player1 = $_POST['player1'];
$player2 = $_POST['player2'];
$winner = $_POST['winner'];
mysql_connect("host", "username", "pass") or die(mysql_error());
mysql_select_db("aoe3clan_division1") or die(mysql_error());
$sql="SELECT COUNT(*) AS count
FROM games
WHERE gameid='$gameid'";
$result=mysql_query($sql);
$row=mysql_fetch_assoc($result);
if ($row['count']>0){
echo "There is already a game with this id. <a href='www.aoe3clan.com'>Home</a>";
}
else {
mysql_query("INSERT INTO games (gameid, player1, player2, winner, map)
VALUES ('$gameid', '$player1', '$player2', '$winner', '$map')");
print "Game $gameid has been successfully inserted into the database. Details:</br>GameId: $gameid</br> Player1: $player1</br> Player2: $player2</br> Winner:$winner</br> Map:$map</br>";
mysql_close($result);
$tmpName = $_FILES[’SpecialFile’][’tmp_name’];
$filesize = $_FILES[’SpecialFile’][’size’];
$filetype = $_FILES[’SpecialFile’][’type’];
$fp= fopen($tmpName, ‘r’);
$content = addslashes($content);
fclose($fp);
$filename = $player1 " .vs " $player2 " on " $map;
mysql_query("INSERT INTO UploadedFiles (name, size, type, content)
VALUES ('$filename', $filesize, '$filetype', '$content')");
$result = mysql_query($query);
if (!$result) {
dberror (mysql_error(), $_SERVER[’PHP_SELF’] );
echo mysql_error();
}
//Display Confirmation
print "</br> $filename has been succesfully uploaded</br>";
exit;
}

if ($winner == $player1) {
$result = mysql_query("SELECT * FROM player_stats WHERE name='$player1'") or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$oldp1 = $row['points'];
$newp1 = '3';
$point = $oldp1 + $newp1;
$oldgp1 = $row['gp'];
$newgp1 = '1';
$gp = $oldgp1 + $newgp1;
$oldwins1 = $row['wins'];
$newwins1 = '1';
$wins1 = $oldwins1 + $newwins1;
mysql_query("UPDATE player_stats SET points='$point', gp='$gp', wins='$wins1' WHERE name='$player1'")
or die(mysql_error());
print "$player1 has successfully received $newp1 points.";
}
mysql_close($result);
$result = mysql_query("SELECT * FROM player_stats WHERE name='$player2'") or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$oldp2 = $row['points'];
$newp2 = '1';
$point = $oldp2 + $newp2;
$oldgp2 = $row['gp'];
$newgp1 = '1';
$gp = $oldgp1 + $newgp1;
$oldloss2 = $row['loss'];
$newloss2 = '1';
$loss2 = $oldloss2 + $newloss2;
mysql_query("UPDATE player_stats SET points='$point', gp='$gp', defeats='$loss2' WHERE name='$player2'")
or die(mysql_error());
print "$player2 has successfully received $newp2 points. ";
}
}
else {
$result = mysql_query("SELECT * FROM player_stats
WHERE name='$player1'") or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$oldp1 = $row['points'];
$newp1 = '1';
$point = $oldp1 + $newp1;
$oldgp1 = $row['gp'];
$newgp1 = '1';
$gp = $oldgp1 + $newgp1;
$oldloss1 = $row['defeats'];
$newloss1 = '1';
$loss1 = $oldloss1 + $newloss1;
mysql_query("UPDATE player_stats SET points='$point', gp='$gp', defeats='$loss1' WHERE name='$player1'")
or die(mysql_error());
print "$player1 has successfully received $newp1 points. <a href='http://www.aoe3clan.com/test/ladder.php'> View the Ladder</a>";
}
mysql_close($result);
$result = mysql_query("SELECT * FROM player_stats WHERE name='$player2'") or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$oldp2 = $row['points'];
$newp2 = '3';
$point = $oldp2 + $newp2;
$oldgp2 = $row['gp'];
$newgp2 = '1';
$gp = $oldgp2 + $newgp2;
$oldwins2 = $row['wins'];
$newwins2 = '1';
$wins2 = $oldwins2 + $newwins2;
mysql_query("UPDATE player_stats SET points='$point', gp='$gp', wins='$wins2' WHERE name='$player2'")
or die(mysql_error());
print "</br>$player2 has successfully received $newp2 points. <a href='http://www.aoe3clan.com/test/ladder.php'> View the Ladder</a>";
}
}
}
?>
</BODY>
</HTML>

Without the upload section, everything works fine. But when I add that, It doesnt. I dont get any error code or anything. Its blank, nothing gets loaded not even the title....

THanks for your help,
Ara

**phpasks** · 10-14-2008 11:24 PM

You can upload file in specific folder & save file name only in your db.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<TITLE>Player Updated</TITLE>
<META NAME="Generator" CONTENT="TextPad 4.6">
<META NAME="Author" CONTENT="?">
<META NAME="Keywords" CONTENT="?">
<META NAME="Description" CONTENT="?">
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#FF0000" VLINK="#800000" ALINK="#FF00FF" BACKGROUND="?">
<?php
$gameid = $_POST['gameid'];
$player1 = $_POST['player1'];
$player2 = $_POST['player2'];
$winner = $_POST['winner'];
mysql_connect("host", "username", "pass") or die(mysql_error());
mysql_select_db("aoe3clan_division1") or die(mysql_error());
$sql="SELECT COUNT(*) AS count
FROM games
WHERE gameid='$gameid'";
$result=mysql_query($sql);
$row=mysql_fetch_assoc($result);
if ($row['count']>0){
echo "There is already a game with this id. <a href='www.aoe3clan.com'>Home</a>";
}
else {
mysql_query("INSERT INTO games (gameid, player1, player2, winner, map)
VALUES ('$gameid', '$player1', '$player2', '$winner', '$map')");
print "Game $gameid has been successfully inserted into the database. Details:</br>GameId: $gameid</br> Player1: $player1</br> Player2: $player2</br> Winner:$winner</br> Map:$map</br>";
mysql_close($result);
$tmpName = $_FILES[’SpecialFile’][’tmp_name’];
$filesize = $_FILES[’SpecialFile’][’size’];
$filetype = $_FILES[’SpecialFile’][’type’];

/*You can upload File in Folder **********************//////////////////
$new_image_name = "upload/".$_FILES['SpecialFile']['name'];

/**************** This new_image_name filename store in your db **********************/

if (!move_uploaded_file ($_FILES['SpecialFile']['tmp_name'],$new_image_name)) {
return false;
} else {
return true;
}

/*You can upload File in Folder **********************//////////////////
$fp= fopen($tmpName, ‘r’);
$content = addslashes($content);
fclose($fp);
$filename = $player1 " .vs " $player2 " on " $map;
mysql_query("INSERT INTO UploadedFiles (name, size, type, content)
VALUES ('$filename', $filesize, '$filetype', '$content')");
$result = mysql_query($query);
if (!$result) {
dberror (mysql_error(), $_SERVER[’PHP_SELF’] );
echo mysql_error();
}
//Display Confirmation
print "</br> $filename has been succesfully uploaded</br>";
exit;
}

if ($winner == $player1) {
$result = mysql_query("SELECT * FROM player_stats WHERE name='$player1'") or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$oldp1 = $row['points'];
$newp1 = '3';
$point = $oldp1 + $newp1;
$oldgp1 = $row['gp'];
$newgp1 = '1';
$gp = $oldgp1 + $newgp1;
$oldwins1 = $row['wins'];
$newwins1 = '1';
$wins1 = $oldwins1 + $newwins1;
mysql_query("UPDATE player_stats SET points='$point', gp='$gp', wins='$wins1' WHERE name='$player1'")
or die(mysql_error());
print "$player1 has successfully received $newp1 points.";
}
mysql_close($result);
$result = mysql_query("SELECT * FROM player_stats WHERE name='$player2'") or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$oldp2 = $row['points'];
$newp2 = '1';
$point = $oldp2 + $newp2;
$oldgp2 = $row['gp'];
$newgp1 = '1';
$gp = $oldgp1 + $newgp1;
$oldloss2 = $row['loss'];
$newloss2 = '1';
$loss2 = $oldloss2 + $newloss2;
mysql_query("UPDATE player_stats SET points='$point', gp='$gp', defeats='$loss2' WHERE name='$player2'")
or die(mysql_error());
print "$player2 has successfully received $newp2 points. ";
}
}
else {
$result = mysql_query("SELECT * FROM player_stats
WHERE name='$player1'") or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$oldp1 = $row['points'];
$newp1 = '1';
$point = $oldp1 + $newp1;
$oldgp1 = $row['gp'];
$newgp1 = '1';
$gp = $oldgp1 + $newgp1;
$oldloss1 = $row['defeats'];
$newloss1 = '1';
$loss1 = $oldloss1 + $newloss1;
mysql_query("UPDATE player_stats SET points='$point', gp='$gp', defeats='$loss1' WHERE name='$player1'")
or die(mysql_error());
print "$player1 has successfully received $newp1 points. <a href='http://www.aoe3clan.com/test/ladder.php'> View the Ladder</a>";
}
mysql_close($result);
$result = mysql_query("SELECT * FROM player_stats WHERE name='$player2'") or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$oldp2 = $row['points'];
$newp2 = '3';
$point = $oldp2 + $newp2;
$oldgp2 = $row['gp'];
$newgp2 = '1';
$gp = $oldgp2 + $newgp2;
$oldwins2 = $row['wins'];
$newwins2 = '1';
$wins2 = $oldwins2 + $newwins2;
mysql_query("UPDATE player_stats SET points='$point', gp='$gp', wins='$wins2' WHERE name='$player2'")
or die(mysql_error());
print "</br>$player2 has successfully received $newp2 points. <a href='http://www.aoe3clan.com/test/ladder.php'> View the Ladder</a>";
}
}
}
?>
</BODY>
</HTML>

***Chris S*** · 10-15-2008 02:41 PM

also, how large is the file that you are uploading. by default there are two things in php that would limit how well an upload works, max_file_upload, and the script time out. If anything I believe that you will reach the file size limit before you reach the script time out.

**Aravinthan** · 10-15-2008 04:46 PM

Its around 450 Kb chris....,
Ok so if I understand it should look something like this:

$tmpName = $_FILES[’SpecialFile’][’tmp_name’];
$filesize = $_FILES[’SpecialFile’][’size’];
$filetype = $_FILES[’SpecialFile’][’type’];
$new_image_name = "modules/Divison1/upload/".$_FILES['SpecialFile']['name'];

if (!move_uploaded_file ($_FILES['SpecialFile']['tmp_name'],$new_image_name)) {
return false;
} else {
return true;
}

$filename = $player1 " .vs " $player2 " on " $map;
mysql_query("INSERT INTO UploadedFiles (name)
VALUES ('$filename')");
//Display Confirmation
print "</br> $filename has been succesfully uploaded</br>";
exit;
}

I tried it but it still doesnt work, the page is blank, the title doesnt get loaded neither....

**natsuki** · 10-16-2008 08:31 AM

Originally Posted by Aravinthan

Its around 450 Kb chris....,
Ok so if I understand it should look something like this:

I tried it but it still doesnt work, the page is blank, the title doesnt get loaded neither....

$tmpName = $_FILES[’SpecialFile’][’tmp_name’];
$filesize = $_FILES[’SpecialFile’][’size’];
$filetype = $_FILES[’SpecialFile’][’type’];
$new_image_name = "modules/Divison1/upload/".$_FILES['SpecialFile']['name'];

if (!move_uploaded_file ($_FILES['SpecialFile']['tmp_name'],$new_image_name)) {
return false;
} else {
return true;
}

$filename = $player1 " .vs " $player2 " on " $map;
mysql_query("INSERT INTO UploadedFiles (name)
VALUES ('$filename')");
//Display Confirmation
print "</br> $filename has been succesfully uploaded</br>";
exit;
}

Why are you returning anyway? Other then that I'm kinda confused with the code, maybe because it was not indented... I'll try to check when I have time

PHP Code:


$filename = $player1 " .vs " $player2 " on " $map;

what does this do?

***Chris S*** · 10-16-2008 02:03 PM

not sure if the error was fixed, but I put some debugging in here and then you had an extra bracket so I fixed that also. I also added indenting. Granted, I was self taught so it might look a tad weird to other people.

PHP Code:


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">

<HTML>

<HEAD>

<TITLE>Player Updated</TITLE>

<META NAME="Generator" CONTENT="TextPad 4.6">

<META NAME="Author" CONTENT="?">

<META NAME="Keywords" CONTENT="?">

<META NAME="Description" CONTENT="?">

</HEAD>

<BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#FF0000" VLINK="#800000" ALINK="#FF00FF" BACKGROUND="?">

<?php

$gameid = $_POST['gameid'];

$player1 = $_POST['player1'];

$player2 = $_POST['player2'];

$winner = $_POST['winner'];

mysql_connect("host", "username", "pass") or die(mysql_error());

mysql_select_db("aoe3clan_division1") or die(mysql_error());

$result = mysql_query("SELECT COUNT(*) AS count FROM games WHERE gameid='$gameid'") or die(mysql_error());

$row=mysql_fetch_assoc($result);

if ($row['count']>0){

  echo "There is already a game with this id. <a href='www.aoe3clan.com'>Home</a>";

}else {

  mysql_query("INSERT INTO games (gameid, player1, player2, winner, map) VALUES ('$gameid', '$player1', '$player2', '$winner', '$map')") or die(mysql_error());

  print "Game $gameid has been successfully inserted into the database. Details:</br>GameId: $gameid</br> Player1: $player1</br> Player2: $player2</br> Winner:$winner</br> Map:$map</br>";

  mysql_close($result);



  $tmpName = $_FILES[’SpecialFile’][’tmp_name’];

  $filesize = $_FILES[’SpecialFile’][’size’];

  $filetype = $_FILES[’SpecialFile’][’type’];



  /*You can upload File in Folder **********************//////////////////

  $new_image_name = "upload/".$_FILES['SpecialFile']['name'];



  /**************** This new_image_name filename store in your db **********************/



  if (move_uploaded_file ($_FILES['SpecialFile']['tmp_name'],$new_image_name)) {

    echo 'File Uploaded Correctly....(Debugging)';

  } else {

    echo 'File NOT Uploaded Correctly....(Debugging (Check permissions))';

  }





  /*You can upload File in Folder **********************//////////////////

  $fp= fopen($tmpName, ‘r’);

  $content = addslashes($content);

  fclose($fp);

  $filename = $player1 " .vs " $player2 " on " $map;

  $result = mysql_query("INSERT INTO UploadedFiles (name, size, type, content) VALUES ('$filename', $filesize, '$filetype', '$content')") or die(mysql_error());

  //$result = mysql_query($query);

  

  //Display Confirmation

  print "</br> $filename has been succesfully uploaded</br>";

  exit;

}





if ($winner == $player1) {

  $result = mysql_query("SELECT * FROM player_stats WHERE name='$player1'") or die(mysql_error());

  while($row = mysql_fetch_array( $result )) {

    $oldp1 = $row['points'];

    $newp1 = '3';

    $point = $oldp1 + $newp1;

    $oldgp1 = $row['gp'];

    $newgp1 = '1';

    $gp = $oldgp1 + $newgp1;

    $oldwins1 = $row['wins'];

    $newwins1 = '1';

    $wins1 = $oldwins1 + $newwins1;

    mysql_query("UPDATE player_stats SET points='$point', gp='$gp', wins='$wins1' WHERE name='$player1'") or die(mysql_error());

    print "$player1 has successfully received $newp1 points.";

  }

  mysql_close($result);

  $result = mysql_query("SELECT * FROM player_stats WHERE name='$player2'") or die(mysql_error());

  while($row = mysql_fetch_array( $result )) {

    $oldp2 = $row['points'];

    $newp2 = '1';

    $point = $oldp2 + $newp2;

    $oldgp2 = $row['gp'];

    $newgp1 = '1';

    $gp = $oldgp1 + $newgp1;

    $oldloss2 = $row['loss'];

    $newloss2 = '1';

    $loss2 = $oldloss2 + $newloss2;

    mysql_query("UPDATE player_stats SET points='$point', gp='$gp', defeats='$loss2' WHERE name='$player2'") or die(mysql_error());

    print "$player2 has successfully received $newp2 points. ";

  }

}else {

  $result = mysql_query("SELECT * FROM `player_stats` WHERE name='$player1'") or die(mysql_error());

  while($row = mysql_fetch_array( $result )) {

    $oldp1 = $row['points'];

    $newp1 = '1';

    $point = $oldp1 + $newp1;

    $oldgp1 = $row['gp'];

    $newgp1 = '1';

    $gp = $oldgp1 + $newgp1;

    $oldloss1 = $row['defeats'];

    $newloss1 = '1';

    $loss1 = $oldloss1 + $newloss1;

    mysql_query("UPDATE player_stats SET points='$point', gp='$gp', defeats='$loss1' WHERE name='$player1'") or die(mysql_error());

    print "$player1 has successfully received $newp1 points. <a href='http://www.aoe3clan.com/test/ladder.php'> View the Ladder</a>";

  }

  mysql_close($result);

  $result = mysql_query("SELECT * FROM player_stats WHERE name='$player2'") or die(mysql_error());

  while($row = mysql_fetch_array( $result )) {

    $oldp2 = $row['points'];

    $newp2 = '3';

    $point = $oldp2 + $newp2;

    $oldgp2 = $row['gp'];

    $newgp2 = '1';

    $gp = $oldgp2 + $newgp2;

    $oldwins2 = $row['wins'];

    $newwins2 = '1';

    $wins2 = $oldwins2 + $newwins2;

    mysql_query("UPDATE player_stats SET points='$point', gp='$gp', wins='$wins2' WHERE name='$player2'") or die(mysql_error());

    print "</br>$player2 has successfully received $newp2 points. <a href='http://www.aoe3clan.com/test/ladder.php'> View the Ladder</a>";

  }

}

?>

</BODY>

</HTML>

**Aravinthan** · 10-16-2008 05:40 PM

Nope it still doesnt work, it still stays blank without the title being uploaded.
And natsuki that little part, is for changing the name of the file to player1 vsplayer2 so its easire to find this game back again

**natsuki** · 10-16-2008 07:17 PM

Then you should double check it, it is syntactically erroneous it's a T_CONSTANT_ENCAPSED_STRING issue. It should be

PHP Code:


$filename = $player1 . " vs " . $player2 . " on " . $map; // or
$filename = "$player1 vs $player2 on $map"; // or
$filename = $player1 . ' vs ' . $player2 . ' on ' . $map;

with the concatenation operator (.), you can't just assume php will add it for you

**Aravinthan** · 10-18-2008 11:32 AM

THe page still remains blank, but now the title gets loaded....

**Aravinthan** · 10-20-2008 05:31 PM

any1?

Thread: Upload a file

LinkBack

Thread Tools

Display

Upload a file

Re: Upload a file

Re: Upload a file

Re: Upload a file

Re: Upload a file

Re: Upload a file

Re: Upload a file

Re: Upload a file

Re: Upload a file

Re: Upload a file

Similar Threads

It works! ...

Two very simple php file upload scripts-Free

Internal Serve Error

help!!

php version

Posting Permissions