PHP - Php Download Script For Downloading Mp3's From Mysql Database Not Working

Hi,
Im just in the middle of creating an update script for my mysql database but don't know why it's not working. p.s. I'm a little new to PHP, but know quite a bit, it's probably something really small.. *facepalm*

Here's the script:

the form (update.php)
<?
// Connect to the database
$link = mysql_connect('###', '###', '###');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('###', $link);

$id = $_GET['id'];

// Ask the database for the information from the links table
$query="SELECT * FROM orders WHERE id='$id'";
$result = mysql_query("SELECT * FROM orders");
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num) {
$name=mysql_result($result,$i,"Name");
$location=mysql_result($result,$i,"Location");
$fault=mysql_result($result,$i,"Fault");

?>

<form action="updated.php" method="post">
<input type="hidden" name="ud_id" value="<? echo "$id";?>">
Name: <input type="text" name="ud_name" value="<? echo "$name"?>"><br>
Location: <input type="text" name="ud_location" value="<? echo "$location"?>"><br>
Fault: <input type="text" name="ud_fault" value="<? echo "$fault"?>"><br>

<input type="Submit" value="Update">
</form>

<?
++$i;
}
?>

------------------------------------------------------
(processor) updated.php

<?php
// Connect to the database
$link = mysql_connect('###', '###', '###');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('###', $link);

$query="UPDATE orders SET Name='" . $_POST['ud_name'] . "', Location='" . $_POST['ud_location'] . "', Fault='" . $_POST['ud_fault'] . "' WHERE $id='" . $_POST['ud_id'] . "'";
echo $query;
$checkresult = mysql_query($query);
if ($checkresult) echo '<p>update query succeeded';
else echo '<p>update query failed';

mysql_close();
?>


------------------------------------------------------

Every time I want to update, it comes up with:

UPDATE orders SET Name='TEST', Location='TEST', fault='jbjh' WHERE =''
update query failed

Any help would be appreciated.

Is there an alert method for the MySQL database or something similar?   What is the proper way to check if the MySQL database connection is working?   I mean other than "creating" and "retrieving" with "insert" and "select".

$day = $_POST['day'];
$month = $_POST['month'];
$year = $_POST['year'];

$date = date("Y-m-d", time(0,0,0,$month, $day, $year));

$sql="INSERT INTO child_info (first_name,middle_name,first_family_name,second_family_name, gender,birthdate,mother_living,father_living,brothers,sisters,resident_time,dorm,school,grade_level,school_subject,speak_english,food,medical_allergies,physical_limits,future,instrument,work,social,special_people,hobby,sponsor)
VALUES
('$_POST[first_name]','$_POST[middle_name]','$_POST[first_family_name]','$_POST[second_family_name]','$_POST[gender]','$_POST[date]','$_POST[mother_living]','$_POST[father_living]','$_POST[brothers]','$_POST[sisters]','$_POST[resident_time]','$_POST[dorm]','$_POST[school]','$_POST[grade_level]','$_POST[school_subject]','$_POST[speak_english]','$_POST[food]','$_POST[medical_allergies]','$_POST[physical_limits]','$_POST[future]','$_POST[instrument]','$_POST[work]','$_POST[social]','$_POST[special_people]','$_POST[hobby]','$_POST[sponsor]')";

hi i am having a problem with a php script. i have 3 files index.php,  home.html.php, form.html.php.
home.html.php is working fine, if has a form that is submitting fine but when it submits i get a problem. maybe someone can help me out please i would be grateful as i am new. the is nothing wrong with anything else mysql database is running fine and there is no problem with connection.

index.php (you can ignore what is commented out)

<?php
 include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
 //$_GET['id'] is categoryid
