PHP - Csv To Mysql Upload Infinite Loop

I have two while loops that should run infinitely.

while loop #1 runs during 9:30am - 4pm, monday through thursday
while loop #2 runs when its not 9:30am-4pm, monday through thursday.

$hourmin = date("Gi", time(now));
$current = getdate();

while ( $hourmin > 829  && $current[hours] < 15  && $current[wday] > 0 && $current[wday] < 6  ):       // while loop #1
while ( $hourmin < 830  || $current[hours] > 14  || $current[wday] = 0 || $current[wday] = 6       ):           // while loop #2



as you can see the while condition is the easy part, but I'm not sure how to set this up. I was going to do this using a combination of if statements and the goto function but my version of php does not support goto.

I just want it to switch back and forth between these these two while statements infinitely. Is this possible in PHP?

Hi guys,

I am trying to create a coding which allows users to upload and download files into mysql server, but I came across some errors. The coding itself works fine on the surface, but when I uploaded the file into mysql and download them, the contents of the downloaded file was different from the original file that was upload. One good example would be when I upload txt file or doc file. I was stuck on this for quite a few days without any leads.

Here are the codes:

index.html

<form action="add_file.php" method="post" enctype="multipart/form-data">
<input type="file" name="uploaded_file"><br>
<input type="submit" value="Upload file">
</form>
<p>
<a href="list_files.php">See all files</a>
</p>


add_file.php

<?php
// Check if a file has been uploaded
if(isset($_FILES['uploaded_file'])) {
// Make sure the file was sent without errors
if($_FILES['uploaded_file']['error'] == 0) {
// Connect to the database
$dbLink = new mysqli('localhost', 'root', 'pwd', 'myTable');
if(mysqli_connect_errno()) {
die("MySQL connection failed: ". mysqli_connect_error());
}

// Gather all required data
$name = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);
$mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);
$data = $dbLink->real_escape_string(file_get_contents($_FILES ['uploaded_file']['tmp_name']));
$size = intval($_FILES['uploaded_file']['size']);

// Create the SQL query
$query = "
INSERT INTO `file` (
`name`, `mime`, `size`, `data`, `created`
)
VALUES (
'{$name}', '{$mime}', {$size}, '{$data}', NOW()
)";

// Execute the query
$result = $dbLink->query($query);

// Check if it was successfull
if($result) {
echo 'Success! Your file was successfully added!';
}
else {
echo 'Error! Failed to insert the file'
. "<pre>{$dbLink->error}</pre>";
}
}
else {
echo 'An error accured while the file was being uploaded. '
. 'Error code: '. intval($_FILES['uploaded_file']['error']);
}

// Close the mysql connection
$dbLink->close();
}
else {
echo 'Error! A file was not sent!';
}

// Echo a link back to the main page
echo '<p>Click <a href="index.html">here</a> to go back</p>';
?>


list_files.php

<?php
// Connect to the database
$dbLink = new mysqli('localhost', 'root', 'pwd', 'myTable');
if(mysqli_connect_errno()) {
die("MySQL connection failed: ". mysqli_connect_error());
}

// Query for a list of all existing files
$sql = 'SELECT `id`, `name`, `mime`, `size`, `created` FROM `file`';
$result = $dbLink->query($sql);

// Check if it was successfull
if($result) {
// Make sure there are some files in there
if($result->num_rows == 0) {
echo '<p>There are no files in the database</p>';
}
else {
// Print the top of a table
echo '<table width="100%">
<tr>
<td><b>Name</b></td>
<td><b>Mime</b></td>
<td><b>Size (bytes)</b></td>
<td><b>Created</b></td>
<td><b>&nbsp;</b></td>
</tr>';

// Print each file
while($row = $result->fetch_assoc()) {
echo "
<tr>
<td>{$row['name']}</td>
<td>{$row['mime']}</td>
<td>{$row['size']}</td>
<td>{$row['created']}</td>
<td><a href='get_file.php?id={$row['id']}'>Download</a></td>
</tr>";
}

// Close table
echo '</table>';
}

// Free the result
$result->free();
}
else
{
echo 'Error! SQL query failed:';
echo "<pre>{$dbLink->error}</pre>";
}

