Login   Register  
PHP Classes
elePHPant
Icontem

File: sample_files/mysql.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of ultral  >  Google site map generator  >  sample_files/mysql.php  >  Download  
File: sample_files/mysql.php
Role: Example script
Content type: text/plain
Description: sample
Class: Google site map generator
Generate Google site maps from arrays or MySQL
Author: By
Last change:
Date: 2006-07-11 05:20
Size: 558 bytes
 

Contents

Class file image Download
<?php
include_once "../class/GoogleSiteMap.php";
// Create the GoogleSiteMap XML String
$map=new GoogleSiteMap();
//Add a mysql_recordset
DBConnect();
$req="SELECT path as loc ,  freq as changefreg ,priority as priority FROM map";
$res=mysql_query($req);
$map->Add($res);
DBClose();
//close the XML String
$map->Close();
//Output the XML String
$map->View();
?>

<?php
//connect to mysql database
function DBConnect(){
    mysql_connect('localhost','root','');
    mysql_select_db("test_ggmap");
}
function DBClose(){
    @mysql_close();
}
?>