PHP - File Upload Doesn't Exist Sometimes

I'm printing some mysql results to a table and sometimes I have rows with no results so they never get counted...  which results in an ugly looking parenthesis on my page with nothing it  ().  For these times, I'd like to print a zero. 

How can I rewrite the following to achieve this? 

Code: [Select]
if($row['mycount'] does not exist) {
$row['mycount'] = '0';
}

Delete.

I guess I'm just stupid cause it seems like every time i get stuck and i post on here and its gets answered in less than 30 min.'s and i keep getting stuck!

Here my script...

function scoring($user){
$query = "SELECT Game_ID, Pick FROM Cfb WHERE User_ID= 1";
$result = mysql_query($query);

$query1 = "SELECT Game_ID, Pick FROM Cfb WHERE User_ID= $user";
$result1 = mysql_query($query1);

$affected = mysql_num_rows($result);

for($i=0; $i< $affected; $i++) {
$scores =mysql_fetch_assoc($result);
$scores1 =mysql_fetch_assoc($result1);

$main = array_diff_assoc($scores,$scores);
$me = array_diff_assoc($scores, $scores1);

$m = count($me);
$m1 = count($main);

if ($m == $m1){
$points += 1;
}else{
$points += 0;
}
}

echo '<br />';
echo '<br />';
echo $user;
echo '<br />';
echo $points;
echo '<hr />';
}

$sql="SELECT  id FROM users WHERE approved=1 AND user_level !=10";
    $result=mysql_query($sql);
while($row = mysql_fetch_object($result))
   {
    $ids[] = $row->id;
   }
   
print_r($ids);


Alright heres what this script does...
The script has a function that scores 1 individual user for his/her choices.
Then I'm getting the user_ids from the users table at the bottom. Taking those and plugging them back into the function to score all the users at one time.

Problem...
Not all users will make picks. So how do i break the script in the function if that user_id is not is the CFB table attached to picks

I have 2 tables im using Cfb and users

users controls user info such as id # name username ect..
Cfb controls the picks. When a user makes there selection it stores there User_ID, Game_ID, and Pick

So not all user ids are in the Cfb table. So if the script tries to input a user id thats not in the Cfb table it needs to break. Right now it just screws everything up!

So how can i make it break that way?

Thanks for any help

Hi,
No matter what I seem to change in my code, I sill get the same error!

"Table 'suvoocom_wl.beta' doesn't exist"

This is my 'core.php' file;

Code: [Select]
<?php
session_start();

@include ('config.php');
@include ('connect.php');

// #########################################################################
// Check if Writing Lounge is under maintenance, and avoid, if possible

$qry="SELECT * FROM fuse_rights WHERE username='".$_SESSION['username']."'";
$result=mysql_query($qry);

if($result) {
if(mysql_num_rows($result) == 1) {

$checks = mysql_fetch_assoc($result);
$am = $checks['avoid_maintenance'];

}
}

if(isset($_SESSION['username']) && $am == 0)
{ 

$result = mysql_query("SELECT * FROM break") or die(mysql_error());  

while($row = mysql_fetch_assoc($result)) {
 if($row['on'] == 1) {
   header('location:../maintenance');
   exit();
 }
}
} 
if(isset($_SESSION['username']) && $am == 1)
{ 
} else {
$result = mysql_query("SELECT * FROM break") or die(mysql_error());  

while($row = mysql_fetch_assoc($result)) {
 if($row['on'] == 1) {
   header('location:../maintenance');
   exit();
 }
 }
 }
 
// #########################################################################
// Check if Writing Lounge has BETA activated

if(!session_is_registered(betaaccess)){

$result = mysql_query("SELECT * FROM beta") or die(mysql_error());  

while($row = mysql_fetch_assoc($result)) {
 if($row['on'] == 1) {
   header('location:../BETA');
   exit();
 }
 }
 }
 
// #########################################################################
// Check if the user logged in is banned

$result = mysql_query("SELECT username FROM bans WHERE username = '".$_SESSION['username']."'") or die(mysql_error());  

if (mysql_num_rows($result) > 0) {
   header('location:../banned');
   exit();
}

// #########################################################################
// Define the variables Writing Lounge will use later on

$remote_ip = $_SERVER[REMOTE_ADDR];
$H = date('H');
$i = date('i');
$s = date('s');
$m = date('m');
$d = date('d');
$Y = date('Y');
$j = date('j');
$n = date('n');
$today = $d;
$month = $m;
$year = $Y;
$date_normal = date('d-m-Y',mktime($m,$d,$Y));
$date_reversed = date('Y-m-d', mktime($m,$d,$y));
$date_full = date('d-m-Y H:i:s',mktime($H,$i,$s,$m,$d,$Y));
$date_time = date('H:i:s',mktime($H,$i,$s));
$date_hc = "".$j."-".$n."-".$Y."";
$regdate = $date_normal;
$forumid = strip_slashes($_GET['id']);
?>

