<input type="hidden" name="url" value="<? echo $clean_name;?>"/>
a kod całego formularza wygląda tak:
<form action="" method="post" enctype="multipart/form-data"> <input type="hidden" name="username" value="<?php echo $_SESSION['login']; ?>"/> <input type="hidden" name="status" value="Approved"/> <input type="hidden" name="url" value="<? echo $clean_name;?>"/> <input type="hidden" size="40" value="<? $dzien0=date("d"); $miesiac0=date("m"); $rok0=date("Y"); echo "$rok0-$miesiac0-$dzien0"; ?>" name="data"> <input type="submit" name="submit" value="Upload" /> </form>
Sam kod php odpowiedzialny za upload/wykonywanie formularza:
<? require("connection.php"); connection(); $username = ($_POST['username']); $status = $_POST['status']; $url = $_POST['url']; $data = $_POST['data']; $zapytanie = "INSERT INTO `mproof` VALUES(' ','$username','$status','$url','$data')"; $dir = "./proof/"; //Change this to the correct dir RELATIVE TO WHERE THIS SCRIPT IS, or /full/path/ //MIME types to allow, Gif, jpeg, zip ::Edit this to your liking $types = array("image/png","image/x-png","image/gif","image/jpeg","image/pjpeg","image/jpg","image/bmp"); // Nothing to edit below here. //Function to do a directory listing function CPGscandir($dirstr) { } //Shorten Variables $tmp_name = $_FILES['upload']['tmp_name']; $new_name = $rand.$_FILES['upload']['name']; $path = $_POST['subdir']; $fullpath = "$dir$path/"; $clean_name = ereg_replace("[^a-z0-9._]", "", str_replace(" ", "_", str_replace("%20", "_", strtolower($new_name) ) ) ); $string = $dir; // lets see if we are uploading a file or doing a dir listing scandir("$fullpath"); }else{ //Check MIME Type // create a sub-directory if required } //Move file from tmp dir to new location echo "<br /><div id='TOS'>Your proof is uploaded correctly. You could request your payout now.</div>"; }else{ //Print Error Message echo "<small>File <strong><em>{$_FILES['upload']['name']}</em></strong> Was Not Uploaded - bad file type or file already exists</small><br />"; //Debug $name = $_FILES['upload']['name']; $type = $_FILES['upload']['type']; $size = $_FILES['upload']['size']; $tmp = $_FILES['upload']['name']; } } } else { } ?>
I wszystko działało, aż tu nagle dziś przestało działać dodawanie do bazy tego jednego elementu. Dodało parę razy po upublicznieniu skrypt dla użytkowników mojej strony a potem przestało działać. Co ciekawe dodało tylko jednemu pierwszemu userowi, a ja testowałem sam wiec może to jest jakoś przypisane do jednej osoby?