PHP - Dynamic Site For Local Orchestra: Some *very* General Questions...

This might be a very easy problem to solve. I am literally brand new to php.
I am trying to create a simple site that will load content depending on what page 'id' is in the URL and if it doesn't exist to show a page for that scenario.
eg index.php?id=1 will show the page 1.php
 
It works fine apart from showing an error when there is no id at all,
eg  www.website.com will show an error but www.website.com/index.php?id=1 will show a page
I want to be able to show the homepage if there is no 'id' at all.

Code: [Select]
<?php
$id = $_GET['id'];


if(file_exists("./".$id.".php"))
  {
  include ("./".$id.".php");
  }
else
  {
  include ("404.php");
  }

?>
Any help  is appreciated
Thanks

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>';
?>

Hello, I went through the forum, its geat but I think missing one feature,   There should be a forum about having general conversations and if someone wanted to talk about taking suggestions to help him/her across the world of programming, that would be very great.   Thanks.

This topic has been moved to Ajax Help.

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

I have a general questions.

1. I have a list of products.
2. I have a list of each of the 50 states.
3. I have a list of "professions".

I need to setup something called "State Verbiage".  However, this is going to be on a per product, per state, per profession level.  So each profession is mapped up to each state and product.

So product #1, in State #4, for profession #2 would have verbiage.
Any combination of the three would have different verbiage.  Any advice on the easiest way to set this up, would be appreciated.

Hi,

I am really plugging into how to write functions in PHP.

But I was going to delve into a user management program and try to create it, but dont want to be the older version of what I was before if you like, where I just type in for the sake of typing in code so I thought I would question what their doing.

But a peice of code, a very small snippet, this came up:
@mysql_connect

What does this actually mean with the @ sign infront of the mysql_connect function?

Seen this a few times but just never appreciated what the at sign means, any help is wonderfully appreciated of course.

Thanks,
Jeremy

Hi there just wanted to ask you a general question regarding referenced variables and functions in PHP.

I have this code:
function theRefFunction(&$var){
$var = $var +1;
return $var;
}

$a = 50;

echo $thisvalue = theRefFunction($a);

Just for learning purposes, as allot of times beginning PHP seriously developers who want to improve on memory consumption in PHP find this tricky, is there any point in using an example like this?

I.e. would I really need the &$var as the parameter for the function called 'theRefFunction()'?

Just wondered thats all, if not what would be a better way for really using it?

It's just so I can go onto maybe doing a loop in it and setting it as a real example like working out tax and stuff like that, just for learning purposes, won't yet be using it.

Just wanted to build up as I said earlier a library of things I have done and make maybe my own tutorial site.

I look forward to any replies,
Jeremy.

Sorry for the non code lingo, but I am wondering if I can pull a word from an array and use it to get a value from another array.   I am making a simple dodgeball game engine. I want the coaches strategy to pick a certain attribute to base who to throw to. Here is the team array:   //silverbacks

Folks,

I need help (Php code ) to generate a Dynamic Text on a Base Image. What i want to do is, to make this Image as header on my Site and to make this Header Specific to a Site, i want to Add the Domain Name on the Lower Left of the Image.

Got the Idea?

Here is the Image link:

Quote

http://img27.imageshack.us/i/shoppingheader1.jpg/


PHP Variable that holds the Domain name is:  $domain 

All i need the Dynamic PHP Codes that i can put on all my sites to generate this Text on Image (Header) Dynamically...

May Anyone Help me with this Please?

Cheers
Natasha T.

This topic has been moved to PHP Regex.

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

I'm ready for the next step on my site, which is learning how to filter results down with a second search.