// Close the mysql connection
$dbLink->close();
?>


get_file.php

<?php
// Make sure an ID was passed
if(isset($_GET['id'])) {
// Get the ID
$id = intval($_GET['id']);

// Make sure the ID is in fact a valid ID
if($id <= 0) {
die('The ID is invalid!');
}
else {
// Connect to the database
$dbLink = new mysqli('localhost', 'root', 'pwd', 'myTable');
if(mysqli_connect_errno()) {
die("MySQL connection failed: ". mysqli_connect_error());
}

// Fetch the file information
$query = "
SELECT `mime`, `name`, `size`, `data`
FROM `file`
WHERE `id` = {$id}";
$result = $dbLink->query($query);

if($result) {
// Make sure the result is valid
if($result->num_rows == 1) {
// Get the row
$row = mysqli_fetch_assoc($result);

// Print headers
header("Content-Type: ". $row['mime']);
header("Content-Length: ". $row['size']);
header("Content-Disposition: attachment; filename=". $row['name']);

// Print data
echo $row['data'];
}
else {
echo 'Error! No image exists with that ID.';
}

// Free the mysqli resources
@mysqli_free_result($result);
}
else {
echo "Error! Query failed: <pre>{$dbLink->error}</pre>";
}
@mysqli_close($dbLink);
}
}
else {
echo 'Error! No ID was passed.';
}
?>

I am not too sure where the error could be but I suspect that it could be somewhere at the add_file or get_file. Seriously hope someone could help me with this bug and thanks for the trouble.

Regards
Jasmine

Hey guys i have a problem,
I have a form to upload 2 image files  however sometimes i want to only upload the one file, but if i only upload one image, it tells me that it can't upload because there is no name for the second image.

I tried fixing it with if (isset($fieldname2))  however i just realised that $feildname2 is always set so im not quite sure how to fix?

Code: [Select]
($action == "add"){
$add = $_POST['add'];
$reference = $_POST['reference'];
$category = $_POST['category'];
$sub_cat = $_POST['sub_cat'];
$fieldname = 'file';
$fieldname2 = 'file2';
error_reporting(E_ALL);
ini_set('display_errors',1);
is_uploaded_file($_FILES[$fieldname]['tmp_name']);
getimagesize($_FILES[$fieldname]['tmp_name']);
if (isset($fieldname2)) {
is_uploaded_file($_FILES[$fieldname2]['tmp_name']);
getimagesize($_FILES[$fieldname2]['tmp_name']);
}
$now = time();
while(file_exists($uploadFilename = $uploadsDirectory.$_FILES[$fieldname]['name']))
{
    $now++;
}
if (isset($fieldname2)) {
while(file_exists($uploadFilename2 = $uploadsDirectory.$_FILES[$fieldname2]['name']))
{
    $now++;
}
}
move_uploaded_file($_FILES[$fieldname]['tmp_name'], $uploadFilename);
if (isset($fieldname2)) {
move_uploaded_file($_FILES[$fieldname2]['tmp_name'], $uploadFilename2);
}
$sqlname = $_FILES[$fieldname]['name'];
if (isset($fieldname2)) {
$sqlname2 = $_FILES[$fieldname2]['name'];
}
$id = mysql_insert_id();
$query = "INSERT INTO cakes (id, reference, category, sub_cat, image, image2) VALUES ('$id', '$reference', '$category', '$sub_cat','$sqlname','$sqlname2')";
$sql = mysql_query($query) or die (mysql_error());
}
echo("<form name='add' method='post' enctype='multipart/form-data' action='?action=add'>");
echo("<input type='hidden' name='MAX_FILE_SIZE' value='3000000");
echo("<input type='hidden' name='?action=add'>");
echo("<table class=main cellspacing=0 cellpadding=2 width=60%>");
echo("<tr><td>Reference: </td><td align='right'><input type='text' size=50 name='reference' value='$reference'></td></tr>");
echo("<tr><td>Category: </td><td align='center'><select name='category'><option>Occasional</option><option>Special</option><option>Figures</option><option>Novelty</option><option>Wedding</option></SELECT></td></tr>");
echo("<tr><td>Sub Category: </td><td align='center'><select name='sub_cat'><option></option><option>Birthday</option><option>Anniversary</option><option>Christmas</option><option>Christening</option><option>Valentine</option><option>Mothers Day</option><option>Fathers Day</option><option>Easter</option></select></td></tr>");
echo("<tr><td>Cake Image: </td><td align='center'><input id='file' type='file' name='file'></td></tr>");
echo("<tr><td>Cake Image 2: </td><td align='center'><input id='file2' type='file' name='file2'></td></tr>");
echo("Before uploading an image please resize the image to 290px x 218px");
echo("<tr><td></td><td><div align='right'><input type='Submit'></div></td></tr>");
echo("</table>");