It's basically the backbone to my website.

This is my 'config.php' file;

Code: [Select]
<?php
$sqlhostname = "localhost";
$sqlusername = "suvoocom_wl";
$sqlpassword = "*****";
$sqldb = "suvoocom_wl";
?>

And this is my 'connect.php' file;

Code: [Select]
<?php
mysql_connect("$sqlhostname", "$sqlusername", "$sqlpassword")or die("Unable to connect.");
mysql_select_db("$sqldb")or die("Unable to select the database you provided. Either I do not have premission to connect to that database, or the database doesn't exist.");
?>

Does anyone have any ideas? :S
Thanks!

First time post, be easy on me...   I'm using preg_match_all to return an array with all the matches.  I know I'm missing something fundamental, but I either keep looking past it or am more screwy than I know.   Sample String

CC-BY-ND-NC

I'm using the following code

preg_match_all("/cc|creative commons|copyright|by|sa|nc|nd/i",$exifmeta['copyright'],$cmeta)

I would expect to see

Array
(
    [0] => Array
        (
            [0] => CC
            [1] => BY
            [2] => ND
            [3] => NC
        )

)

What I get is

Array
(
    [0] => Array
        (
            [0] => CC
            [1] => BY
            [2] => ND
            [3] => NC
            [4] => sa
        )

)

Hi,

My site was working fine, but I just switched servers/web hosts and now I'm getting the following errors (in blue). The thing is, I don't get the error if I try to run the query loop after just using 'mysql_select_db' once, but if I use it again to select a different database and then run the query loop, I start getting the error.

Code: [Select]
mysql_select_db ("database1", $mysql_con);

$mysql_query = mysql_query ("SELECT ID FROM someTable1", $mysql_con);
$someVar1 = 0;

while ($mysql_array = mysql_fetch_array ($mysql_query))
{
$someVar1 ++;
}


////// The above code gives me no error. But If I then try to select a different database and run a loop in the same way (in the same file), I start getting the below error...


mysql_select_db ("database2", $mysql_con);

$mysql_query = mysql_query ("SELECT ID FROM someTable2", $mysql_con);
$someVar2 = 0;

while ($mysql_array = mysql_fetch_array ($mysql_query))
{
$someVar2 ++;
}
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/snubby5/public_html/coozymcmillan.com/view.php on line 86

So I looked it up and somewhere it told me to add some extra code to handle errors better:

Code: [Select]
if ($mysql_query === FALSE) {
    die (mysql_error ()); // TODO: better error handling
}
But when I do that, I get a different error:

Table 'database1.someTable2' doesn't exist