if (isset($_GET['id']))
{
   include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';

   $id = mysqli_real_escape_string($link, $_GET['id']);
   $sql = "SELECT businessid FROM businesscategory WHERE
          categoryid LIKE '$id'";   
  $result = mysqli_query($link, $sql);
  if ($result !='')
  {
   $businessid = mysqli_fetch_array($result);
  $sql = "SELECT content FROM business WHERE
          id LIKE '$businessid'"; 
  $result = mysqli_query($link, $sql); 
  }
  if ($result !='') 
  {
  $content = mysqli_fetch_array($result);
  include 'form.html.php';
   exit();
  }
} 

/*
   // The basic SELECT statement
   $select = 'SELECT content';
   $from   = ' FROM business';
   $where  = ' WHERE TRUE';

   $id =  mysqli_real_escape_string($link, $_GET['id']);
   if ($category != '') // An owner is selected
   {
      $where .= " AND categoryid='$categoryid";
   }

   $categoryid =  mysqli_real_escape_string($link,
         $_GET['category']);
   if ($categoryid != '') // A category is selected
   {
      $from  .= ' INNER JOIN businesscategory ON id = business';
      $where .= " AND categoryid='$categoryid'";
   }

   $text = mysqli_real_escape_string($link, $_GET['text']);
   if ($text != '') // Some search text was specified
   {
      $where .= " AND content LIKE '%$text%'";
   }

   $result = mysqli_query($link, $select . $from . $where);
   if (!$result)
   {
      $error = 'Error fetching businesses.';
      include 'error.html.php';
      exit();
   }

   while ($row = mysqli_fetch_array($result))
   {
      $businesses[] = array('id' => $row['id'], 'text' => $row['content']);
   }

   include 'form.html.php';
   exit();
} 
 
  */
 
 
 
 
 
 
$result = mysqli_query($link, 'SELECT id, name FROM category ORDER BY name');
if (!$result)
{
   $error = 'Error fetching categories: ' . mysqli_error($link);
   include 'error.html.php';
   exit();
}

while ($row = mysqli_fetch_array($result))
{
   $categories[] = array('id' => $row['id'], 'text' => $row['name']);
}

include 'home.html.php';
?>

form.html.php

<?php include_once $_SERVER['DOCUMENT_ROOT'] .
      '/includes/helpers.inc.php'; ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
  <meta http-equiv="content-type" content="text/html; charset=windows-1250">
  <meta name="generator" content="PSPad editor, www.pspad.com">
  <title>Business</title>
  </head>
  <body>
       it works
       <?php echo $content; ?>
  </body>
</html>

Hi
I don't know exactly what to do to see correct date of birth into my sql database.  I have following code i.e.
$month=$_POST['month'];
$year=$_POST['year'];
$date=$_POST['date'];
$date_value="$month/$date/$year";
echo"YYYY-mm-dd format:$date_value";

and sql insert statement is like this
$sql = "INSERT INTO table_name(fname, lname, gender, add1, add2, city, state, zip, country, email, phone, cellphone, dob, photo1)
VALUES('$fname','$lname','$gender','$add1','$add2','$city','$state','$zip','$country','$email','$phone','$cellphone',
'$date_value','" . $image['name'] . "')";

I don't know what exactly I need to do?  Even though I changed the setting in php ini  to register_globals = On
I would appreciate any kind of help regarding this matter.
Thanks
Smita

Hi there,

I am using this code to send the users email address to the database. That works fine, but i keep getting blank info added to the database. Does anyone know how i can stop this?

<?php
$con = mysql_connect("*","*","*");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("ogs_mailinglist1", $con);

