PHP - What's The Best Method To Build A Sitemap For A Website To Submit To Google?

This topic has been moved to Miscellaneous.

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

There is no SEO section so I do not know where exactly to ask this question, but here it is.   https://www.google.c...A#q=twitter.com   Do you see how Google lists Twitter results in two columbs underneath the main heading title?  How does one achieve that result with their website?  Does only Google decides to make it show up that way?

I’ve got a well proven php-mysqli website that works perfectly on desktops. It requests the email and password on the login page, taking that data and inspecting it before processing further. I’ve designed the presentation using CSS to be responsive and it’s working well, except for .. .. when I used it on my Nexus 4 and 7 the web site appeared. I touched the menu item ‘login’ and I entered both the correct email and password. However, the application bounced back as it should if either the email or password was wrong. So I inserted PHP scripting and confirmed that the site was receiving the correct email but a wrong password. The logic is 100% proven and the data entry correct. Is there something with the google nexus (and smartphones in general) that disallows web site passwords until some parameter is set? I'm hoping a responsive website developer accommodating nexus 4 or 7 can assist here.

This topic has been Ctrl+X/Ctrl+V'd to Miscellaneous.

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

Instead of breaking down and actually learning how to use ajax, I'm thinking about trying to do something so I don't need a page refresh every time, and the filtered data is nearly instant. I just use the session array var, and build a new array from the rows that meet the conditions.

I'm thinking of loading a two dimensional array into a session var, then use some input buttons, and use the post vars to filter the array based on a set of predefined conditions. ie status = 0, status = 1. It's a fairly small number of conditions applied to two different fields.

So, I need to access specific fields within a row, and essentially create a new array either including or excluding that row depending on whether it met the condition.

I'm struggling on several parts.
1. not sure how to build the array so that I can access specific fields, then not sure how to access those fields.
Do I do this..... to build the array? ....
Code: [Select]
while($row = mysql_fetch_assoc($result)){
   $array[] = array($row['field1'], $row['field2']);
}


I was thinking about using a foreach and is_array() to get to each row...
Code: [Select]
foreach($array as $key => $value){
   if(is_array){
      foreach($value as $k => $v){
         if($v[0] == 1){  //stuck here $v[0] is not a field, it's the first char of the string. not sure how to access a field
            $new_array[] = $value;  //stuck here. I need to put the whole row back into the array if the condition was true. seems like I would have to use the field selectors and rebuild the array.
         }
      }
  }

}


What would you do? Open to any ideas.

Hi.

I'm trying to create my first XML sitemap that I am going to be submitting to google.
The sitemap is going to be PHP but using MOD rewrite to make it look like an XML file.

The site map has been created.  http://test.powtest.co.uk/sitemap.xml
But, I now want to style it.

However, when I add the XML style file, I get an error:
Parse error: syntax error, unexpected T_STRING in /home/a/d/adele/web/public_html/sitemap.php on line 1


I'm not to sure how to get my PHP file to read in the XML style file.

Any help would be much appreciated


PHP sitemap (sitemap.xml)
Code: [Select]
<?xml-stylesheet type="text/xsl" href="sitemap.xsl"?>
<?PHP

require_once('includes/initialize.php');

$newAbout = Aboutme::find_by_id(1);
$aboutDateMod  = $newContact->dateMod;

$newContact = Contact_details::find_by_id(1);
$contactDateMod  = $newContact->dateMod;

$lastService = Services::find_last_posted();
$servicesDateMod = $lastService->dateMod;

$lastBlog = Blog::find_last_posted();
$blogDateMod = $lastBlog->dateMod;

// TOP NAVIGATION
  echo '
  <url>
  <loc>'.SITE_DOMAIN.DS.'</loc>
  <lastmod>2011-01-17</lastmod>
  <changefreq>yearly</changefreq>
  <priority>0.8</priority>
  </url>
  <url>
  <loc>'.SITE_DOMAIN.DS.'services</loc>
  <lastmod>'.$servicesDateMod.'</lastmod>
  <changefreq>daily</changefreq>
  <priority>0.8</priority>
  </url>
  <url>
  <loc>'.SITE_DOMAIN.DS.'testimonials</loc>
  <lastmod>2011-01-17</lastmod>
  <changefreq>daily</changefreq>
  <priority>0.8</priority>
  </url>
  <url>
  <loc>'.SITE_DOMAIN.DS.'about_adele_fifer</loc>
  <lastmod>'.$aboutDateMod.'</lastmod>
  <changefreq>yearly</changefreq>
  <priority>0.8</priority>
  </url>
  <url>
  <loc>'.SITE_DOMAIN.DS.'contact</loc>
  <lastmod>'.$contactDateMod.'</lastmod>
  <changefreq>never</changefreq>
  <priority>0.8</priority>
  </url>
  <url>
  <loc>'.SITE_DOMAIN.DS.'tips</loc>
  <lastmod>'.$blogDateMod.'</lastmod>
  <changefreq>daily</changefreq>
  <priority>0.8</priority>
  </url>';
 
 
