[RESOLVED] problem in php sql querry please help

meddycool

i have a php page that execute a sql querry to protect a download link
like u r download link is this

www.domain.com/folder/songs.mp3

now it convert like this

www.domain.com/jump.php?id=2

the jump.php page contain

~~~ ( begin code ) ~~~
<?php
$id = htmlspecialchars($_GET['id'], ENT_QUOTES);

$db_name = "yourdatabasename";
$table_name = "redirects";

$cnx = mysql_connect("localhost", "yourdatabasename", "yourpassword")
or die("Couldn't connect.");

$db = mysql_select_db($db_name, $cnx)
or die("Couldn't select database.");

$sql = "SELECT id, address FROM $table_name
WHERE id = '$id'";

$result = mysql_query($sql,$cnx)
or die("Couldn't execute query.");

while ($row = @mysql_fetch_array($result)) {
$id = $row["id"];
$address = $row["address"];
}

header("location: $address");
?>

~~~ ( end code ) ~~~

and the sql querry for this is

CREATE TABLE redirects ( id mediumint(8) unsigned NOT NULL auto_increment, address varchar(200) NOT NULL, label varchar(60) NOT NULL, PRIMARY KEY (id), KEY id (id, address), UNIQUE id_2 (id));

after that u have to insert url or lable in redirects table through sql querry.

now when i m going to click on a url of jum.php

it will display a error
Couldn't execute query. :xbones:

can someone help me to solve it

Weedpacket

meddycool wrote:
can someone help me to solve it

Change

or die("Couldn't execute query.");

or die("Couldn't execute query: ".mysql_error());

and use the error message that's given.

djjjozsi

i commented/changed your code a little.
where you see [your]database,password,.....ect you must change them into your values

<?php

if(empty($_GET['id']))
die("No data");

$id = (int)$_GET['id'];  
//you're waiting just a number/integer, use the (int) cast to convert the data into integer

$db_name = "yourdatabasename";  //you have to change this into your database name
$table_name = "redirects";   // this is the table, where you store the url's

$cnx = mysql_connect("localhost", "yourdatabasename", "yourpassword")   //this is the connection to the database
or die("Couldn't connect. ".mysql_error());

$db = mysql_select_db($db_name, $cnx)
or die("Couldn't select database. ".mysql_error());

$sql = "SELECT id, address FROM $table_name
WHERE id =".$id; 

$result = mysql_query($sql) or die("Couldn't execute query.".mysql_error());

if(mysql_num_rows($result)==1) //if you have a result
{
	//	if you're waiting one result, don't need to use a while
	$row = mysql_fetch_assoc($result);  //assoc gives you the field's name in an array
	//$id = $row["id"];  //this is not necessary if you don't use that
	$address = $row["address"];
}
header("location: $address");
?>

meddycool

djjjozsi

thanks man i love you its working now
😃😃😃

thax u soo much

phpbuilder is really great

thax🙂😃

djjjozsi

Hello,

Not at all 🙂

meddycool

djjjozsi

can u help me in one more thing
i need a code that will get a upload from users in my website or got store in a particular folder

upload file is in any format like movie , .zip , image etc

or will display after upload in a particular page

djjjozsi

You can see this step by step tutorial:

http://php.about.com/od/advancedphp/ss/php_file_upload.htm

After creating this, make a file list.

<?

/**
* Change the path to your folder.
*
* This must be the full path from the root of your
* web space. If you're not sure what it is, ask your host.
*
* Name this file index.php and place in the directory where the users upload.
*/

// Define the full path to your folder from root
$path = "full path to folder";

// Open the folder
$dir_handle = @opendir($path) or die("Unable to open $path");

// Loop through the files
while ($file = readdir($dir_handle)) {

if($file == "." || $file == ".." || $file == "index.php" )

continue;
echo "<a href=\"$file\">$file</a><br>&gt;";

}

// Close
closedir($dir_handle);

?>

meddycool

helo dijjjozsi

can i change the name of this file index.php
because index.php is already exist in my directory

hey and what about the display page???
A page which contain the file after upload

bradgrafelman

The code dijjjozsi posted lists the files in the path you specify; the "index.php" in the if() statement is simply there to exclude it from the listing.

djjjozsi

hi,
lets see that tutorial, and in the 5. section(Putting It Together) you can see the results page.
You have to change this line to make a direct link to the uploaded file.

echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded"; 
echo '';

But you must keep this script in your control,
so i recommend you to read the Final Thoughts part,
and the "security as possible" link.

Hello,
jjozsi

meddycool

hi djjjozsi

hey when i an going throgh these steps of upload that provided by you

i got this error when i click on upload button

Notice: Undefined variable: uploaded_size in /www/oxyhost.com/m/y/h/myhotspot/htdocs/upload/upload.php on line 7

Notice: Undefined variable: uploaded_type in /www/oxyhost.com/m/y/h/myhotspot/htdocs/upload/upload.php on line 14

Warning: move_uploaded_file(upload/jumbo.jpg) [function.move-uploaded-file]: failed to open stream: No such file or directory in /www/oxyhost.com/m/y/h/myhotspot/htdocs/upload/upload.php on line 29

Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phpqJfHLR' to 'upload/jumbo.jpg' in /www/oxyhost.com/m/y/h/myhotspot/htdocs/upload/upload.php on line 29
Sorry, there was a problem uploading your file.:xbones::xbones::xbones:

?????:quiet:

djjjozsi

Hello,

Yes, you're right, it has mistakes.

Here is the modificated version below, and if you want to see the modifications,
here is a video about it:

http://phptool.extra.hu/tutorials/troubleshooting_111/troubleshooting_111.php

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

if(!empty($_FILES))
{
	$target = "upload/";
	$target = $target . basename( $_FILES['uploaded']['name']) ;
	$ok=1;
	$uploaded_size = $_FILES['uploaded']['size'];
	$uploaded_type=$_FILES['uploaded']['type'];
	//This is our size condition
	if ($uploaded_size > 5000000)
	   {
	   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 "The file ". basename( $_FILES['uploaded']['name']). " has been uploaded";
		}
		else
		{
			echo "Sorry, there was a problem uploading your file.";
		}
	}
}
?>

meddycool

hey thax

its working fine now🙂😃

meddycool

djjjozsi

another problem 🙂

when i am going to open the index.php page which is in that directly where i upload all file it show an error

Unable to open /upload

what this??
u gave me the index.php code ........see prevoius post

djjjozsi

hello,
in the file listing program:
if your upload folder located for example in wwwroot/my_site/program/ then you have to
set this folder from the root folder like this:

// Define the full path to your folder from root
$path = "wwwroot/my_site/program/upload";

Hello,
jjozsi.

meddycool

again the same error

unable to open

i have pass the full path

bradgrafelman

Can you show us the "full path" that you tried?

meddycool

yeah sure

// Define the full path to your folder from root
$path = "www.myhotspot.oxyhost.com/upload";

bradgrafelman

That's not a full local path, that's part of a URL.

A full path would look something like /home/myUsername/public_html/upload/ (just an example - it varies widely from server to server). Check out $_SERVER['DOCUMENT_ROOT'] to get the "full path" to the root of your website.

meddycool

bradgrafelman

cant get you man
please write in detail what do i do???