PHP - Sqlstate[hy093]: Invalid Parameter Number: Parameter Was Not Defined

I have a pagination class that uses PHP_SELF to display the proper URLs when generating the pagination buttons.  I need PHP_SELF to be a class parameter so that if the page is not defined in the parameter, then use PHP_SELF.  The reason for this is because I generate the class in an ajax file and it is returning the URL of the ajax file, not of the page I am running the ajax on. I just don't know how to add the parameter to the class.

The class is below:

Code: [Select]
<?php

class Paginator{
var $items_per_page;
var $items_total;
var $current_page;
var $num_pages;
var $mid_range;
var $low;
var $high;
var $limit;
var $return;
var $default_ipp;
var $querystring;

function Paginator()
{
$this->current_page = 1;
$this->mid_range = 7;
$this->items_per_page = (!empty($_GET['ipp'])) ? $_GET['ipp']:$this->default_ipp;
}

function paginate($default_ipp)
{
if((isset($_GET['ipp'])) && ($_GET['ipp'] == 'All'))
{
$this->num_pages = ceil($this->items_total/$default_ipp);
$this->items_per_page = $default_ipp;
}
else
{
if(!is_numeric($this->items_per_page) OR $this->items_per_page <= 0) $this->items_per_page = $default_ipp;
$this->num_pages = ceil($this->items_total/$this->items_per_page);
}

if(isset($_GET['page']))
{
$this->current_page = (int) $_GET['page']; // must be numeric > 0
}

if($this->current_page < 1 Or !is_numeric($this->current_page)) $this->current_page = 1;
if($this->current_page > $this->num_pages) $this->current_page = $this->num_pages;
$prev_page = $this->current_page-1;
$next_page = $this->current_page+1;

if($_GET)
{
$args = explode("&",$_SERVER['QUERY_STRING']);
foreach($args as $arg)
{
$keyval = explode("=",$arg);
if($keyval[0] != "page" And $keyval[0] != "ipp") $this->querystring .= "&" . $arg;
}
}

if($_POST)
{
foreach($_POST as $key=>$val)
{
if($key != "page" And $key != "ipp") $this->querystring .= "&$key=$val";
}
}

if($this->num_pages > 1)
{
$this->return = ($this->current_page != 1 And $this->items_total >= 1) ? "<a class=\"paginate\" href=\"$_SERVER[PHP_SELF]?page=$prev_page&ipp=$this->items_per_page$this->querystring\">&laquo; Previous</a> ":"<!--<span class=\"inactive\" href=\"#\">&laquo; Previous</span>-->";

$this->start_range = $this->current_page - floor($this->mid_range/2);
$this->end_range = $this->current_page + floor($this->mid_range/2);

if($this->start_range <= 0)
{
$this->end_range += abs($this->start_range)+1;
$this->start_range = 1;
}
if($this->end_range > $this->num_pages)
{
$this->start_range -= $this->end_range-$this->num_pages;
$this->end_range = $this->num_pages;
}
$this->range = range($this->start_range,$this->end_range);

for($i=1;$i<=$this->num_pages;$i++)
{
if($this->range[0] > 2 And $i == $this->range[0]) $this->return .= " ... ";
// loop through all pages. if first, last, or in range, display
if($i==1 Or $i==$this->num_pages Or in_array($i,$this->range))
{
$this->return .= (($i == $this->current_page) And (isset($_GET['page'])) And ($_GET['page'] != 'All')) ? "<a title=\"Go to page $i of $this->num_pages\" class=\"current\" href=\"#\">$i</a> ":"<a class=\"paginate\" title=\"Go to page $i of $this->num_pages\" href=\"$_SERVER[PHP_SELF]?page=$i&ipp=$this->items_per_page$this->querystring\">$i</a> ";
}
if($this->range[$this->mid_range-1] < $this->num_pages-1 And $i == $this->range[$this->mid_range-1]) $this->return .= " ... ";
}
$this->return .= (($this->current_page != $this->num_pages And $this->items_total >= 1) //And ($_GET['page'] != 'All')
) ? "<a class=\"paginate\" href=\"$_SERVER[PHP_SELF]?page=$next_page&ipp=$this->items_per_page$this->querystring\">Next &raquo;</a>\n":"<!--<span class=\"inactive\" href=\"#\">&raquo; Next</span>-->\n";

//$this->return .= ((isset($_GET['page'])) And ($_GET['page'] == 'All')) ? "<a class=\"current\" style=\"margin-left:10px\" href=\"#\">All</a> \n":"<a class=\"paginate\" style=\"margin-left:10px\" href=\"$_SERVER[PHP_SELF]?page=1&ipp=All$this->querystring\">All</a> \n";
}
else
{
for($i=1;$i<=$this->num_pages;$i++)
{
$this->return .= ($i == $this->current_page) ? "<a class=\"current\" href=\"#\">$i</a> ":"<a class=\"paginate\" href=\"$_SERVER[PHP_SELF]?page=$i&ipp=$this->items_per_page$this->querystring\">$i</a> ";
}
$this->return .= "<a class=\"paginate\" href=\"$_SERVER[PHP_SELF]?page=1&ipp=All$this->querystring\">All</a> \n";
}
$this->low = ($this->current_page-1) * $this->items_per_page;

if(isset($_GET['ipp']))
{
$this->high = ($_GET['ipp'] == 'All') ? $this->items_total:($this->current_page * $this->items_per_page)-1;
$this->limit = ($_GET['ipp'] == 'All') ? "":" LIMIT $this->low,$this->items_per_page";
}
else
{
$this->high = ($this->current_page * $this->items_per_page)-1;
$this->limit = " LIMIT $this->low,$this->items_per_page";
}
}

function display_items_per_page()
{
$items = '';
$ipp_array = array(10,25,50,100,'All');
foreach($ipp_array as $ipp_opt) $items .= ($ipp_opt == $this->items_per_page) ? "<option selected value=\"$ipp_opt\">$ipp_opt</option>\n":"<option value=\"$ipp_opt\">$ipp_opt</option>\n";
return "<span class=\"paginate\">Items per page:</span><select class=\"paginate\" onchange=\"window.location='$_SERVER[PHP_SELF]?page=1&ipp='+this[this.selectedIndex].value+'$this->querystring';return false\">$items</select>\n";
}

function display_jump_menu()
{
for($i=1;$i<=$this->num_pages;$i++)
{
$option .= ($i==$this->current_page) ? "<option value=\"$i\" selected>$i</option>\n":"<option value=\"$i\">$i</option>\n";
}
return "<span class=\"paginate\">Page:</span><select class=\"paginate\" onchange=\"window.location='$_SERVER[PHP_SELF]?page='+this[this.selectedIndex].value+'&ipp=$this->items_per_page$this->querystring';return false\">$option</select>\n";
}

function display_pages()
{
return $this->return;
}
}

