PHP - Continuous Looping Through Dynamic Links

This is a question about dynamic links.  At the moment I have a dynamic page from a table, I'll call it tableA.  The links all work fine, so when clicked, information is displayed from the table.  The issue will be when I come to create a new table entry.  This new pages (or entry), will itself contain a link to other information.  Assuming I have the required information in tableA, how do I activate a dynamic link from within a page that itself dynamically produced?

I use PDO for the link to the database, and the page that shows the text uses a form, with buttons to allow the user to select a menu item. 

The php:

<?php
	//  Connect to the databaase
	$PDO = new PDO("mysql:host=****;dbname=****", "****", "****");
	// set the PDO error mode to exception
	$PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

	//  Set up defaults
	$current_title = "";
	$current_page_data = "";

	//  Check if the user posted the  page
	if($_SERVER['REQUEST_METHOD'] == 'POST') {
	    //  Check if user pressed a menu button
	    if(isset($_POST["menu"])) {
	        //  User has selected a menu, meaning a page was selected, now load the page
	        $current_title = filter_input(INPUT_POST, "menu");

	        //  Now get current data from the database, if the page was never created, add it to the database
	        $stmt = $PDO->prepare("SELECT * FROM pages WHERE pageheader=?");
	        $stmt->execute([$current_title]);
	        $row = $stmt->fetch();
	        if($row) {
	            //  Page is in the databaswe already, load the text for it
	            if(isset($row["pagetext"]) AND trim($row["pagetext"])!="") {
	                $current_page_data = $row["pagetext"];
	            }
	        } else {
	            //  Page was never created, add it with blank text
	            $current_page_data = "This page is under contruction!<br><br>Please check back again later!";
	        }
	    }
	}
	?>

The form (partial):

<form name="****form" method="post" action="#">

	<table id="timeline">
		<tr>
			<td id="contentMenu">
				<span class="item">
					<div class="dropdown">
						<button class="dropdownButton">Pre 3150 BC</button>
						<div class="dropdownContent">
						<button name="menu" type="submit" value="Predynastic Egypt">Predynastic Egypt</button>
						<button name="menu" name="menu" value="Lower Egypt">Lower Egypt</button>
						<button name="menu" type="submit" value="Upper Egypt">Upper Egypt</button>
						<button name="menu" type="submit" value="Upper and Lower Egypt">Upper &amp; Lower Egypt</button>
					</div>
				</span>

....
							
			</td>
		</tr>
	</table>
	</form>

	<!-- page content -->
	<hr>

	<h1 class="center"><?php echo $current_title; ?></h1>

	<hr>

	<?php echo $current_page_data; ?>

 

Hey, thank you for taking time to read this and for possibly helping me sort this.

So I'm trying to make it so:

Code: [Select]
http://mysite.com/thing/key

is rewritten as:

http://mysite.com/thing.php?k=key

while keeping a general rule for:

http://mysite.com/thing

being written to:

http://mysite.com/thing.php
Please help thank you.

The table in the script has a set max-width. How can now a too long continuous text string as in "blaaaaaaaa", which also does not contain a space or dash, be broken, so the table does not become stretched to far?

Which function is used for this?

i am working on this search engine. and in the advanced section you can turn on/off some of the options. So it you turn on an option it will search another table and so on.

Instead of building a massive query and left joining lots of stuff. I tried a different approach.

There is always a basic query and it returns the results to an array like this


Code: [Select]
$sql = mysql_query("SELECT SQL_CACHE id FROM table WHERE field LIKE '$getquery' ORDER BY field");
  while ($row = mysql_fetch_array($sql)) {
     $idArray[] = $row['id'];
  } mysql_free_result($sql);
and if something is turned on then it adds something like this:

Code: [Select]
if($_POST['value'] == "1") {
$sql = mysql_query("SELECT SQL_CACHE table1_relation_id FROM table2 WHERE field2 LIKE '$getquery' ORDER BY field2");
  while ($row = mysql_fetch_array($sql)) {
    $idArray[] .= $row['table1_relation_id'];
  } mysql_free_result($sql);
} //end if

so basicy i just continue the array and it keeps pumping ids into a big aray. after that i run array_unique and remove all duplicate results and then i foreach and get the whole item info ased on every id. it runs pretty fast.


now i would like to make the second one a function. but when i do that it does not work.

Code: [Select]
function sample($query, $table, $field) {
$sql = mysql_query("SELECT SQL_CACHE naziv_id FROM ".$table." WHERE ".$field." LIKE '$query'");
while ($row = mysql_fetch_array($sql)) {
$return[] .= $row['naziv_id'];
} mysql_free_result($sql);

return $return;

}
before i put it into a function $idArray vas a single continuous array. And if i try to do it like this:

Code: [Select]
$arr[] = sample($query, "table1", "filed_id");
$arr[] .= sample($query, "table2", "filed_id");
it returns the result of the first array ok but if there are more then one results in other arrays it returns and arary inside of the array.

like this:

Code: [Select]
array(4) { [0]=> array(2) { [0]=> string(4) "9057" [1]=> string(5) "14186" } [1]=> string(5) "Array" [2]=> string(5) "Array" [3]=> string(0) "" }
and all i wanna have is a single id variable that has all the id's in it. like $array = 1,2,3,4,5 but from different sources/functions

can you help? thank you so much.

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.