Reload same page with new query

[seco]

Ok, so how would I go about reloading the page with a new query by a click of a link.

right now its loading everything from my table,

SELECT * FROM usr_img;

I want to be able to click a link and have the page reload with,

SELECT * FROM usr_img WHERE img_cat LIKE 'Birds';

Can anyone help me, im still learning php.

Thanks

[longbow486]

you have to have a link pointing to the same page and the script will pull the value that you had in the link to the var
EX:
<a href="script.php?like=bird">Birds</a>

and in the script just have

$like=$_GET['like'];
SELECT * FROM usr_img WHERE img_cat LIKE $like;

[seco]

Ok, i can see how that would work, but whenever i add the script to the page, it doesnt load the page, its just blank. any ideas why it would do this.

[longbow486]

could you post some of the script so that i can see how you implemented it?

thanks,
-Phil

[seco]

Here is the main php.

<?php require_once('Connections/phptoConn.php'); ?>
<?php

require_once('includes/tng/tNG.inc.php');

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_photoConn = 100;
$pageNum_photoConn = 0;
if (isset($_GET['pageNum_photoConn'])) {
  $pageNum_photoConn = $_GET['pageNum_photoConn'];
}
$startRow_photoConn = $pageNum_photoConn * $maxRows_photoConn;

mysql_select_db($database_phptoConn, $phptoConn);
$query_photoConn = "SELECT * FROM usr_img";
$query_limit_photoConn = sprintf("%s LIMIT %d, %d", $query_photoConn, $startRow_photoConn, $maxRows_photoConn);
$photoConn = mysql_query($query_limit_photoConn, $phptoConn) or die(mysql_error());
$row_photoConn = mysql_fetch_assoc($photoConn);

if (isset($_GET['totalRows_photoConn'])) {
  $totalRows_photoConn = $_GET['totalRows_photoConn'];
} else {
  $all_photoConn = mysql_query($query_photoConn);
  $totalRows_photoConn = mysql_num_rows($all_photoConn);
}
$totalPages_photoConn = ceil($totalRows_photoConn/$maxRows_photoConn)-1;

$queryString_photoConn = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_photoConn") == false && 
        stristr($param, "totalRows_photoConn") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_photoConn = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_photoConn = sprintf("&totalRows_photoConn=%d%s", $totalRows_photoConn, $queryString_photoConn);
?>

Im using MX Collection to create the repeat region.

Here is the code you gave me,

<?php
	 $like=$_GET['like']; 
                 "SELECT * FROM usr_img WHERE img_cat LIKE $like";
	 ?><a href="gallery1.php?like=Bathrooms">Bathrooms</a>

[longbow486]

gallery1.php page is going to show up blank because you arent connecting to a DB with the sql statement.
you have to do something like this to get an output:

<?php
include('/config/user.php');
$conn = mysql_connect('$sqlhost', '$sqluser', '$sqlpw');
mysql_select_db("$db",$conn);
$sqls = 'SELECT * FROM usr_img WHERE img_cat LIKE'. $like;
$result = mysql_query($sqls, $conn) or die(mysql_error());
while ($newArray = mysql_fetch_array($result))
{
    $testField = $newArray['img_cat'];
    echo $testField;
}
?>

[Horizon88]

I rewrote your code, this should work. And for god's sake, escape your inputs, guys! >:0

<?php 
require_once('Connections/phptoConn.php');
require_once('includes/tng/tNG.inc.php');

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_photoConn = 100;
$pageNum_photoConn = 0;
if (isset($_GET['pageNum_photoConn'])) {
  $pageNum_photoConn = $_GET['pageNum_photoConn'];
}
$startRow_photoConn = $pageNum_photoConn * $maxRows_photoConn;

mysql_select_db($database_phptoConn, $phptoConn);
// my main change is here
// checks if get[like] has been set, if it has, it includes it in a where statement
if (isset($_GET['like'])) {
   $like = 'WHERE img_cat LIKE '.mysql_real_escape_string($_GET['like']);
}
// otherwise blanks out the variable
else {
   $like = '';
}
// and appends it to your query
$query_photoConn = "SELECT * FROM usr_img".$like;

// this would yield:
// $query_photoConn = "SELECT * FROM user_img" . ' WHERE img_cat LIKE banana';
// if ?like=banana were passed, and:
// $query_photoConn = "SELECT * FROM user_img" . ''; (in effect) if ?like is not set

$query_limit_photoConn = sprintf("%s LIMIT %d, %d", $query_photoConn, $startRow_photoConn, $maxRows_photoConn);
$photoConn = mysql_query($query_limit_photoConn, $phptoConn) or die(mysql_error());
$row_photoConn = mysql_fetch_assoc($photoConn);

if (isset($_GET['totalRows_photoConn'])) {
  $totalRows_photoConn = $_GET['totalRows_photoConn'];
} else {
  $all_photoConn = mysql_query($query_photoConn);
  $totalRows_photoConn = mysql_num_rows($all_photoConn);
}
$totalPages_photoConn = ceil($totalRows_photoConn/$maxRows_photoConn)-1;

$queryString_photoConn = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_photoConn") == false &&
        stristr($param, "totalRows_photoConn") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_photoConn = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_photoConn = sprintf("&totalRows_photoConn=%d%s", $totalRows_photoConn, $queryString_photoConn);
?> 

Edit: you just beat me 😛

[seco]

would it be better for me to not use the mx collection code and just do a simple db connect, query and repeat region?

[seco]

Horizon,

I get this now,

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE Bathrooms LIMIT 0, 100' at line 1

[Horizon88]

Whoops, needs a space.

Change

if (isset($_GET['like'])) {
   $like = 'WHERE img_cat LIKE '.mysql_real_escape_string($_GET['like']);
} 

to

if (isset($_GET['like'])) {
   $like = ' WHERE img_cat LIKE '.mysql_real_escape_string($_GET['like']);
} 

(Space in front of WHERE)

[seco]

Ok, the page loads now. but when i click the link,

<a href="gallery1.php?like=Bathrooms">Bathrooms</a>

i get,

Unknown column 'Bathrooms' in 'where clause'

Is this not going to work with a repeat region?

here is the site.

http://www.itecenterprises.com/gallery.php

[seco]

I resolved this problem with the use of javascript and hide/show Divs