The scenario is: A viewer searches for a plant by 4 variables to describe the leaf. After submit, they go to the results page, with 200 paginated results. (This is where I've gotten to)

Now, on that same page, they choose to further narrow their results by searching those 200 results for plants that have purple flowers. Maybe they get 40 results and can use another variable to narrow further - and so on.

What's the best way to set this up? I've been looking into temporary tables, but it seems to be a challenge because the table deletes the moment they leave that page or close the connection? Sessions seem like another possibility, but I read there's security issues.

What's the best way to set this up? Just re-query the database with the entire set of variables from both the first and second searches? is it quicker to build some type of permanent table with a timestamp that I can use to delete it after the user has gone away?

My current function for checking over user inputs is below, email and phone numbers work just fine.

I'm more worried about the insufficiency of text and textarea, this isn't being used live anywhere atm while i remake it and i'm out of ideas on how to scan general data.

Fields passing through text, textarea might be full names, addresses, subjects basically general things. I've been stumbling on ideas of what would be best practice to do this.

Any ideas?


# $tbc = data to be cleaned
# $type = email, phone, text, textarea
function escape_data($tbc, $type='text') {
switch($type) {
case 'email':
if(preg_match('/(\w+\.)*\w+@(\w+\.)*\w+(\w+\-\w+)*\.\w+/', $tbc)){
$op = $tbc;
} else {
$op = false;
}
break;
case 'phone':
if (!empty($tbc)) { 
preg_match_all('/[0-9\(\)+.\- ]/s', $tbc, $cleaned); 
foreach($cleaned[0] as $k=>$v) { 
$ready .= $v; 
}
if ((strlen($ready) > 10) && (strlen($ready) <=25)) {
$op = $ready;
} else {
$op = false;
}
 } else {
$op = false;
 }
break;
case 'text':
case 'textarea':
if (!empty($tbc)) { 
$op = strip_tags($tbc);
} else {
$op = false;
}
break;
default:
$op = false;
}
return $op;
}

i've been able to load up a csv file and display it as a html table but what i'm having trouble with is sorting it out with headings a to z but what i am trying to do is have 4 columns like this.

Surgestions about how to do what im after i was hoping i could span the say A across all columns and centering them in the future also but thats not really the problem mainly the getting the array of the csv file and code right iguess. any help would be appreciated


Code: [Select]
<table>
  <tr>
    <th>A</th>
  </tr>
  <tr>
    <td>Apple1</td>
    <td>Apple2</td>
    <td>Apple3</td>
    <td>Apple4</td>
    <td>Apple5</td>
    <td>Apple6</td>

  </tr>
  <tr>
    <th>B</th>
  </tr>
    <td>Banana1</td>
    <td>Banana2</td>
    <td>Banana3</td>
    <td>Banana4</td>
    <td>Banana5</td>
    <td>Banana6</td>

  <tr>
    <th>C</th>
  </tr>
    <td>Cold1</td>
    <td>Cold2</td>
    <td>Cold3</td>
    <td>Cold4</td>
    <td>Cold5</td>
    <td>Cold6</td>
</table>

This is the code for inputting of the csv file i also have some other code i was wanting to use for the sorting of the array data from the csv file i'll past below....



Quote

<?php
$file = "widgets.csv";
$delimiter = ",";
$enclosure = '"';
$column = array("", "", "", "");


@$fp = fopen($file, "r") or die("Could not open file for reading");
while (!feof($fp))
   {
    $tmpstr = fgets($fp, 100);
    $line[] = preg_replace("/r/", "", $tmpstr);
   }
for ($i=0; $i < count($line); $i++)
   {
    $line[$i] = explode($delimiter, $line[$i]);
   }
?>
<html>
<head>
    <title>Albert's Delimited Text to HTML Table Converter</title>
   <link href="css/style.css" rel="stylesheet" type="text/css" />

</head>
<body>
<table border="1" cellpadding="5" cellspacing="0">
    <tr>
<?php
        for ($i=0; $i<count($column); $i++)
            echo "<th>".$column[$i]."</th>";
?>
    </tr>
<?php
for ($i=0; $i < count($line); $i++)
{
    echo "<tr>";
    for ($j=0; $j < count($line[$i]); $j++)
    {
        echo "<td>".$line[$i][$j]."</td>";
    }
    echo "</tr>";
}
fclose($fp);
?>
</table>
</body>
</html>




Heres the code for the sorting of the table data from the array


Quote

<?php
echo "QUERY_STRING is ".$_SERVER['QUERY_STRING']."<p>";
$rev=1;
$sortby=0;
if(isset($_GET['sortby']))$sortby = $_GET['sortby'];
if(isset($_GET['rev']))$rev = $_GET['rev'];


//Open and read CSV file example has four columns
$i=-1;
$ff=fopen('widgets2.csv','r') or die("Can't open file");
while(!feof($ff)){
$i++;
$Data[$i]=fgetcsv($ff,1024);
}

//Make columns sortable for each sortable column
foreach ($Data as $key => $row) {
   $One[$key]  = $row[0]; // could be $row['Colname']
   $Two[$key] = $row[1]; //numeric example
   $Three[$key] = $row[2];
   $Four[$key] = $row[3];} //numeric example
   
 
 //Case Statements for Sorting
   switch ($sortby){
   case "0":
   if($rev=="1")array_multisort($One, SORT_NUMERIC, $Data); //SORT_NUMERIC optional
   else array_multisort($One, SORT_NUMERIC, SORT_DESC,$Data);
   $rev=$rev*-1;
   break;
   
   case "1":
   if($rev=="1")array_multisort($Two,  $Data);
   else array_multisort($Two, SORT_DESC, $Data);
   $rev=$rev*-1;
   break;
   
   case "2":
   if($rev=="1")array_multisort($Three, SORT_NUMERIC, $Data);
   else array_multisort($Three, SORT_NUMERIC, SORT_DESC,$Data);
   $rev=$rev*-1;
   break;
   
   case "3":
   if($rev=="1")array_multisort($Four,   $Data);
   else array_multisort($Four,  SORT_DESC, $Data);
   $rev=$rev*-1;
   break;}

echo ("<table border=2>");    //$rev is reverse variable   
echo ("<th><a href=\"SortTable.php?sortby=0&rev=$rev\" title=\"Click to Sort/Reverse sort\">One</a></th>");
echo ("<th><a href=\"SortTable.php?sortby=1&rev=$rev\" title=\"Click to Sort/Reverse sort\">Two</a></th>");
echo ("<th><a href=\"SortTable.php?sortby=2&rev=$rev\" title=\"Click to Sort/Reverse sort\">Three</a></th>");
echo ("<th><a href=\"SortTable.php?sortby=3&rev=$rev\" title=\"Click to Sort/Reverse sort\">Four</a></th>");

$i=0;
foreach($Data as $NewDat){
if($NewDat[0]!=""){ //error trap
$str="<tr>";
foreach($NewDat as $field)$str.="<td>$field</td>";
$str.="</td>\n";
echo $str;}}
fclose($ff);
echo "</table>";

Bear with me, as I'm still quite new at PHP.

I'm trying to figure out the best way to build a search function for a database that will eventually be quite large.

The path of the search I'm building is to go from a straight-forward javascript and html search page, to a paginated search result. Then the user can narrow down those query results based on a new search of their results.

In trying to get the pagination to work across several pages(unsuccessfuly, I might add), I've been learning about sessions and temporary tables. But, because the database will be very large, I'm wondering if they are the wrong way. Sessions have a time limit, and temporary tables delete once the connection is closed.

Is it possible/feasible to build a permanent table that puts in the search variables, with a unique id and use this to manage the searches, pagination and all that? Then, at some point in the process, I can put code to delete the corresponding row (or even make it a saveable search). Maybe somebody sees where I'm going with this and  can describe it better than me? I'm just thinking off the cuff at the moment. Maybe there's some terminology that will help me find a tutorial. Any bit helps.
thanks!

I'm trying to learn how to code the proper way.

There's a few things im worried about,but overall im worried about clogging up the server.  so what should i keep in mind while coding, to avoid this?

I'm thinking, keep insert and update to a minimum?  as in, when possible, use session to keep track of data until i absolutly have to add that data to a database? is that a correct thought?

what about once the data is in the database, how much trouble is it to ask for the selected data inside a database?  should i be worried about overdoing request of data from databases?   

on the other hand, should i be worried about having too many sessions travelling around with a user.  why?

Im just asking to get a better feel for how to do things the proper way, i would hate to have a website built, only to find out that what i built is only a bat, that would bash the hell out of a server i wanted to put it on.