PHP - Date_diff - Absolute Parameter

Hi guys, please help me to solve my problem. i want to get the url parameter using / for now i use index.php?category_id=14 how can i change the ?category_id=14 to index.php/14   thank you so much.

Hi!

Code: [Select]
$url = "http://www.youtube.com/watch?feature=player_embedded&v=IwPHy17Iu6E";
I have code      Code: [Select]
if (preg_match("/http:\/\/www.youtube.com\/watch\?v=([0-9a-zA-Z-_]*)(.*)/i", $url, $matches)) {
        return '<object height="'.$embed_height.'" width="'.$embed_width.'">'.
               '<param name="movie" value="http://www.youtube.com/v/'.$matches[1].'" />'.
               '<param name="wmode" value="transparent" />'.
               '<embed src="http://www.youtube.com/v/'.$matches[1].'&autoplay=1" type="application/x-shockwave-flash" wmode="transparent" height="'.$embed_height.'" width="'.$embed_width.'" />'.
               '</object>';

    }How to remove feature=player_embedded& from $url ?

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'];
}

?>

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

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;
}
}

Hello

I am experiencing some issues with a function and I cannot identify the problem.
The function is not receiving any parameter.

The URL values are passed correctly.  I used echo to display the parameters outside the function and that worked.
I also used echo to display the parameters inside the function and no parameter were displayed. 
So the function is not receiving parameters. 


Code: [Select]
<?php

$find = $_REQUEST['u_find'];
$field = $_REQUEST['u_field'];
$searching = $_REQUEST['u_search'];


 echo"(1a)$find, (1b)$field, (1c)$searching";//outside function

function test_display($searching, $field, $find)
{
   echo"(2a)$find, (2b)$field, (2c)$searching";//inside function
 
}

?>

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

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   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){

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

Hi Chaps,

I have a while loop which produces a couple of variables:
do {
$L_NAME.$i = 'Item 1';
$L_NUMBER.$i = '0001';
$L_QTY.$i = '1';
$L_AMT.$i = 10.50;
$NVP.$i = "L_NAME.$i.= .$L_NAME.$i.&amp;L_NUMBER.$i. = .$L_NUMBER.$i.&amp";
} while($i == $items);
Basically what I need to do is contruct a parameter made up of all the $NVP variables.

I've a feeling that I would need to add each variable to an array and then use a foreach statement, but I'm not 100% sure.

I'd be interested in the correct way to go about this, any comments welcome!

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]

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

May I know what does this mean, this is the code which they are referring to. I have tried troubleshooting, still could not find the cause, appreciate if anyone can help? Thanks

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


/**INSERT into tutor_musical_background table**/
   foreach($musics as $music) {
   $query6 = "INSERT INTO tutor_musical_background (tutor_id, musical_instrument_id) VALUES ('$tutor_id', '$music')";
   
   $results6 = mysqli_query($dbc, $query6)
   or die(mysqli_error());