Re: Pass into the title meta-tag a variable from an URL Directory Manager

Wathever you are ging to do with meta tag they still are html tag, so as long as you embend the tag in php code it shuold just work fine. <?php echo "<any_html_tag attribute01=\"$myattribute01\" attribute02=\"$myzttribute02\"> </any_html_tag>"; ?> Any text editor should help you modifying the code by "find & replace" tools. Hope can help ps. FORZA ITALIA AGLI EUROPEI Franciccio "Alessandro Folghera" <info@kpromos.com> ha scritto nel messaggio news:40975641001B47A9@vsmtp1alice.tin.it... > I hope that phpers will be not angry if I'm posting that maybe stupid > question. > I have the following script, an URL Directory Manager (PHP4 from Wrox Press). > I'd like to pass the variable "category" into the TITLE META TAG from > php_category when I select the corrispondent category_id into the URL > Directory > Manager, i.e. to display the right category everytime I call it from the > script. As I'm an absolute beginner, I'd like someone could suggestme the most > rapid way to do it whitout rewriting all the code. Thanks for all, Alessandro > xxxxxxxxxxxx Tables of MySQL sample_db xxxxxxxxxxxxxxxxxxxxxxxxxxxx # Table > structure for table 'php_category' CREATE TABLE php_category ( category > varchar(30) NOT NULL, category_id varchar(15) NOT NULL, num_item int(5) NOT > NULL, PRIMARY KEY (category_id) ); # Table structure for table 'php_directory' > CREATE TABLE php_directory ( url_id int(10) NOT NULL auto_increment, > category_id varchar(15) NOT NULL, title varchar(150) NOT NULL, url > varchar(150) > NOT NULL, description text NOT NULL, registerdate date, hit int(5) NOT NULL, > lastaccesstime timestamp(14), password varchar(20) binary, email varchar(100) > NOT NULL, approved char(1) NOT NULL, PRIMARY KEY (url_id), UNIQUE url (url, > category_id) ); xxxxxxxxxxxxxxx php_directory.inc xxxxxxxxxxxxxxxxxxxxxx > xxxxxxxxxxxxxxxxxx php_directory.php xxxxxxxxxxxxxxxxx "; $MYSQL_ERRNO = ''; > $MYSQL_ERROR = ''; function directory_header() { global $new_window_width, > $new_window_height; ?> alert(\"Error: $msg\");history.go(-1)"; > directory_footer(); exit; } function user_message($msg, $url='') { > directory_header(); if(empty($url)) echo "alert(\"$msg\");history.go(-1)"; > else > echo "alert(\"$msg\");self.location.href='$url'"; > directory_footer(); exit; } > function get_category_info($category_id) { global $default_dbname, > $category_tablename, $root_category_id, $category_id_length, $welcome_message, > $PHP_SELF; global $link_id; if(!$link_id) $link_id = > db_connect($default_dbname); if($category_id == $root_category_id) { > $category_info_array["category"] = "Top"; > $category_info_array["num_item"] > = 0; > $query = "SELECT max(category_id), count(*) FROM $category_tablename WHERE > length(category_id) = $category_id_length"; $result = mysql_query($query); > if(!$result) echo sql_error(); $query_data = mysql_fetch_row($result); > $sibling_id = $query_data[0]; $num_child = $query_data[1]; > $category_info_array["num_child"] = $num_child; if(!$sibling_id) > $next_category_id = '001'; else { $sibling_length = strlen($sibling_id); > $next_category_id = $sibling_id + 1; for($i = strlen($next_category_id); $i > " . > $query_data[0] .""; $parent_array[$j] = $query_data[0]; $j++; } > $category_info_array["href_fullname"] = implode("->", > $parent_href_array); > $category_info_array["fullname"] = implode("->", $parent_array); } > return > $category_info_array; } function get_url_info($url_id) { global $link_id, > $default_dbname, $directory_tablename; if(!$link_id) $link_id = > db_connect($default_dbname); $query = "SELECT url_id, category_id, title, url, > description,registerdate, date_format(registerdate, '%M, %e, %Y') as > formatted_registerdate, hit, lastaccesstime, date_format(lastaccesstime, '%M, > %e, %Y %r') as formatted_lastaccesstime, password, email, approved FROM > $directory_tablename WHERE url_id = '$url_id'"; $result = mysql_query($query); > if(!$result) echo sql_error(); return mysql_fetch_array($result); } function > search_form($category_id) { global $root_category_id, $PHP_SELF; > if(!isset($category_id)) $category_id = $root_category_id; ?> > "> Search: ">Current Category ">All Categories OR AND > > $category_href_fullname ($num_child_str, $num_item_str) > > \n"; else echo " > > $category_href_fullname ($num_child_str) > > \n"; search_form($category_id); $query = "SELECT category, category_id FROM > $category_tablename WHERE (length(category_id) = $category_depth * > $category_id_length) AND category_id LIKE '$category_id%' ORDER BY category"; > $result = mysql_query($query); if(!$result) echo sql_error(); > if(mysql_num_rows($result) > 0) { ?> > > \n"; echo "\n"; echo "<\"$PHP_SELF?action=show_list> > category_id=$my_category_id\"> $my_category ($num_child_str, > $num_item_str)\n"; > echo "\n"; if(!($i % 2)) echo "\n"; $i++; } if(!($i % 2)) { echo " > \n" ; echo > ""; } ?> > > $found_str - Keyword(s): $keywords > > > \n"; if($total_num > 0) echo " > Displaying page $page_num out of $last_page_num > > \n"; $query = "SELECT url_id, category_id, title, url, description, > date_format(registerdate, '%M, %e, %Y') as formatted_registerdate, hit, > date_format(lastaccesstime, '%M, %e, %Y %r') as formatted_lastaccesstime, hit > FROM $directory_tablename WHERE $category_str AND approved = 1 $keyword_str > ORDER BY registerdate DESC $limit_str"; $result = mysql_query($query); > if(!$result) echo sql_error(); $i = 1; while($query_data = > mysql_fetch_array($result)) { $url_id = $query_data["url_id"]; > $formatted_registerdate = $query_data["formatted_registerdate"]; > $formatted_lastaccesstime = $query_data["formatted_lastaccesstime"]; $url = > "http://" . $query_data["url"]; $title = > $query_data["title"]; $description = > $query_data["description"]; $hit = $query_data["hit"]; echo " > <\"$PHP_SELF?action=go_url&url=$url&url_id=$url_id\">". > ($i+($cur_page * > $records_per_page)).".$title \n"; echo " > > > > \n"; echo $description; echo " > > \n"; echo "Last Access: $formatted_lastaccesstime > > \n"; echo "Hit(s): " . number_format($hit) . " > > \n"; if($admin) echo > > "<\"$PHP_SELF?action=delete_url&url_id=$url_id> > > category_id=$category_id&url=$url> title=$title&cur_page=$cur_page\"> > [Delete] > > \n"; echo "<\"javascript:open_window('$PHP_SELF? > > action=modify_url_form&url_id=$url_id> > > category_id=$category_id&cur_page=$cur_page');\"> [Modify] \n"; if(!$admin) > > echo "<\"mailto:$dirmaster_email? > > subject=PHPDirectory]SiteMissing> > > body=url_id:$url_id($url)\"> [Report Broken Link] \n"; echo " > > \n"; $i++; } if($search_on) $search_str = > "&search_on=1&search_type=$search_type&keywords=$keywords&search_category=$s > earch_category"; echo " > "; if($page_num > 1) { $prev_page = $cur_page - 1; echo > "<\"$PHP_SELF?action=show_list&category_id=$category_id&cur_page=0$search_st > r\">[Top]"; echo > "<\"$PHP_SELF?action=show_list&category_id=$category_id&cur_page=$prev_page$ > search_str\">[Prev] "; } if($page_num [Next] "; echo > "<\"$PHP_SELF?action=show_list&category_id=$category_id&cur_page=$last_page$ > search_str\">[Bottom]"; } echo " > "; echo " > > <\"$PHP_SELF?action=show_list\">[Directory Home] \n"; if($submittable) echo > "<\"javascript:open_window('$PHP_SELF?action=add_url_form&category_id=$categ > ory_id');\">[Submit a URL]\n"; echo " > "; ?> "; list_sites('new', $category_id); ?> > > Submit a PHP Site! > > "> "> > > Category > Title > URL > Email > Password > Retype Password > Description > ( Chars Max.) > > > $max_desc_length) error_message("Description too long! $max_desc_length chars > max!"); $title = addslashes($title); $description = addslashes($description); > $password = crypt($password, '.v'); if(!$link_id) $link_id = > db_connect($default_dbname); $query = "SELECT url FROM $directory_tablename > WHERE url = '$url' AND category_id = '$category_id'"; $result = > mysql_query($query); if(!$result) error_message(sql_error()); > if(mysql_num_rows($result) != 0) error_message("$url already exists in the > directory!"); $approved = 0; if($admin) { $query = "UPDATE $category_tablename > SET num_item = num_item + 1 WHERE category_id = '$category_id'"; $result = > mysql_query($query); if(!$result) error_message(sql_error()); $approved = 1; } > $query = "INSERT INTO $directory_tablename VALUES(NULL, '$category_id', > '$title', '$url', '$description', curdate(), 0, NULL, > '$password', '$email', > $approved)"; $result = mysql_query($query); if(!$result) > error_message(sql_error()); if($send_mail){ $mail_subject = "PHP Directory>> > Thank your for your listing."; $mail_body = "Thank you for sharing your > resources with us.\n"; $mail_body = "Your contribution will be listed after > review in a day or two.\n\n"; $mail_body .= "Title: $title\n"; $mail_body .= > "URL: $url\n"; $mail_body .= "Description: $description"; mail($email, > $mail_subject, $mail_body, "From: $dirmaster_email\nReply-to: > $dirmaster_email"); } $num_rows = mysql_affected_rows($link_id); if($num_rows > != 1) error_message(sql_error()); else echo " alert(\"$title($url) has been > successfully submitted!\"); > opener.location.href='$PHP_SELF?action=show_list&category_id=$category_id'; > self.close(); "; } function modify_url_form() { global $PHP_SELF, > $max_desc_length, $url_id, $category_id, $admin_script, $cur_page; > directory_header(); if(basename($PHP_SELF) == $admin_script) $admin = 1; > $url_info_array = get_url_info($url_id); $category_info_array = > get_category_info($url_info_array["category_id"]); ?> > > Update your PHP site! > > * Submitted on: > * Hits: > * Last Access: > "> "> "> > > Category > Email > Password > Title " SIZE="30" MAXLENGTH="150"> > URL " SIZE="30" MAXLENGTH="150"> > Description > ( Chars Max.) > > > $max_desc_length) error_message("Description too long! $max_desc_length chars > max!"); $url_info_array = get_url_info($url_id); if(!$admin >> > (($url_info_array["password"] != crypt($password, '.v')) || > ($url_info_array["email"] != $email))) error_message("You don't have > permission > to modify this URL!"); $title = addslashes($title); $description = > addslashes($description); if(!$link_id) $link_id = > db_connect($default_dbname); > $query = "UPDATE $directory_tablename SET title='$title', url='$url', > description='$description' WHERE url_id='$url_id'"; $result = > mysql_query($query); if(!$result) error_message(sql_error()); $num_rows = > mysql_affected_rows($link_id); if($num_rows != 1) error_message(sql_error()); > else echo "alert(\"$title($url) has been successfully modified!\"); > opener.location.href='$PHP_SELF?action=show_list&category_id=$category_id&cu > r_page=$cur_page'; self.close();"; } function go_url() { global > $default_dbname, > $directory_tablename; global $url_id, $url; if(isset($url_id) >> > isset($url)) { > if(!$link_id) $link_id = db_connect($default_dbname); $result = > mysql_query("UPDATE $directory_tablename SET hit = hit + 1 WHERE > url_id=$url_id"); if(!$result) error_message(sql_error()); header("Location: > $url"); exit; } } function list_sites($mode='top', $category_id='') { global > $directory_tablename, $root_category_id, $PHP_SELF, $num_top_sites, > $num_new_sites; if(!$link_id) $link_id = db_connect($default_dbname); > if($mode=='top') { $order_by_str = 'ORDER BY hit DESC'; $limit_str = "LIMIT > $num_top_sites"; } else { $order_by_str = 'ORDER BY registerdate DESC'; > $limit_str = "LIMIT $num_new_sites"; } if($category_id == $root_category_id) > $category_str = '1'; else $category_str = "category_id LIKE '$category_id%'"; > $query = "SELECT url_id, title, url FROM $directory_tablename WHERE > $category_str AND approved = 1 $order_by_str $limit_str"; $result = > mysql_query($query); if(!$result) echo sql_error(); if(mysql_num_rows($result) > > 0) { if($mode=='top') echo "Top $num_top_sites! > "; else if($mode=='new') echo "New $num_new_sites! > "; } $i = 1; while($query_data = mysql_fetch_array($result)) { $url_id = > $query_data["url_id"]; $url = "http://" . > $query_data["url"]; $title = > $query_data["title"]; echo " - > <\"$PHP_SELF?action=go_url&url=$url&url_id=$url_id\">$i. $title > \n"; $i++; } } ?> xxxxxxxx dir_manager.php xxxxxxxxxxxxxxxxxxx Click on the > level on which you want to add a new category. > > "; echo " > > > > \n"; echo > > "<\"javascript:open_window('$PHP_SELF?action=add_category_form&parent=$roo > > t_category_id')\">" . $category_info_array["category"] ." > > (" . > > $category_info_array["num_child"] . ")"; } else { echo " > > Click on the category you want to edit. > > > > "; echo " > >> > >> \n"; echo > >> "<\"javascript:open_window('$PHP_SELF?action=edit_category_form&category_ > >> id=$root_category_id')\">" . > >> $category_info_array["category"] ." (" . > >> $category_info_array["num_child"] . ")"; } echo " > >> \n"; echo " > >>> > >>> \n"; while($query_data = mysql_fetch_array($result)) { $category_id = > >>> $query_data[0]; $category_info_array = get_category_info($category_id); > >>> for($i=0; $i X \n"; if($mode == 'add_category') echo > >>> "<\"javascript:open_window('$PHP_SELF?action=add_category_form&parent=$c > >>> ategory_id')\">" . $category_info_array["category"] > >>> ." (" . > >>> $category_info_array["num_child"] . ")"; else echo > >>> "<\"javascript:open_window('$PHP_SELF?action=edit_category_form&category > >>> _id=$category_id')\">" . > >>> $category_info_array["category"] ." (" . > >>> $category_info_array["num_child"] . ")"; echo " > >>> \n"; } echo " > >> > >> \n"; echo " > > > > \n"; directory_footer(); } function add_category_form() { global > > $default_dbname, $directory_tablename, $category_tablename, $PHP_SELF; > global > > $link_id, $parent; $category_info_array = get_category_info($parent); > > $category_id = $category_info_array["next_id"]; $category_fullname = > > $category_info_array["fullname"]; directory_header(); ?> > > > > Adding a New Category: > > > > "> "> > > > > Category ID > > Category Name > > > > > > alert(\"$category was successfully added!\"); > > opener.location.href='$PHP_SELF'; self.close();"; directory_footer(); } > > function edit_category_form() { global $default_dbname, > $directory_tablename, > > $category_tablename, $PHP_SELF; global $link_id, $category_id; > > $category_info_array = get_category_info($category_id); directory_header(); > > ?> > > > > Editing the Category: > > > > "> "> > > > > Category ID > > Category Name " SIZE="20"> > > Resources > > > > > > alert(\"$category was successfully updated!\"); > > opener.location.href='$PHP_SELF?mode=edit_category'; self.close();"; > > directory_footer(); } function delete_category() { global $default_dbname, > > $directory_tablename, $category_tablename, $PHP_SELF; global $link_id, > > $category_id, $mode; if(empty($category_id)) error_message("Empty Category > > ID!"); if(!$link_id) $link_id = db_connect($default_dbname); $query = > "DELETE > > FROM $category_tablename WHERE category_id LIKE '$category_id%'"; $result = > > mysql_query($query); if(!$result) error_message(sql_error()); $del_subs = > > mysql_affected_rows($link_id) - 1; $query = "DELETE FROM > $directory_tablename > > WHERE category_id LIKE '$category_id%'"; $result = mysql_query($query); > > if(!$result) error_message(sql_error()); $del_items = > > mysql_affected_rows($link_id); echo "alert(\"1 category, $del_subs > > subcategories, and $del_items items were deleted!\"); > > self.location.href='$PHP_SELF?mode=$mode';"; } function update_db() { global > > $default_dbname, $directory_tablename, $category_tablename, $PHP_SELF; > global > > $link_id, $category_id, $mode; directory_header(); if(!$link_id) $link_id = > > db_connect($default_dbname); $query = "SELECT category, category_id, > num_item > > FROM $category_tablename"; $result = mysql_query($query); if(!$result) > > error_message(sql_error()); $num_revs = 0; while($query_data = > > mysql_fetch_row($result)) { $category = $query_data[0]; $category_id = > > $query_data[1]; $num_item = $query_data[2]; $query = "SELECT count(*) FROM > > $directory_tablename WHERE category_id = '$category_id' AND approved = 1"; > > $result2 = mysql_query($query); $query_data2 = mysql_fetch_row($result2); > > $total = $query_data2[0]; if(!$result2) error_message(sql_error()); > > if($num_item != $total) { $query = "UPDATE $category_tablename SET > num_item = > > $total WHERE category_id = '$category_id'"; $result2 = mysql_query($query); > > if(!$result2) die(sql_error()); echo "Number of resources in \"$category\" > > mismatch -> revised: $total resources. > > \n"; $num_revs++; } } if(!$num_revs) echo "No inconsistency found. > > \n"; else if($num_revs) echo "$num_revs inconsistency has been corrected. > > \n"; else echo "$num_revs inconsistencies have been corrected. > > \n"; echo "Done.\n"; directory_footer(); } function view_new() { global > > $default_dbname, $directory_tablename, $category_tablename, > > $records_per_page, $PHP_SELF, $link_id; global $cur_page; if(!$link_id) > > $link_id = db_connect($default_dbname); $query = "SELECT count(*) FROM > > $directory_tablename WHERE approved != 1"; $result = mysql_query($query); > > if(!$result) echo error_message(sql_error()); $query_data = > > mysql_fetch_row($result); $total_num = $query_data[0]; if(!$total_num) echo > > error_message("No new listing!"); $limit_str = "LIMIT " . $cur_page * > > $records_per_page . ", $records_per_page"; $query = "SELECT url_id, url, > > title, description, category_id FROM $directory_tablename WHERE approved = 0 > > ORDER BY registerdate $limit_str"; $result = mysql_query($query); > > if(!$result) echo error_message(sql_error()); $page_num = $cur_page + 1; > > $total_num_page = floor($total_num/$records_per_page); $last_page_num = > > $total_num_page + 1; directory_header(); top_menu(); echo " > > > > Displaying the page $page_num out of $last_page_num. > > > > "; echo " > > \n"; while($query_data = mysql_fetch_array($result)) { $url_id = > > $query_data["url_id"]; $url = > > "http://" . $query_data["url"]; $title = > > $query_data["title"]; $description = $query_data["description"]; > $category_id > > = $query_data["category_id"]; $category_info_array = > > get_category_info($category_id); $category_fullname = > > $category_info_array["fullname"]; echo " > > * \n"; echo > > "<\"javascript:open_window('$PHP_SELF?action=edit_new_form&url_id=$url_ > > id&category_id=$category_id');\">[Edit] \n"; echo > > "<\"$url\">$title > > ($category_fullname) - $description\n"; echo ""; } echo " > > \n"; echo " > > \n"; echo " > > "; if($cur_page > 0) echo "<\"$PHP_SELF?action=view_new&cur_page=0\">[Top]"; > > if($cur_page != 0) { $prev_page = $cur_page - 1; echo > > "<\"$PHP_SELF?action=view_new&cur_page=$prev_page\">[Prev] > > "; } if($cur_page > > [Next] "; } if($cur_page != $total_num_page) echo > > > > "<\"$PHP_SELF?action=view_new&cur_page=$total_num_page\">[Bottom]"; > > echo " > > "; directory_footer(); } function edit_new_form() { global $PHP_SELF, > > $max_desc_length, $url_id, $category_id; directory_header(); $url_info_array > > = get_url_info($url_id); $category_info_array = > > get_category_info($url_info_array["category_id"]); ?> > > > > Editing a new listing. > > > > * Submitted on: > > "> "> "> > > > > Category > > Email "> > > Title " SIZE="30" MAXLENGTH="150"> > > URL " SIZE="30" MAXLENGTH="150"> > > Description > > ( Chars Max.) > > Action Approve Delete > > > > > > alert(\"$title($url) has been successfully deleted!\"); > > opener.location.href='$PHP_SELF?action=view_new'; self.close();"; } else { > > if(strlen($description) > $max_desc_length) error_message("Description too > > long! $max_desc_length chars max!"); $title = addslashes($title); > > $description = addslashes($description); $query = "UPDATE > $category_tablename > > SET num_item = num_item + 1 WHERE category_id = '$category_id'"; $result = > > mysql_query($query); if(!$result) error_message(sql_error()); $query = > > "UPDATE $directory_tablename SET title='$title', url='$url', > > description='$description', approved = 1 WHERE url_id='$url_id'"; $result = > > mysql_query($query); if(!$result) error_message(sql_error()); > if($send_mail){ > > $mail_subject = "PHP Directory>> Your contribution has been listed."; > > $mail_body = "Thank you for sharing your resources with us.\n"; $mail_body = > > "Your contribution has been listed. Thank you.\n\n"; $mail_body .= "Title: > > $title\n"; $mail_body .= "URL: $url\n"; $mail_body .= "Description: > > $description"; mail($email, $mail_subject, $mail_body, "From: > > $dirmaster_email\nReply-to: $dirmaster_email"); } $num_rows = > > mysql_affected_rows($link_id); if($num_rows != 1) > error_message(sql_error()); > > else echo "alert(\"$title($url) has been successfully approved!\"); > > self.close();"; } } function delete_url() { global $default_dbname, > > $directory_tablename, $category_tablename, $category_id, $url_id, $url, > > $title; global $PHP_SELF, $link_id; if(!$link_id) $link_id = > > db_connect($default_dbname); $query = "UPDATE $category_tablename SET > > num_item = num_item - 1 WHERE category_id = '$category_id'"; $result = > > mysql_query($query); if(!$result) error_message(sql_error()); $query = > > "DELETE FROM $directory_tablename WHERE url_id = '$url_id'"; $result = > > mysql_query($query); if(!$result) error_message(sql_error()); $num_rows = > > mysql_affected_rows($link_id); if($num_rows != 1) > error_message(sql_error()); > > else echo "alert(\"$title($url) has been successfully deleted!\"); > > > self.location.href='$PHP_SELF?action=show_list&category_id=$category_id';"; } > > function top_menu() { global $PHP_SELF; echo "<\"$PHP_SELF\">Admin > > "; > echo "| > > > > <\"javascript:open_window('$PHP_SELF?action=update_db');\">Update DB > > "; echo > > "| <\"$PHP_SELF?mode=edit_category\">Edit Category Mode "; echo > > "| > > <\"$PHP_SELF?mode=add_category\">Add Category Mode\n"; echo "| > > <\"$PHP_SELF?action=view_new\">New Listings\n"; echo "| > > <\"$PHP_SELF?action=show_list\">View Listings in Admin Mode\n"; echo > > " > > > > \n"; } switch($action) { case "add_category_form": add_category_form(); > > break; case "add_category": add_category(); break; case > "edit_category_form": > > edit_category_form(); break; case "edit_category": edit_category(); break; > > case "delete_category": delete_category(); break; case "view_new": > > view_new(); break; case "edit_new_form": edit_new_form(); break; case > > "edit_new": edit_new(); break; case "add_url_form": add_url_form(); break; > > case "add_url": add_url(); break; case "modify_url_form": modify_url_form(); > > break; break; case "modify_url": modify_url(); break; case "go_url": > > go_url(); break; case "delete_url": delete_url(); break; case "update_db": > > update_db(); break; case "show_list": directory_header(); top_menu(); > > show_list(); directory_footer(); break; default: list_categories(); break; } > > ?>