PHP and MySQL

SP8600

Hi, i need to get certain feilds from a MySQL database with numbers in however i need to be able to only get the feilds with the value upto 10000, 10000 to 50000 and so on.

The value needs to be set in a variable so that i can dynamicly change it via the address bar.

Does any one know how to do this.

Thanks for any help.

AQHost

Hi,

That shouldn't be too difficult. Just pass over two variables in the address (let's call them minval and maxval) and do this:

// Check that the values of minval and maxval are numeric
// Alter the 1, 15 to the min and max number of digits minval and maxval are allowed to have
if ((!ereg("^[0-9]{1,15}$", $_GET[minval)) || (!ereg("^[0-9]{1,15}$", $_GET[maxval)))
{
   echo "Invalid input data";
   exit;
}
// This assumes you've created a connection to the DB with handler $connection
$query = "SELECT * FROM table_name WHERE ((field_name >= $_GET[minval]) AND (field_name <= $_GET[maxval]))";
$result = mysql_query($query, $connection);

Best wishes,
Simon.

SP8600

If i do the code like this

// Check that the values of minval and maxval are numeric
// Alter the 1, 15 to the min and max number of digits minval and maxval are allowed to have
if ((!ereg("^{[0-9]{1,15}$",} $GET['minval'])) ||
(!ereg("^{[0-9]{1,15}$",} $GET['maxval'])));
{
echo "Invalid input data";
exit;
}

And

$sqlquery = "SELECT * FROM properties WHERE country = '$country' or id = '$id' AND ((field_name >= $GET[minval]) AND (field_name <= $GET[maxval]))";

And the address is

?country=uk&id=&minval=10&maxval=10000000

It just outputs the Invalid input data. SO how can i fix this.

AQHost

Hi,

For some reason you have a ; at the end of the if statement....

Best wishes,
Simon.

SP8600

Even if i take the ; away it still only shows the errors
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wwwroot\pp\showprops.php on line 22
There were no properties found.
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\wwwroot\pp\showprops.php on line 32
as the output and not the information. Here is the full code below to see if you can spot the error. The address is the same again - ?country=uk&id=&minval=10&maxval=1000000. Thanks.

<?php

include("vars.php");

mysql_connect ("$db_host", "$db_username", "$db_password") or die("Unable to connect to database");

@mysql_select_db("$db_name") or die("Unable to select database $db_name");

// Check that the values of minval and maxval are numeric
// Alter the 1, 15 to the min and max number of digits minval and maxval are allowed to have
if ((!ereg("^{[0-9]{1,15}$",} $GET['minval'])) ||
(!ereg("^{[0-9]{1,15}$",} $GET['maxval'])))
{
echo "Invalid input data";
exit;
}

$sqlquery = "SELECT * FROM properties WHERE country = '$country' or id = '$id' AND ((field_name >= $GET[minval]) AND (field_name <= $GET[maxval]))";

$result = mysql_query($sqlquery);

if(mysql_num_rows($result)<1){
echo "There were no properties found. "; } else { while($row = mysql_fetch_array($result)) {
echo "

Thumbnail URL:<a href=\"showprops.php?country=&id=".$row["id"] ."\"><img src=\"".$row["thumbnail"] ."\"></a> Country/State:".$row["country"] ." Location:". $row["location"]. " Price:". $row["currency"]. "". $row["price"]. " Address:". $row["address"]. " Image 1:".$row["img1"] ." Image 2:".$row["img2"] ." Image 3:".$row["img3"] ." Image 4:".$row["img4"] ." Information:". $row["info"]. "

";
}
}

mysql_free_result($result);

?>

AQHost

Ok, to start with try this simplified version:

<?php
if ((!ereg("^[0-9]{1,15}$", $_GET['minval'])) || (!ereg("^[0-9]{1,15}$", $_GET['maxval'])))
{ 
	echo "Invalid input data"; 
	exit; 
}
else
{
	echo "Good data";
}
php?>

I've tested this at the following URL:

http://www.aqhost.com/test.php?country=uk&id=&minval=10&maxval=10000

Let me know what result you get.

Best wishes,
Simon.

SP8600

With that code i am getting

Good data
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wwwroot\pp\showprops.php on line 23
There were no properties found.

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\wwwroot\pp\showprops.php on line 33

AQHost

Ok, you're not actually making a connection to the database properly (sorry, should have noticed this after your last post)......

<?php 

include("vars.php"); 

$connection = mysql_connect($db_host, $db_username, $db_password) or die("Unable to connect to database"); 

@mysql_select_db($db_name, $connection) or die("Unable to select database $db_name"); 

// Check that the values of minval and maxval are numeric 
// Alter the 1, 15 to the min and max number of digits minval and maxval are allowed to have 
if ((!ereg("^[0-9]{1,15}$", $_GET['minval'])) || 
(!ereg("^[0-9]{1,15}$", $_GET['maxval']))) 
{ 
echo "Invalid input data"; 
exit; 
} 

$sqlquery = "SELECT * FROM properties WHERE country = '$country' or id = '$id' AND ((field_name >= $_GET[minval]) AND (field_name <= $_GET[maxval]))"; 

$result = mysql_query($sqlquery, $connection); 

if(mysql_num_rows($result)<1){ 
echo "<font face=Arial size=+0><b>There were no properties found.</b></font><br>"; } else { while($row = mysql_fetch_array($result)) { 
echo " 

<font face=arial size=-1><p><b>Thumbnail URL:</b><a href=\"showprops.php?country=&id=".$row["id"] ."\"><img src=\"".$row["thumbnail"] ."\"></a><br><b>Country/State:</b>".$row["country"] ."<br><b>Location:</b>". $row["location"]. "<br><b>Price:</b>". $row["currency"]. "". $row["price"]. "<br><b>Address:</b>". $row["address"]. "<br><b>Image 1:</b>".$row["img1"] ."<br><b>Image 2:</b>".$row["img2"] ."<br><b>Image 3:</b>".$row["img3"] ."<br><b>Image 4:</b>".$row["img4"] ."<br><b>Information:</b>". $row["info"]. "</p> 

"; 
} 
} 

mysql_free_result($result); 
?>

Best wishes,
Simon.

SP8600

Even with that last code it still keeps bringing this up

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wwwroot\pp\showprops.php on line 22
There were no properties found.

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\wwwroot\pp\showprops.php on line 32

SP8600

Thanks for all your help. I have it working now. 🙂

But one last thing how can i have it so that i can have a , in here if ((!ereg("^{[0-9]{1,15}$",} $_GET['minval'])) || or can that not be done or is there to much more coding for it.

AQHost

Hi,

Nope, no nasty coding required:

if ((!ereg("^[0-9,]{1,15}$", $_GET['minval'])) || (!ereg("^[0-9,]{1,15}$", $_GET['maxval'])))

Glad this all worked out!
Simon.