// SERVICE CAT
  $check = Services::count_CID();
  if($check >= 1){

$serviceCat = Services_categories::find_all_order_by_exclude_nonFolder('category', 'ASC');
foreach($serviceCat as $serviceCats){
$ID = $serviceCats->id;
$cat = ucwords($serviceCats->category);
$servicesCatDateMod = $serviceCats->dateMod;

if($checkCat = Services::if_CID_exists($ID)){
  echo '
  <url>
  <loc>'.make_cat_url('services_list', $ID, $cat).'</loc>
  <lastmod>'.$servicesCatDateMod.'</lastmod>
  <changefreq>daily</changefreq>
  <priority>0.8</priority>
  </url>';
}
}
  }
 
 
// SERVICE LIST
  $serviceCat = Services::find_all_order_by('title', 'ASC');
  foreach($serviceCat as $serviceCats){
  $ID = $serviceCats->id;
  $title = ucwords($serviceCats->title);
  $servicesDateMod = $serviceCats->dateMod;
echo '
<url>
<loc>'.make_url('services', $ID, $title).'</loc>
<lastmod>'.$servicesDateMod.'</lastmod>
<changefreq>yearly</changefreq>
<priority>0.8</priority>
</url>';
  } 


// BLOG CAT
  $blogCat = Blog_categories::find_all_order_by('category', 'ASC');
  foreach($blogCat as $blogCats){
  $ID = $blogCats->id;
  $cat = ucwords($blogCats->category);
  $desc = $blogCats->smallDesc;
  $img = $blogCats->img;
echo '
<url>
<loc>'.make_cat_url('tips_list', $ID, $cat).'</loc>
<lastmod>'.$servicesCatDateMod.'</lastmod>
<changefreq>daily</changefreq>
<priority>0.8</priority>
</url>';
  }


// BLOG
  $blogCat = Blog::find_all_order_by('position', 'ASC');
  foreach($blogCat as $blogCats){
  $ID = $blogCats->id;
  $title = ucwords($blogCats->title);
  echo '
  <url>
  <loc>'.make_url('tips', $ID, $title).'</loc>
  <lastmod>'.$servicesCatDateMod.'</lastmod>
  <changefreq>yearly</changefreq>
  <priority>0.8</priority>
  </url>';
  }


?>



XML Stylesheet (sitemap.xsl)
Code: [Select]
<?xml version="1.0" encoding="UTF-8"?><!-- DWXMLSource="http://test.powtest.co.uk/sitemap.xml" -->
<!DOCTYPE xsl:stylesheet  [
<!ENTITY nbsp   "&#160;">
<!ENTITY copy   "&#169;">
<!ENTITY reg    "&#174;">
<!ENTITY trade  "&#8482;">
<!ENTITY mdash  "&#8212;">
<!ENTITY ldquo  "&#8220;">
<!ENTITY rdquo  "&#8221;">
<!ENTITY pound  "&#163;">
<!ENTITY yen    "&#165;">
<!ENTITY euro   "&#8364;">
]>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html" encoding="UTF-8" doctype-public="-//W3C//DTD XHTML 1.0 Transitional//EN" doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"/>
<xsl:template match="/">

<html>
−
<head>
−
<title>
Adele Fifer
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
−
<style type="text/css">

