PHP - Moved: Quick Opinion Related Question

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=343992.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=331354.0

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=321418.0

I wrote this basic script yesterday to process and generate a Google Site Map. And it works! BUT I want to advance this script to accommodate for something else and I don't know the correct path to take from here, but I will tell you what I've found out so far..

Current Situation:

1 - Currently my below script generates urls in the site map like:
http://abcdefg.com/index.php?dispatch=products.view&product_id=29826

2 - I have .htaccess configured to rewrite the urls to the products name data like:
http://abcdefg.com/pennies/wheat-pennies/lincoln-wheat-penny-cent.html (just an example) and these urls are ONLY active if clicking on the site links themselves - meaning if I enter: http://abcdefg.com/index.php?dispatch=products.view&product_id=29826 directly into the url, the url does not resolve to this natural friendly url name.

What Id like to achieve (which I don't know what direction I should be looking!):

- I'd like my xml output urls (as current) to be written in the natural format (as in #2 above).

FYI here is a current example output item in my sitemap:

Code: [Select]
<url>
  <loc>http://abcdefg.com/index.php?dispatch=products.view&amp;product_id=29803</loc>
  <changefreq>weekly</changefreq>
  <lastmod>2010-09-24T08:00:00+04:00</lastmod>
 </url>
Can anyone give me some guidance on what method might work for this? Do you think it's more a mod_rewrite issue? Or can this be handled easier with straight up modifications to my below? I'm just a bit confused on what direction I should be looking.. Thanks for any input.

<?php
header("Content-Type: text/xml;charset=iso-8859-1");
  echo '<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';
 //include('config.local.php');
  $cxn = mysqli_connect($config['db_host'], $config['db_user'], $config['db_password'], $config['db_name']);
  $query = "SELECT cscart_product_descriptions.product_id, cscart_products.product_id, cscart_products.timestamp
FROM cscart_product_descriptions JOIN cscart_products ON cscart_product_descriptions.product_id = cscart_products.product_id
WHERE cscart_products.status='A' LIMIT 10000";
  $result = mysqli_query($cxn, $query);
  $row = mysqli_fetch_array($result);
  while ($row = mysqli_fetch_array($result)) {
  $formatedTime = $row['timestamp'];
      echo '<url>
  <loc>http://abcdefg.com/index.php?dispatch=products.view&amp;product_id=' . $row['product_id'] . '</loc>
  <changefreq>weekly</changefreq>
  <lastmod>'. date('c',$formatedTime) .'</lastmod>
  </url>';
  } //while ($row = mysqli_fetch_array($result))
  echo '</urlset>';
?>

hey guys

i have a script that creates a cookie named "MyLoginPage"

now everything works well
the cookie is saved and it keeps the user logged in

The Question
ok so im wanting to create a link that will delete the cookie
so when the user clicks the link it will delete the cookie

is this possible??
if so, how??

many thanks

hi.
when i get into some function manual and there is a note says.
Quote

This function has been DEPRECATED as of PHP 5.3.0. Relying on this feature is highly discouraged.

.
is that meaning that after 5.3.0 version this function will not be supported?
thanks , Mor.

code

<?php
//storecodefound.php v1.0
//purpose is to store the http refer and the code associated with the site to a db to be collected and verified by submitcode.php
$code = $_GET['code'];
$site = $_SERVER['HTTP_HOST'];


//check to see if the code already present
$connect = mysql_connect("localhost","root","") or die (mysql_error());
$check = mysql_query("SELECT code FROM hunter.codes WHERE code='$code'") or die (mysql_error());
$row = mysql_num_rows($check);
echo "result of \$row is ".$row;
echo "<br />";
if ($row = 0) {
//insert into db cause it's not there
mysql_query("INSERT INTO hunter.codes (id, code, site)
VALUES ('','$code','$site')") or die (mysql_error());
}
else {
//echo it's already here
echo "Code already found on server!";
}





?>

my question is the result of $row is infact 0 and the if statement says if $row is 0 to insert into db and instead it's given me the code is already found?

Does storing multiple values in 1 database field with a varchar let's say set at 150, all separated by
"|'s" so I don't have to create a field name for each one is it better performance wise or no? (storing 6-7 different |'s that will be outputted with a array ofc)

?

Hi, I've seen code like this multiple times, but I don't really know what it means.

function funcName(&$something) {
    // whatever
}

What exactly does the "&" do before the variable?

hey! I have a site where I want to use multiple issets at the same time, like if I have four buttons and four issets:
if(isset($_POST['one']))
{
echo '<div class="example_box">one</div>';
}

if(isset($_POST['two']))
{
echo '<div class="example_box">two</div>';
}

if(isset($_POST['three']))
{
echo '<div class="example_box">three</div>';
}

if(isset($_POST['four']))
{
echo '<div class="example_box">four</div>';
}


but for some reason it seems like only one isset can be activate at a time, is there any way to work this out or something :s?

I've tried some variants of elseif stuff and such, but yeah, I'm pretty new at this stuff

Is there a way to only output the first, say, 30 words of a variable? I have a way to do it in mind, but seems like it's messy and not practical.

Any suggestions?

E.g:

WITHOUT LIMIT: Welcome to my store. Would you like to buy something? We have really good noodles and fishes in doodle pools.
WITH LIMIT: Welcome to my store. Would you like...

Sort of like a short preview.

how to open a site with curl that has frames ?

when ive tried it gives "your broswer does not support frames" ...

I am starting to learn PDO by re-writing one of my existing scripts. Do I still need to validate $_GET or does PDO do the work for me?  Currently I am using:

Code: [Select]
$id = $_GET['id'];

$sth = $dbh->prepare('DELETE FROM van_reservations WHERE id = :id');
$sth->bindParam(':id', $id, PDO::PARAM_INT);
$sth->execute();

I used to validate by using this:

Code: [Select]
$id = isset($_GET['id']) && is_numeric($_GET['id'])?(int) $_GET['id']:0;

What is the difference between these two lines


Code: [Select]
!isset($_POST[$requiredField])
and

Code: [Select]
!$_POST[$requiredField]

I have data that is in a form right now being displayed in a textbox because I want the user to see the 'name' but the data that needs to be passed when submit is pressed is the id of the entity. So if I have  <label id = "username" Value = "3"> Heintzman</label> can I use $_Post to retrieve that value once the form has been submitted because I dont want the data to be displayed in a textbox it looks ugly and isnt long enough for the text without editing.