$sql="INSERT INTO mailinglist (email)
VALUES
('$_POST[rec_email]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }

mysql_close($con);
?>



Thanks,

Hello. i am writing an API for lua... that sends POST requests to a php script. this php script is malfunctioning. below is the code and error.

After spending 3 days on internet and struggling with so many different forums , i have found this forum where i believe i will get the solution for my problem.

Friends, I am zero in PHP, but still i have managed to do something to fulfill my requirement.

I am stuck with one thing now..So i need help on....

I am using one html+php form to submit database into mysql.
I created a display of that table through php script on a webpage.
Now i want a datepicker option on that displayed page by which i should able to select the date range and display the data of that date range from my mysql table.
And then take a export of data displayed of selected date range in excel.

This displayed page is login protected, so i want after login the next thing comes in should show a sate selection option which should be fromdate to to date , and then records should displayed from the database and i can take export of those displayed results in excel file.
The code i am using on this page is below which do not have any thing included for excel export and datepicker script, I am pasting the code here and request you to please include the required code in it as required.

Thanks In advance

    <?php
    //database connections
    $db_host = 'localhost';
    $db_user = '***********';
    $db_pwd = '*************';
   
    $database = 'qserves1_uksurvey';
    $table = 'forms'; 
    $file = 'export';
    if (!mysql_connect($db_host, $db_user, $db_pwd))
        die("Can't connect to database");
   
    if (!mysql_select_db($database))
        die("Can't select database");
   
    // sending query
    $result = mysql_query("SELECT * FROM {$table} ORDER BY date desc");
    if (!$result) {
        die("Query to show fields from table failed");
    }
    $num_rows = mysql_num_rows($result);
    $fields_num = mysql_num_fields($result);
   
    echo "$num_rows";
    echo "<h1></h1>";
    echo "<table border='1'><tr>";
    // printing table headers
    for($i=0; $i<$fields_num; $i++)
    {
        $field = mysql_fetch_field($result);
        echo "<td>{$field->name}</td>";
    }
    echo "</tr>\n";
    // printing table rows
    while($row = mysql_fetch_row($result))
    {
        echo "<tr>";
   
        // $row is array... foreach( .. ) puts every element
        // of $row to $cell variable
        foreach($row as $cell)
            echo "<td>$cell</td>";
   
        echo "</tr>\n";
    }
    mysql_free_result($result);
    ?>
    </body></html>

I wish to have a page that will display a form if there aren't already enough registrations in the database. The following it an outline of how it will be:

<?php
require_once "../scripts/connect_to_mysql.php";                        //this works fine


// Count how many records in the database
(1) $sqlCommand = "SELECT * FROM teams"; 
(2) $sqlCommand = "SELECT COUNT (*) FROM teams";
(3) $sqlCommand = "SELECT COUNT (id) FROM teams";
$query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error());
(1) $numRegistrations = mysql_num_rows($query); //Count how many rows are returned from the query above
(2) $numRegistrations = $query
(3) $numRegistrations = mysql_num_rows($query);

mysqli_free_result($query);
?>
(Some HTML code, like DOCTYPE, head, start of body tags)
<?php
if($numRegistrations > 35){
echo "Sorry, registrations for this event is at it's maximum.";
}else{
?>

<form blah blah blah>

</form>

<?php
}
?>

(end of body and html tag)



You'll see above there is (1), (2), (3). These are the main 3 that I've been trying, and they match up the $sqlCommand to the $numRegistrations.

What would be the problem with this code? I use wamp server to test, have been using it for ages. Chrome browser to test in.
If I remove the database query, the rest of the page will load.
With the query in there, only the HTML code up until the database query is parsed, so therefore nothing is display on the page.

Please help.

Thanks
Denno

I have dozens of tables that a client needs to download through the web. I can use PHP to convert the tables within the database to a CSV however I have to split the files into 10k result chunks otherwise the server gets overloaded with memory.