body { font-family: Arial, sans-serif; font-size:13px; }
#intro { background-color:#CFEBF7; border:1px #2580B2 solid; padding:5px 13px 5px 13px; margin:10px; margin-top:40px; }
#intro p { line-height: 16.8667px; }
td { font-size:11px; }
th { text-align:left; padding-right:30px; font-size:11px; }
tr.high { background-color:whitesmoke; }
#footer { padding:2px; margin:10px; font-size:8pt; color:gray; }
#footer a { color:gray; } a { color:black; }
#content { padding: 30px; }
img, img a { border:none; }
</style>
</head>
−
<body>
<h1>Adele Fifer Sitemap</h1>
−
<div id="content">
−
<table cellpadding="5">
−
<tr style="border-bottom: 1px solid black;">
<th>URL</th>
<th>Priority</th>
<th>Change Frequency</th>
<th>LastChange</th>
</tr>
<xsl:variable name="lower" select="'abcdefghijklmnopqrstuvwxyz'"/>
<xsl:variable name="upper" select="'ABCDEFGHIJKLMNOPQRSTUVWXYZ'"/>
−
<xsl:for-each select="sitemap:urlset/sitemap:url">
−
<tr>
−
<xsl:if test="position() mod 2 != 1">
<xsl:attribute name="class">high</xsl:attribute>
</xsl:if>
−
<td>
−
<xsl:variable name="itemURL">
<xsl:value-of select="sitemap:loc"/>
</xsl:variable>
−
<a href="{$itemURL}">
<xsl:value-of select="sitemap:loc"/>
</a>
</td>
−
<td>
<xsl:value-of select="concat(sitemap:priority*100,'%')"/>
</td>
−
<td>
<xsl:value-of select="concat(translate(substring(sitemap:changefreq, 1, 1),concat($lower, $upper),concat($upper, $lower)),substring(sitemap:changefreq, 2))"/>
</td>
−
<td>
<xsl:value-of select="concat(substring(sitemap:lastmod,0,11),concat(' ', substring(sitemap:lastmod,12,5)))"/>
</td>
</tr>
</xsl:for-each>
</table>
</div>
−
<div id="footer">
<a href="http://test.powtest.co.uk/about_adele_fifer">About Adele Fifer</a>
</div>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

I'm wanting to make a sitemap for my website but should I includes ALL possible url's?  For example I have a search page (where you can search a film) where the url syntax is something like "search.php?type=all&film=a+film".  Should I make sure that all possible urls are included in my sitemap e.g all the films in my database?  Hope that makes sense. 

Thanks for any help. 

First of all I have no idea  how to do this. But I know it can be done. A little help would be alot for me.

Thank you in advance.

So I want to go through a sitemap and visit each of the link on the sitemap and save the URL on to a database.

Example:

Quote

HP 5550N A3 Colour Laser Printer
 

 Konica Minolta PagePro 1350W A4 Mono Laser Printer
 

 HP 9050dn A3 Mono Laser Printer
 

 HP 5550DTN A3 Colour Laser Printer
 

 HP 5550HDN A3 Colour Laser Printer
 

 HP 5550DN A3 Colour Laser Printer


Lets say this was on the sitemap and it just continues with other product like this. I want to write a code where it will go to the first link and saves the product URL on to the database and continues to do the same until the last link. On my example it would be HP 5550DN A3 Colour Laser Printer.

Any help??? Any ideas??

I am not asking someone to write the code for me.. Just need help and good direction   

I'm wanting to make a sitemap for my website but as it's quite big there are a lot of url's I need to include.  I was wondering if anyone know's of a way this can be done using PHP.  e.g. using PHP to generate a list of URL's.  I had a think myself but wasn't sure how to do it. 

Thanks for any help. 

Hello,

I have found the following code which creates a sitemap from the home directory of files. Please could you point me in the right direction for changing this so that it looks up from my sql database and for each name within the database creates an entry in the sitemap (e.g. www.mysite.com/[NAME]).

Thanks for your help,

Stu


Code: [Select]
<?php
/******************************************************************************\
 * Author : Binny V Abraham                                                   *
 * Website: http://www.bin-co.com/                                            *
 * E-Mail : binnyva at gmail                                                  *
 * Get more PHP scripts from http://www.bin-co.com/php/                       *
 ******************************************************************************
 * Name    : PHP Google Search Sitemap Generator                              *
 * Version : 1.00.A                                                           *
 * Date    : Friday 17 November 2006                                          *
 * Page    : http://www.bin-co.com/php/programs/sitemap_generator/   *
 *                                                                            *
 * You can use this script to create the sitemap for your site automatically. *
 *  The script will recursively visit all files on your site and create a *
 *  sitemap XML file in the format needed by Google.   *
 *                                                                            *
 * Get more PHP scripts from http://www.bin-co.com/php/                       *
\******************************************************************************/

// Please edit these values before running your script.
//////////////////////////////////// Options ////////////////////////////////////
$url = "http://www.WEBSITE_NAME.com/"; //The Url of the site - the last '/' is needed

$root_dir = ''; //Where the root of the site is with relation to this file.

$file_mask = '*.php'; //Or *.html or whatever - Any pattern that can be used in the glob() php function can be used here.

//The file to which the result is written to - must be writable. The file name is relative from root.
$sitemap_file = 'sitemap.xml'; 

// Stuff to be ignored...
//Ignore the file/folder if these words appear in the name
$always_ignore = array(
'local_common.php','images'
);