Hi all

I have an SQL database with products in and I need to write the PHP script to select from the SQl based on values in the URL.

The URL looks like this:

product.php?category=32&type=90&colour=10

So I can do the script:

if (isset($_GET['category']) && isset($_GET['type']) && isset($_GET['colour'])){
$sqlCommand = "SELECT * FROM products WHERE category = '$category' AND type = '$type' AND colour = '$colour'"; }

Which works great, I have also got the other versions if the type and colour are empty.

What I can't do is get it to select all from the database where the category = 32 and the type = 90 if the URL looks like this:

product.php?category=32&type=90&colour=

In other words where the colour is set but is empty. I want the script to show all products that have the category of 32 and the type of 90 if this is the case

Please help!

Many thanks

Pete

Hey guys,

I'm dealing a url that is similar to hxxp://domain/directory/?#{$id}.

What I'm trying to do is extract $id from that.   Its not available as a $_GET variable and $_SERVER['REQUEST_URI'] comes up as "/directory/?".

Does anyone know how I could retrieve $id ?

Thanks

Hi all   Is it possible to have a function with two parameters but and then check if one is passed before using it.   In this code here I want to remove spaces and change to lowercase.   If the $extra parameter is set I want to add that to the end of the string.    

function className($nametoUse, $extra){

Code: [Select]
function fetch_feedback_best()
{
$sql = "SELECT
`like`
FROM `feedback`
GROUP BY `page` asc
LIMIT 10";

while($row = mysql_fetch_assoc($sql))
{
$results[] = $row;
}

return $results;
}

This doesn't work.  My error is "Warning: mysql_fetch_assoc() expects parameter 1 to be resource, string given in /blah.inc.php on line 105 ".

Code: [Select]
<?php

$results = fetch_feedback_best();

foreach ($results as $result)
{
?>
echo $result['page'];
}

?>

I am trying to create a simple voting form. Everything goes well until I submit and then I get a Warning: mysqli_error() expects exactly 1 parameter, 0 given on line 79 error. I am assuming it is not pulling the ID correctly but as I am new to php and mysqli I cannot exactly say if it the way the code is written or if I am calling the parameter incorrectly in the query. Again I am new to to this so please be gentle. Below is my code. It pulls the drop down list correctly and echo's correctly but I believe my post query to be a little out of wack. Could someone point me in the correct direction? It would be very appreciated.

<form action="businesstype_update.php" method="post">
<?php 
if(isset($_POST['voteall'])){
	
	$vote_lg = "update membertest where id={$row_lg['id']} set vote=vote+1";
	
	$run_lg = mysqli_query($con, $vote_lg) or die(mysqli_error());
	
}

$result_lg = mysqli_query($con, "SELECT id, business FROM membertest WHERE businesstype='large'");

echo "Vote for large business of the year! <SELECT name='business'>\n";
echo "<option>Select a large business</option>";
while($row_lg = $result_lg->fetch_assoc()) {
echo "<option value='{$row_lg['id']}'>{$row_lg['business']}</option>\n";	
}
echo "</select></br></br>\n";
echo "<input type='submit' name='voteall' value='voteall'>";

$result_lg->close();

$con->close();

Hi all,

I have received this error, and I could clearly recall I did not actually change any content in the file.

May I know how should I debug it? Thanks


Warning: mysqli_error() expects exactly 1 parameter, 0 given in D:\inetpub\vhosts\abc.com\httpdocs\inc\php\tutor\t_reg_post1.php on line 163

Hi all

I am in the process of creating a product page where the user can type in three initials into a form and then 'clicks add to basket'.

The button doesn't use a form just a url:

basket.php?action=add&id=1&qty=1

This adds the item into a basket using sessions rather than a database. The question is, how do I add three variables into my form so that they are sent via the URL and into the session?

Wil I have to start again with a form?

Here's the code:

<td class="table-font-grey">Why not make your whip extra special by adding up to three elegantly engraved Kunstler script initials.</td>
            <td width="42" style="border: 1px solid grey;"><input name="initial_1" type="text" size="8" maxlength="1" height="40px" /></td>
            <td width="43" style="border: 1px solid grey;"><input name="initial_2" type="text" size="8" maxlength="1" height="40px" /></td>
            <td width="43" style="border: 1px solid grey;"><input name="initial_3" type="text" size="8" maxlength="1" height="40px" /></td>
          </tr>
          <tr>
            <td height="15">&nbsp;</td>
            <td width="328" class="table-font">&nbsp;</td>
            <td width="42" align="center" class="table-font">1</td>
            <td width="43" align="center" class="table-font">2</td>
            <td align="center" class="table-font">3</td>
            </tr>
          <tr>
            <td>&nbsp;</td>
            <td colspan="3" class="table-font">&nbsp;</td>
            <td align="right" class="table-font">&nbsp;</td>
          </tr>
        </table>
        <hr />
        <p>&nbsp;</p>
        <table width="494" border="0">
          <tr class="table-font">
            <td width="263" height="24">
           
            <a href="<?php echo "basket.php?action=add&amp;id=1&amp;qty=1" ?>" title="Add <?php echo $product['name'] ?> to Cart">
            <a href="<?php echo WEB_URL."basket.php?action=add&amp;id=1&amp;qty=1" ?>" title="Add <?php echo $product['name'] ?> to Cart">
            <img src="<?php echo WEB_URL."images/product-add-button.gif" ?>" alt="Buy <?php echo $product['name'] ?>" /></a>
           
Many thanks
Pete

$file = 'includes/views.txt';
$f = fopen($file, 'w+');
$views = fread($f, filesize($file));
fwrite($f, $views+1);
fclose($f);


The contents of views.txt is:
Code: [Select]
1

Why is it returning it needs to be greater than 0?...The file isn't empty.

What this parameter 'absolute' in DateTime::diff does? I have done some tests but i cant percept what is different when i set this parameter 'true'.

Can you explain to me?!

Thanks a lot.

Best regards.

Hi all

I have a form that i need to submit a get to the URL and then a second form that sends a different URL parameter but keeps the first in place?

Here's my code:

Code: [Select]
<select name="category" onChange="this.form.submit();">
            <option value= >--Choose category--</option>
            <?php 
   $getcats = mysql_query (" SELECT * FROM `categories` ORDER by name ASC");
   while ($showcats = mysql_fetch_array($getcats)) { 
           
            echo "<option value=\"".$showcats['id']."\"".(($_GET['category']==$showcats['id']) ? ' selected="selected"':'').">".$showcats['name']."</option>";
            } ?>
          </select>
    </form>

<form id="make" name="make" method="GET" action="create-advert.php?category='<?php echo $_GET['category']; ?>">
         
          <select name="make" onchange="this.form.submit();">
           <option>--Choose make--</option>
            <?php 
   $getmakes = mysql_query (" SELECT * FROM `makes` ORDER by name ASC");
   while ($showmakes = mysql_fetch_array($getmakes)) {
           
          echo "<option value=\"".$showmakes['id']."\"".(($_SESSION['make']==$showmakes['id']) ? ' selected="selected"':'').">".$showmakes['name']."</option>";
          
   } ?>
          </select>
          </form>


Each time I select the make in the second form the url parameter 'category' disappears from the first?

Many thanks

Pete
[/code]

Hello, I want to use this function in form. How can I pass parameter in form ? please help me. Thanks

<?php
function displayName($fetch)
{
echo "your Name is ".$fetch;
}

?>

i get this error

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\website\viewvideos.php on line 25

Code: [Select]
$addviews = $views + 1;

$query = mysql_query("UPDATE headlines SET views='$addviews' WHERE id=$viewid");
$rows = mysql_fetch_assoc($query);
i dont get whats wrong

Hi all

I am trying to write a piece of code that selects different products from the database based on the URL parameter. There are 3 fields; category, type and colour.

My URL will look like this if there is all three selected:

product.php?category=31&type=74&colour=3

Basically, if what ever is set in the url I need this to be selected from the database. Here's my code:

if (!isset($_GET['category']) && !isset($_GET['type']) && !isset($_GET['colour'])){
 $fetchproducts = mysql_query(" SELECT * FROM `products` ");
  $lightboxcount = 0;
   while($returnedProduct = mysql_fetch_array($fetchproducts)) {
    $lightboxcount ++;
     include('product-cell.php');
}
}

Although if there is no colour or the colour is blank like this:

product.php?category=31&type=74&colour=

I want it to select the items from the database just where the category and type are set.

Please help!

Many thanks

Hi, I have the following mqsql query which works fine on my page called property.php

<?php

$result = mysql_query("SELECT * FROM properties WHERE Property_Name='Test Hotel'") or die(mysql_error()); 

$row = mysql_fetch_array( $result );

echo "Property Name: ".$row['Property_Name'];
echo "<br>Property Rating: ".$row['Property_Rating'];
echo "<br>Property Address: ".$row['Property_Address'];
?>

Where I use the value of 'Test Hotel' for Property Name in above, how can I insert this value from a url parameter like /property.php?propertyname=Test Hotel?

Thanks so much.