I already raised the memory limit within the script that is downloaded (ini_set('memory_limit', '512M') which is able to make this happen.

Downloading these files piece by piece is a really time consuming. Is there a memory safe and efficient way to combine all my tables as CSV's and into one zip them into one master download? PHPMyAdmin seems to do this smoothly, however, I need an online interface for the client to export the data directly...

Hi All,

I've searched long and hard accross the web for an answer to this and finnally given in and requesting help. Here's what i have, i have a database setup and working fine. What i would like to do is for an administrator to be able to update my users details. It may sound odd, why don't you let your users update their own details? Well the administrators are dispatchers if you like, and my users are the 'dispatchees', for want of a better word. So i would like my administrators to be able to dispatch my users with routes and my users be able to see the routes that have been dispatched to them. I've setup a login area and a page that pulls there routes off the database, depending on their login details, i.e. jack will see his routes and jill will see her's independantly. This works by me editing the appropriate columns/rows of my database using phpmyadmin. What i'd like now is for administrators (who are directed to a seperate page, with more controls) to be able to do the same as me (updating the database) but by using a php form/script.

I'd like to be able to select the routes from a second table on the same database if possible, to try and keep everything tidy. So my dispatcher would select Route001 from a drop down list, this would fill in the text fields next to the route field with From To, so my dispatcher would know what route001 actually is from/ too, choose a username (now being driven from my other table) and hit dispatch. My user would login to their area, hit view dispatched routes and it would display Route 001 with the correct information.

The login area was a downloaded script i modified to suit and is called Login-Redirect_v1.31_FULL

Many thanks in advance, hope you can sort of understand what i want 

Josh

PHP/MySQL ability:Novice

create table mimi (mimiId int(11) not null, mimiBody varchar(255) );
<?php
//connecting to database
include_once ('conn.php');
$sql ="SELECT mimiId, mimiBody FROM mimi";

$result = mysqli_query($conn, $sql );

$mimi = mysqli_fetch_assoc($result);

$mimiId ='<span>No: '.$mimi['mimiId'].'</span>';

$mimiBody ='<p class="leading text-justify">'.$mimi['mimiBody'].'</p>';
?>
//what is next?

i want to download pdf or text document after clicking button or link how to do that

Hi Guys,

I'm putting together a project which requires members of a site to upload files(mostly word files) into a mysql db.
I can get the files uploaded successfully but when it comes to downloading them i do have a bit of trouble. When i click on the download link i just get a file called 'download.php' instead of the actual file in the database.

I have been working on this link for the past two weeks and think maybe its time for some help, here's my code if you wouldn't mind having a look?




upload.php:

<?php

session_start();

?>

<html>
<head>

<link href="default.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
<!-- start header -->
<div id="header">
   
</div>

<div id="menu">
   <ul>
      <li><a href="#">Home</a></li>
      <li><a href="member.php">Member</a></li>
      <li><a href="logout.php">Log Out</a></li>
   </ul>
</div>


<div id = "content">
   
      <form method="post" enctype="multipart/form-data"/>
      <input type="hidden" name="MAX_FILE_SIZE" value="2000000"/>
      <input name="userfile" type="file" id="userfile"/>
      <input type="submit" name="upload1"  id="upload1" value=" Upload "/>
      </form>
</div>
   <?php
if(isset($_POST['upload1']) && $_FILES['userfile']['size'] > 0)
{

$connect = mysql_connect ("localhost","root","") or die ("Couldn't connect!");
mysql_select_db("upload") or die ("Couldn't find db");

$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];

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

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

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

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


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

   <div id = "nav">
   </br>
   <a href = "upload.php"><img src = "images\add-itemGreen.gif"/></a><b>Upload</b></br>
   </br>
   <a href = "download.php"><img src = "images\download.gif"/></a><b>Download</b></br>
   </br>
   <a href = "discussion.php"><img src = "images\chat-.gif"/></a><b>Discussion Board</b></br>
   </div>


<div id="footer">

</div>
</body>
</html>




View.php:
<?php
ini_set('display_errors', E_ALL);
//include "open_db.inc";
 
$connect = mysql_connect ("localhost","root","") or die ("Couldn't connect!");
mysql_select_db("upload") or die ("Couldn't find db");
 
$sql = "SELECT * FROM upload ";
$sql .= "ORDER BY name ASC";
$result = mysql_query($sql, $connect);
$rows = mysql_num_rows($result);
 
echo "<table>\n";
echo " <tr>\n";
echo "  <td>id</td>\n";
echo "  <td>name</td>\n";
echo "  <td>type</td>\n";
echo "  <td>size</td>\n";
echo "  <td>Description</td>\n";
echo "  <td> </td>\n";
echo " </tr>\n";
 
while ($rows = mysql_fetch_object($result))
  {
  echo " <tr>\n";
  echo "  <td>$rows->id</td>\n";
  echo "  <td>$rows->name</td>\n";
  echo "  <td>$rows->type</td>\n";
  echo "  <td>$rows->size</td>\n";
  echo "  <td>" . stripslashes($rows->description) . "</td>\n";
  echo "  <td>( <a href='download.php?id=$rows->id'>Download</a> )</td>\n";
  echo " </tr>\n";
 
  }
 
mysql_free_result($result);
mysql_close($connect);
?>



download.php:
<?php
ini_set('display_errors', E_ALL);
if (isset($_GET['id']))
 {
 $id_files = $_GET['id'];
// include "open_db.inc";
$connect = mysql_connect ("localhost","root","") or die ("Couldn't connect!");
mysql_select_db("upload") or die ("Couldn't find db");

  $sql = "SELECT id, name, type, size, content FROM upload WHERE id=$id";
 
  $result = @mysql_query($sql, $connect);
  $dataT = @mysql_result($result, 0, "bin_data");
  $name = @mysql_result($result, 0, "name");
  $size = @mysql_result($result, 0, "type");
  $type = @mysql_result($result, 0, "size");
 
  header("Content-type: $type");
  header("Content-length: $size");
  header("Content-Disposition: attachment; name=$name");
  header("Content-Description: PHP Generated Data");
  header("Content-transfer-encoding: binary");
  echo $dataT;
}
else
{
echo 'id_files not set';
 
}
?>


I'm thinking that it could be something to do with the bin_data on the download.php page.
Any help would be great.

Thanks

Hi PHP freaks!!   I have manage to make a script to upload file in database and its working. I will share to you the codes so for other viewers and readers to use also.

if($result){
			if($_FILES['LRCard']['name'] != ""){
				$filename = $_FILES['LRCard']['name'];
				$ext = strrchr($filename,".");
				$LRCardname = $student_id;
				$LRCardname .="_". $filename; 
				if($ext ==".jpg" || $ext ==".jpeg" || $ext ==".JPG" || $ext ==".JPEG" || $ext ==".gif" || $ext ==".GIF"){
					$size = $_FILES['LRCard']['size'];
					if($size > 0 && $size < 5000000){
						$archive_dir = "LRCards";
						$userfile_tmp_name = $_FILES['LRCard']['tmp_name'];
						if(move_uploaded_file($userfile_tmp_name, "$archive_dir/$LRCardname")){
							/*
								if LRC is successfully uploaded then LRC is stored in database.
							*/
							mysql_query("update student_information set LRCard='$LRCardname' where student_id='$student_id'", $link_id); 
							$flag = "success"; 
							if(mysql_error()!=null){
								die(mysql_error());
							}

						}
						else{
							if(file_exists('LRCard/' . $LRCardname)) {
								unlink('LRCards/' . $LRCardname); 
							}
							rollbackData();
						}
					}
					else{
						if(file_exists('LRCards/' . $LRCardname)) {
							unlink('LRCard/' . $LRCardname); 
						}
						rollbackData();
						die("You can upload LRCard of 5 MB size only. Please, try again.");
					}
				}
				else{
					if(file_exists('LRCards/' . $LRCardname)) {
						unlink('LRCards/' . $LRCardname); 
					}
					rollbackData();
					die("You can upload LRCard of .jpg, .jpeg, .gif extensions only. Please, try again. ");
				}
			} 	
		}
		else{
			$flag="error";
		}
		if($flag == "success"){
			mysql_query(" COMMIT ");
			$flag="success";
			if(mysql_error() != null){
				die(mysql_error());
			}
	    }

Now, my problem is how to make a Php script to DOWNLOAD this uploaded file considering the 1. file path 2. file name 3. file extension. 4. student_id (to determine the specific file from a specific student)   My plan is to make a download button which hyperlink to download.php and after clicking that button the specified file to a specific student id will automatically be downloaded by the browser.