//These files will not be linked in the sitemap.
$ignore_files = array(
'404.php','error.php','configuration.php','include.inc'
);

//The script will not enter these folders
$ignore_folders = array(
'Waste','php_uploads','images','includes','lib','js','css','styles','system','stats','CVS','.svn'
);

//The default priority for all pages - the priority of all pages will increase/decrease with respect to this.
$starting_priority = ($_REQUEST['starting_priority']) ? $_REQUEST['starting_priority'] : 70;

/////////////////////////// Stop editing now - Configurations are over ////////////////////////////


///////////////////////////////////////////////////////////////////////////////////////////////////
function generateSiteMap() {
global $url, $file_mask, $root_dir, $sitemap_file, $starting_priority;
global $always_ignore, $ignore_files, $ignore_folders;
global $total_file_count,$average, $lowest_priority_page, $lowest_priority;

/////////////////////////////////////// Code ////////////////////////////////////
chdir($root_dir);
$all_pages = getFiles('');

$xml_string = '<?xml version="1.0" encoding="UTF-8"?>
<urlset
  xmlns="http://www.google.com/schemas/sitemap/0.84"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://www.google.com/schemas/sitemap/0.84
                      http://www.google.com/schemas/sitemap/0.84/sitemap.xsd">

<?php
# ';


$modified_priority = array();
for ($i=30;$i>0;$i--) array_push($modified_priority,$i);

$lowest_priority = 100;
$lowest_priority_page = "";
//Process the files
foreach ($all_pages as $link) {
//Find the modified time.
$handle = fopen($link,'r');
$info = fstat($handle);
fclose($handle);
$modified_at = date('Y-m-d\Th:i:s\Z',$info['mtime']);
$modified_before = ceil((time() - $info['mtime']) / (60 * 60 * 24));

$priority = $starting_priority; //Starting priority

//If the file was modified recently, increase the importance
if($modified_before < 30) {
$priority += $modified_priority[$modified_before];
}

if(preg_match('/index\.\w{3,4}$/',$link)) {
$link = preg_replace('/index\.\w{3,4}$/',"",$link);
$priority += 20;
}

//These priority detectors should be different for different sites :TODO:
if(strpos($link,'example')) $priority -= 30; //If the page is an example page
elseif(strpos($link,'demo')) $priority -= 30;
if(strpos($link,'tuorial')) $priority += 10;
if(strpos($link,'script')) $priority += 5;
if(strpos($link,'other') !== false) $priority -= 20;

//Priority based on depth
$depth = substr_count($link,'/');
if($depth < 2) $priority += 10; // Yes, I know this is flawed.
if($depth > 2) $priority += $depth * 5; // But the results are better.

if($priority > 100) $priority = 100;
$loc = $url . $link;
if(substr($loc,-1,1) == '/') $loc = substr($loc,0,-1);//Remove the last '/' char.


$total_priority += $priority;
if($lowest_priority > $priority) {
$lowest_priority = $priority;//Find the file with the lowest priority.
$lowest_priority_page = $loc;
}

$priority = $priority / 100; //The priority is given in decimals

$xml_string .= " <url>
  <loc>$loc</loc>
  <lastmod>$modified_at</lastmod>
  <priority>$priority</priority>
 </url>\n";
}

$xml_string .= "</urlset>";
if(!$hndl = fopen($sitemap_file,'w')) {
//header("Content-type:text/plain");
print "Can't open sitemap file - '$sitemap_file'.\nDumping result to screen...\n<br /><br /><br />\n\n\n";
print '<textarea rows="25" cols="70" style="width:100%">'.$xml_string.'</textarea>';
} else {
print '<p>Sitemap was written to <a href="' . $url.$sitemap_file .'">'. $url.$sitemap_file .'></a></p>';

fputs($hndl,$xml_string);
fclose($hndl);
}

$total_file_count = count($all_pages);
$average = round(($total_priority/$total_file_count),2);
}

///////////////////////////////////////// Functions /////////////////////////////////
// File finding function.
function getFiles($cd) {
$links = array();
$directory = ($cd) ? $cd . '/' : '';//Add the slash only if we are in a valid folder

$files = glob($directory . $GLOBALS['file_mask']);
foreach($files as $link) {
//Use this only if it is NOT on our ignore lists
if(in_array($link,$GLOBALS['ignore_files'])) continue; 
if(in_array(basename($link),$GLOBALS['always_ignore'])) continue;
array_push($links, $link);
}
//asort($links);//Sort 'em - to get the index at top.

//Get All folders.
$folders = glob($directory . '*',GLOB_ONLYDIR);//GLOB_ONLYDIR not avalilabe on windows.
foreach($folders as $dir) {
//Use this only if it is NOT on our ignore lists
$name = basename($dir);
if(in_array($name,$GLOBALS['always_ignore'])) continue;
if(in_array($dir,$GLOBALS['ignore_folders'])) continue; 

$more_pages = getFiles($dir); // :RECURSION: 
if(count($more_pages)) $links = array_merge($links,$more_pages);//We need all thing in 1 single dimentional array.
}

return $links;
}