It doesn't seem to recognize that I switched databases, and it says 'database1.someTable2' doesn't exist (because it doesn't), when really it should be checking for 'database2.someTable2' (which exists).

So to reiterate, I can run the query loop fine after selecting database1, but after that if I select database2, it either gives me the first error, or If I add the 'die' code it gives me the second error.


Thanks much!

PS: I can get it working if I put everything into one database, but I have multiple websites (which sometimes need to call eachothers' databases) and it would be a huge hassle to cram them all into one database unless I have to.

files that upload during insert/submit form was gone , only files upload during the update remain , is the way query for update multiple files is wrong ?

$targetDir1= "folder/pda-semakan/ic/";
if(isset($_FILES['ic'])){
     $fileName1 = $_FILES['ic']['name'];
 $targetFilePath1 = $targetDir1 . $fileName1;
 //$main_tmp2 = $_FILES['ic']['tmp_name'];
$move2 =move_uploaded_file($_FILES["ic"]["tmp_name"], $targetFilePath1);
}

$targetDir2= "folder/pda-semakan/sijil_lahir/";
if(isset($_FILES['sijilkelahiran'])){
     $fileName2 = $_FILES['sijilkelahiran']['name'];
 $targetFilePath2 = $targetDir2 . $fileName2;
$move3 =move_uploaded_file($_FILES["sijilkelahiran"]["tmp_name"], $targetFilePath2);
}

$targetDir3= "folder/pda-semakan/sijil_spm/";
if(isset($_FILES['sijilspm'])){
     $fileName3 = $_FILES['sijilspm']['name'];
 $targetFilePath3 = $targetDir3 . $fileName3;
$move4 =move_uploaded_file($_FILES["sijilspm"]["tmp_name"], $targetFilePath3);
}



$query1=("UPDATE semakan_dokumen set student_id='$noMatrik', email= '$stdEmail', surat_tawaran='$fileName', ic='$fileName1',sijil_lahir='$fileName2',sijil_spm= '$fileName3' where email= '$stdEmail'");

 

Hi all,

I want to make a script that identifies if an image JPG file exists.

Would somthing like this work?


<?php
$file = "images/image.jpg";
if ($file > 0) {
echo "file exists";
}
else { echo "no file"; }
?>

Hi everyone, I'm still learning, but getting intermediate in PHP now, but it is still challenge to learn. I'm trying to have php check to see if one file inside folder in server, seem I could not get it right, but I tested it on other site, it works, but not this script, I don't understand why it won't work...maybe logical is wrong?

here my code:

	if ($_POST['video']) {
	        $path1 = "UPLOADS/Home/";
        $path2 = "UPLOADS/Breakfast/";
        $path3 = "UPLOADS/Spider/";
	        $scan1 = scandir($path1);
        $scan2 = scandir($path2);
        $scan3 = scandir($path3);
	        $count1 = count($scan1) - 3;
        $count2 = count($scan2) - 3;
        $count3 = count($scan3) - 3;
	        if($count1 > 0) {
            header('location:exist.html');
        }elseif ($count2 > 0) {
            header('location:exist.html');
        }elseif ($count3 > 0) {
            header('location:exist.html');
        }
	

But other site, it works:

	$scan = scandir($path);
$count = count($scan) - 3;
	echo $count;
	if($count > 1){
    echo "Hello yourself!<br />";
}
	

Anyone will help will be appreciate! Thank you!

Gary

Edited April 3, 2019 by sigmahokies

i have error where my code should update existing data where id exist, it get updated ..but the others data is disappeared .only the data updated is remained 

$sql1 ="select*from semakan_dokumen where email='$stdEmail'";
$sqlsearch1 = mysqli_query($dbconfig,$sql1);
$resultcount1 = mysqli_num_rows($sqlsearch1);

if($resultcount1 > 0){
$query1=("UPDATE  semakan_dokumen set student_id='$noMatrik', email= '$stdEmail', surat_tawaran='$fileName', ic='$fileName1',sijil_lahir='$fileName2',sijil_spm= '$fileName3',sijil_sekolah= '$fileName4', sijil_dip= '$fileName5',sej_julai='$fileName6',bm_julai='$fileName7',muet='$fileName8', mid1='$fileName9',yuran= '$fileName10',umpa_bend1= '$fileName11',umpa_bend2='$fileName12',bpkp='$fileName13', penaja='$fileName14',kesihatan= '$fileName15', jhepa='$fileName16' where email= '$stdEmail' ");

}else{


//filezip
$query1 = "INSERT INTO semakan_dokumen (email,surat_tawaran,ic,sijil_lahir,sijil_spm,sijil_sekolah,sijil_dip,sej_julai,bm_julai,muet,mid1,yuran,umpa_bend1,umpa_bend2,bpkp,penaja,kesihatan,jhepa) VALUES ('$stdEmail','$fileName','$fileName1','$fileName2','$fileName3','$fileName4','$fileName5','$fileName6','$fileName7','$fileName8','$fileName9','$fileName10','$fileName11','$fileName12','$fileName13','$fileName14','$fileName15','$fileName16')";
}

 

Hiya,

Firstly, I'm a complete novice, apologies! But I have got my upload.php working which is nice. I will post the code below.

However, I would now like to restrict the file size and file type to only word documents.

I currently have a restriction of 200KB but it's not working - no idea why as I've looked at other similar codes and they look the same.

Also, just to complicate things - can I stop files overwriting each other when uploaded? At the moment, if 2 people upload files with the same name one will overwrite the other.

Is this too many questions in 1?

Any help is very much appreciated!

Code below:

Code: [Select]
<form enctype="multipart/form-data" action="careers.php" method="POST">
        Please choose a file: <input name="uploaded" type="file" /><br />
<input type="submit" value="Upload" />
</form>

<?php 
 $target = "upload/"; 
 $target = $target . basename( $_FILES['uploaded']['name']) ; 
 $ok=1; 
 
 //This is our size condition 
 if ($uploaded_size > 200) 
 { 
 echo "Your file is too large.<br>"; 
 $ok=0; 
 } 
 
 //This is our limit file type condition 
 if ($uploaded_type =="text/php") 
 { 
 echo "No PHP files<br>"; 
 $ok=0; 
 } 
 
 //Here we check that $ok was not set to 0 by an error 
 if ($ok==0) 
 { 
 Echo "Sorry your file was not uploaded"; 
 } 
 
 //If everything is ok we try to upload it 
 else 
 { 
 if(move_uploaded_file($_FILES['uploaded']['tmp_name'], $target)) 
 { 
 echo "Your file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded."; 
 } 
 else 
 { 
 echo "Sorry, there was a problem uploading your file."; 
 } 
 } 
 ?>

In this multi file upload form, choose three images, click submit and preview the images on the preview page. If the user wishes to delete or replace an image, click edit and the form will go back to the previous page. Select the replace radio button for example on one of the three images and select a new image from the file input prompt and click submit. The form will go to the preview page again to display the images. During this process the image names are being input into a table and the images are being moved to a directory.

The table is

  `id`  AUTO_INCREMENT,
  `image0`
  `image1`
  `image2`
  `status`

So input name='image[image0]' can be directed to table `image0` and so on.

The code for keep and delete work fine, but how do I replace an image?
I have two foreach blocks. The first one deletes the image file from the directory and deletes the image name from the table, but the second foreach dose not move the new image file into the directory.
Thanks.

<input type='radio' name='image[image0]' value='keep' checked='checked'/>
<input type='radio' name='image[image0]' value='delete' />
<input type='radio' name='image[image0]' value='replace' />
<input type="file" name="image[]" />

<input type='radio' name='image[image1]' value='keep' checked='checked'/>
<input type='radio' name='image[image1]' value='delete' />
<input type='radio' name='image[image1]' value='replace' />
<input type="file" name="image[]" />

<input type='radio' name='image[image2]' value='keep' checked='checked'/>
<input type='radio' name='image[image2]' value='delete' />
<input type='radio' name='image[image2]' value='replace' />
<input type="file" name="image[]" />

<?php
if (isset($_POST['status'])) {

$status = $_POST['status'];
$confirm_code = $status;

#--------------------------- replace --------------------------------------------

if (isset($_POST['submitted']) &&
($image = $_POST['image'])) {

foreach($image as $imageKey => $imageValue) {
if ($imageValue == 'replace') {
$query = "SELECT $imageKey FROM table WHERE status = '$status' ";
if($result = $db->query( $query )){
$row = $result->fetch_array();
}

unlink( UPLOAD_DIR.$row[0] );

$query = "UPDATE table SET $imageKey = '' WHERE status = '$status' ";
}
}

foreach($image as $imageKey => $imageValue) {
if ($imageValue == 'replace') {

$filenm = $_FILES['image']['name']; 
$file = $_FILES['image']['tmp_name'];

move_uploaded_file($file, UPLOAD_DIR . $filenm);
$filename[] = $filenm; 

$query = "INSERT INTO table VALUES ('','$filename[0]','$filename[1]','$filename[2]','$confirm_code')";
}
}
}
}
?>

I havent included the whole title as it wouldnt let me but I was wondering if someone could help me on this?

I know this is possible as torrentflux caters for this but unsure of where to start.

I dont want to allow file or directory uploads or creation in my /etc/php.ini file (this is turned off).

Yet then torrentflux allows me to link a torrent from an external source (using legal downloads of course  ) but then it uploads it on my server and creates folders on a per user basis.

How is this possible can someone give me some pointers please?

I look forward to any replies,
Jeremy.

Hello, all: been trying to convert this little single-file upload to multiple by naming each file form-field as "userfile[]" as it's supposed to automatically treat them as an array.. but no luck!  Can you guide me as to what am I doing wrong??
appreciate the help!


Code: [Select]
<?php

if (!isset($_REQUEST["seenform"])) {
?>
   <form enctype="multipart/form-data" action="#" method="post">
   Upload file: <input name="userfile[]" type="file" id="userfile[]">
   Upload file: <input name="userfile[]" type="file" id="userfile[]">
   <input type="submit" value="Upload">
   <input type="hidden" name="seenform">
   </form>
<?php
} 
else 
{ // upload begins
$userfiles = array($_FILES['userfile']);
foreach ($userfiles as $userfile)
{ // foreach begins
   $uploaded_dir = "uploads/";
   $userfile = $_FILES['userfile']["name"];
   $path = $uploaded_dir . $userfile;
   if (move_uploaded_file($_FILES['userfile']["tmp_name"], $path)) 
     {
   print "$userfile file moved";
   // do something with the file here
    } else 
{
   print "Move failed";
}
} // foreach ends
} // upload ends

?>

<td><label for='images'> <b>File to upload:</b> </label></td>
            <td><input type='file'  name = 'drama_image' '<?php echo $row['drama_image']; ?>'/></
                       </tr>
         
   <?php
            $target_path = "images/";
            $target_path = $target_path . basename( $_FILES['images']['name']);

            if(move_uploaded_file($_FILES['images']['tmp_name'], $target_path)) {
                echo "The file ".  basename( $_FILES['images']['name']).
             " has been uploaded";
            } else{
                echo $row['drama_image'];
            }
         
     ?>

['drama_image'] is the name of the file

I wanna echo it out in the box of file upload so when I save , the default picture will still be there instead of being overwritten as the box does not have any value in it.