Hi all,

I am working on a project where I need to monitor accounts and suspend features associated with them if their deposited balance runs out.

To do this I'm thinking it might be best to have a script running with an infinite loop that constantly refreshes but I'm not sure what kind of strain this might put on the server.

The pseudocode would look something like this:


while (1) {
  For each row in database {
    If balance <= 0 {
       mysql query - account_status = suspended
    }
  }
}

Please note (obviously) this is psuedocode and not actual code.

I'm just concerned about how I would stop this script timing out, and what kind of impact it would have on server performance?

Is there any better way to do this?

Happy to discuss,

dB

Hi all, creating a MYSQL, PHP & XHTML site designed to support local rugby clubs. Just putting the final touches to the functionality now so thanks for your help so far.

I would like to provide site administrators with the ability to assign photos to a members profile when initially registering their account, I have no experience of dealing with what presumably will be a function that will upload a photo to a location and then linking it some how to data in the database.

Thanks for your help,

Tom

Hi, I'm not sure if this is the right forum to post this question, but I'll still post it. I'm a newbie programmer, have 1 year experience of php, mysql and html and know how to make a basic website, but I've never actually uploaded the already written code on the internet.So my question is, if you use vertrigo serv and have folders full of php files, what do you do after getting a domain? I read that dreamweaver does that for you, but i also read that it is a closed source software with limitations if you get the free version.The other choice is using FileZilla(which I don't fully understand yet ) i presume.  

Hi All

I am trying to upload a csv file to a database using php html form however, the results shows none of the data passsing through to the database and it produces 1000's of empty fields

here is the form

Code: [Select]
form action="lib/import.php" method="post" enctype="multipart/form-data">

     Type file name to import:

      <input type="file" name="filename" size="20"><br />

      <input type="submit" name="submit" value="submit"></form>
and here is the passing info

Code: [Select]
$file = $_FILES['filename'];

$sqlstatement="LOAD DATA INFILE '$file' into TABLE shop FIELDS TERMINATED BY ',' (id, merchant_name, product_name, description, category_name, Affiliate_deep_link, Affiliate_image_url, price)" ;
mysql_query($sqlstatement);
echo "it is done!";
can anyone help please?

Hi Guys,

I am trying to use a script that is available on the net to upload an image into a mysql using BLOB.

However it wont upload it keep getting

Warning: fread() [function.fread]: Length parameter must be greater than 0 in /home/theacidf/public_html/attendance/upload.php on line 17

Here is the code...

<?php

// Connect to database

$errmsg = "";
if (! @mysql_connect("localhost","theacidf_admin","password")) {
        $errmsg = "Cannot connect to database";
        }
@mysql_select_db("theacidf_attendanc");

// Insert any new image into database

if ($_REQUEST[completed] == 1) {

        move_uploaded_file($_FILES['imagefile']['tmp_name'],"latest.img");
        $instr = fopen("latest.img","rb");
        $image = addslashes(fread($instr,filesize("latest.img")));
        if (strlen($image) < 149000) {
                mysql_query ("insert into pix (title, imgdata) values (\"".
                $_REQUEST[whatsit].
                "\", \"".
                $image.
                "\")");
        } else {
                $errmsg = "Too large!";
        }
}

// Find out about latest image

$gotten = @mysql_query("select * from pix order by pid desc limit 1");
if ($row = @mysql_fetch_assoc($gotten)) {
        $title = htmlspecialchars($row[title]);
        $bytes = $row[imgdata];
} else {
        $errmsg = "There is no image in the database yet";
        $title = "no database image available";
        // Put up a picture of our training centre
        $instr = fopen("../images/logo_png.png","rb");
        $bytes = fread($instr,filesize("../images/logo_png.png"));
}

// If this is the image request, send out the image

if ($_REQUEST[gim] == 1) {
        header("Content-type: image/jpeg");
        print $bytes;
        exit ();
        }
?>

<html><head>
<title>Upload an image to a database</title>
<body bgcolor=white><h2>Here's the latest picture</h2>
<font color=red><?= $errmsg ?></font>
<center><img src=?gim=1><br>
<?= $title ?></center>
<hr>
<h2>Please upload a new picture and title</h2>
<form enctype=multipart/form-data method=post>
<input type=hidden name=MAX_FILE_SIZE value=150000>
<input type=hidden name=completed value=1>
Please choose an image to upload: <input type=file name=imagefile><br>
Please enter the title of that pictu  <input name=whatsit><br>
then: <input type=submit></form><br>
<hr>

</body>
</html>

Why wont it run properly?

Thanks in advance...
S

Hey guys! I'm not that good with PHP, and I really need to finish this script. I'm having a hard time finding the problem..it keeps saying Error, query failed and I've also checked the database info, connectivity info and even tried a connection and database selection verification to see if that was working. Is there any other error you guys can find in the script that may be causing the message?

Edit: The files I want to be able to upload should be pdf's, txts, docs, etc. Would that be possible with this script?

Thanks!!

Code: [Select]
<form method="post" enctype="multipart/form-data">
<table width="350" border="0" cellpadding="1" cellspacing="1" class="box">
<tr>
<td width="246">
<input type="hidden" name="MAX_FILE_SIZE" value="104857600"></td>
<td width="80">&nbsp;</td>
</tr>
</table>
<p>Archivo:
  <input name="userfile" type="file" id="userfile" />
</p>
<p>Nomb
  <label for="name"></label>
 <input type="text" name="nombrelista" id="nombrelista" />
</p>
<p>Password (para luego borrar si necesario):
  <input type="text" name="pass" id="pass" />
</p>
<p>
  <input name="upload" type="submit" class="box" id="upload" value=" Upload " />
</p>

<?php
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$filePass = $_POST['pass'];
$nombreLista = $_POST['nombrelista'];



$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

$host_db = "localhost";
$user_db = "melkien_rudesa";
$pass_db = "jorlan2407";
$base_db = "melkien_rudesa";



$link = mysql_connect($host_db, $user_db, $pass_db);
if (!$link) {
    die('Could not connect: ' . mysql_error());
mysql_close($link); 
}

mysql_select_db($base_db, $link) or die(mysql_error());



if(!get_magic_quotes_gpc())
{
   $fileName = addslashes($fileName);
}


$query = "INSERT INTO 'upload'('nombrelista', 'name', 'pass', 'size', 'type', 'content' ) VALUES ('$nombreLista', $fileName', '$filePass', $fileSize', '$fileType', '$content')";


mysql_query($query) or die('Error, query failed'); 


echo "<br>File $fileName uploaded<br>";

mysql_close($link); 

}