//////////////////////////////// Display /////////////////////////////


?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.1 Transitional//EN">
<html>
<head>
<title>Sitemap Generation Using PHP</title>
<style type="text/css">
a {color:blue;text-decoration:none;}
a:hover {color:red;}
</style>
</head>
<body>
<h1>PHP Google Search Sitemap Generator Script</h1>

<?php
if($_POST['action'] == 'Create Sitemap') {
generateSiteMap();
?>
<h2>Sitemap Created...</h2>

<h2>Statastics</h2>

<p><strong><?php echo $total_file_count; ?></strong> files were found and indexed.<br />
Lowest priority of <strong><?php echo $lowest_priority; ?></strong> was
given to <a href='<?php echo $lowest_priority_page; ?>'><?php echo $lowest_priority_page; ?></a></p>

Average Priority : <strong><?php echo $average; ?></strong><br />

<h2>Redo</h2>
<?php } else { ?>

<p>You can use this script to create the sitemap for your site automatically. The script will recursively visit all files on your site and create a sitemap XML file in the format needed by Google. </p>

<p>You can customize the result by changing the starting priorities.</p>
 
<h2>Set Starting Priority</h2>
<?php } ?>

<form action="create_sitemap.php" method="post">
Starting Priority : <input type="text" name="starting_priority" size="3" value="<?php echo $starting_priority; ?>" />
<input type="submit" name="action" value="Create Sitemap" />
</form>

</body>
</html>

 

My script has 3 classes (that are relevant to this discussion): DB, User and Validate. They are all in independent files and loaded automatically, when required, by an autoloader.
Both the User class and the Validate class have a private variable $_db which is instantiated by their class constructor: $this->_db = DB::getInstance();
At the top of the script I declare new instances: $user = new User(); and $validate = new Validate();
I then call a method in $user: $found = $user->findInUsers ( .... )
From within the findInUsers method I then want to call the query method in the DB class. My problem is that I can't find a way to do this that works.
I have tried $this->_db->query( ... ), $_db->query( ... ), but neither works.

The error messages I am getting a
An error occurred in script '/srv/http/classes/User.php' on line 42: Undefined variable $_db
Uncaught Error: Call to a member function query() on null in /srv/http/classes/User.php:42

Any pointers as to what I am doing wrong, or what I should be doing, would be most welcome.

I have a simple php script that updates my sitemap automatically. However, when you click the link to the sitemap at www.bomstudies.com/sitemap-xml.php - the last mod date is showing 1969. The php script works for files that are not in sub folders. such as /talks or /commentary. I just need to know what snippet of code i should add, change, or delete to the sitemap php side of it to show the correct last mod date for my xml sitemap. I greatly appreciate your help.    Thanks -    Here is some of my code:   The Config Code: posted as config.php <?php

I wish to create a sitemap for a shopping cart and so far it seem this needs to be in XML format? is this true ?

If so are there any templates that I can use to base my sitemap on.

Say I have an "Entries" table. I want to submit same multiple entries using a form submission. And If I have other queries submitted in the same form, I want those quarries to be submitted only once.  Is that possible to do? 

Here's my code.

if(isset($_POST['submit'])) {

  $entries = 10;

  $id   = 55;
  $name = 'Smith';

  $insert = $db->prepare("INSERT INTO entries(id, name) VALUES(:id, :name)");
  $insert->bindParam(':id', $id);
  $insert->bindParam(':name', $name);
  $result_insert = $insert->execute();
  if($result_insert == false) {
    echo 'Fail';
  } else {
    echo 'Success';
  }

}
?>
<form action="" method="post">
  <input type="submit" name="submit" value="SUBMIT" />
</form>

 

Edited January 13, 2019 by imgrooot

Hello again, guys!

I'm trying to do this:

Get $user_ID -> SELECT FROM favorites WHERE user="$user_ID" -> Now I should create an array with the ID of all the results of the previous command ->
SELECT FROM books WHERE genre="$favorites_ID" -> populate a html table.

The part I've no idea about how to do is building an array with the results and then using the SELECT command, find in the other tables the match.

Could you please give me a hand - one more time?