?>


</form>

My code:

Code: [Select]
$rank =  implode(',', $ibforums->input['rank']);
echo $rank;
For that form, it will show:

'2,0,0'


Problem is, I need to update each row with each individual value, and is this possible with using  1 query?

Hello freaks!

Im new to this forum, but im not all that new to PHP and MySQL.
Although there's been some years since the last time I used it, so don't go all freaky on me if I dont do this right

Let's go on-topic:
Im in progress of making an internal web-page for me and my colleagues to make things a bit easier for us.
I am making an database of our different projects, and I need some help with the input form - as I need to upload an image to the server, and store the path in the MySQL database.

In my input form, I need to store information from text fields, and I need to upload an image to the server and store the path in the database.
Before I can even start to code this (although I have coded the input forum without the upload), I need to know what would be the best way to do this.
I guess there are several ways.. What would the expert do (That's you right?)?

Should I have the information input, and image upload in the same form, or should I make a second form (maybe on a different page) for the upload?
Is it necessary with two tables, one for the info and one for the image path, and then tie them together with the imageID, or is it fine to use just one table?

Any thoughts would be appreciated!

<!-- TechThat -->

Hello!

I want to make the users in the website able only to upload, for example, 1 GB, so that when a user finishes the 1 GB available for his files, he cannot upload more files.

I know how to set up upload limit for a single file in the upload page, or even globally for anyone to upload. But I would like to know how to make each user has specific capacity, and how it is updated so that if he uploads 0.5 GB he has only 0.5 GB left.

I thought of creating a column in the `users` or something concerning upload limit that I will set it (one GB for example). If I will do that, how will I be able to determine how much he uploaded?

Any help would be appreciated.

Thank you!

what's wrong with this ?  i can't upload

hi-
i'm trying to browse for a CSV file and then upload it to my mysql database. i found the code below and not working. i don't get any errors. the connection to the database is ok bcz i get the existing results but not the ones from the CSV file added to the db.. any ideas?

Code: [Select]
<?php 
ob_start();
require_once('../../connections/congif.php');
mysql_select_db($dbname, $db);
$sql_get_project="SELECT * 
 FROM gifts_tbl  
 ORDER BY autoID DESC 
 LIMIT 25";
$get_project = mysql_query($sql_get_project, $db) or die(mysql_error());
$row_get_project = mysql_fetch_assoc($get_project);

//database connect info here

//check for file upload
if(isset($_FILES['csv_file']) && is_uploaded_file($_FILES['csv_file']['tmp_name'])){

//upload directory
$upload_dir = "csv_dir/";

//create file name
$file_path = $upload_dir . $_FILES['csv_file']['name'];

//move uploaded file to upload dir
if (!move_uploaded_file($_FILES['csv_file']['tmp_name'], $file_path)) {

//error moving upload file
echo "Error moving file upload";

}

//open the csv file for reading
$handle = fopen($file_path, 'r');

//turn off autocommit and delete the product table
mysql_query("BEGIN");

while (($data = fgetcsv($handle, 1000, ',')) !== FALSE) {

//Access field data in $data array ex.
$name = $data[0];

//Use data to insert into db
$sql = sprintf("INSERT INTO gifts_tbl (player_id) VALUES ('%s)",
mysql_real_escape_string($name)
);
mysql_query($sql) or (mysql_query("ROLLBACK") and die(mysql_error() . " - $sql"));
}

unlink($file_path);
}
ob_flush();
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Gifts</title>
</head>

<body>
<h1>Testing for CSV upload</h1>

<form action="" method="post">
<input type="file" name="csv_file">
<input type="submit" name="csv_submit" value="Upload CSV File">
</form>


<h2>Results</h2>
<?php do { ?>
<ul>
<li><?php echo $row_get_project['player_id']; ?></li>
</ul>
<?php } while ($row_get_project = mysql_fetch_assoc($get_project)); ?>


</body>
</html>