working with php xml xsl jquery sql

I have been working with php xml xsl jquery and sql a lot recently for the admin backed at work and they all work great together and I recommend it. I like to part of attaching things to xml then calling those things from xsl. By doing this you separate your php from your html or xsl. Much cleaner this way. I am getting much better at understanding how all this works together.

check out one of the sites we do seo for:
topcalgaryrealestate.com

DeveloperPhil: SQL

DeveloperPhil: SQL

SQL

Today I worked on sql statements for our keyword rental program for the saving of keywords. I have had to do this while people are working in the site live. The way I would like to be doing this is through a cvs system but we do not have that completely in place yet. I am learning a lot about sql statements. I am learning about LEFT JOIN and INNER JOINS where you can join multiple tables to get the information you want the way you want it.

4th of july

Happy 4th of july all.

Been working so much haven't had a chance to blog.

Heading to the hills of southern Utah this weekend.

should be much cooler there.

Signing off for the weekend.

Phil

today we worked on getting an open source cvs system in place. My script on the crontab of the servers did not restart the servers. I have made changes and hope that tonight I get the e-mails I am looking for. I started the Marketing Review. I have a plan for the layout of the pages now.



check out this client of ours: topunlimitedwealthsystem.com

crontab

Today I finished up with scripts to automatically restart all the servers on IBZDNS at a certain time each day. Then the script will email myself if successful. This was done by editing the crontab file on each of the servers to restart the server at the time needed and then the crontab will run a file I put on the server that runs another script that emails me if the restart was successful. So far this is going good. Just waiting for the e-mail to start rolling in telling me everything is going as planned.
I also finished up a script that automatically updates a couple fields on the servers DB every 2 hours. This also e-mails myself if successful.
Then I edited the my e-mail filters to catch these emails as they come in and put them into individual folders. This way my e-mail in box will not be filled up with these e-mails.
Tomorrow I am starting a new project creating a marketing review form. I believe this form will allow for Q & A. Steve P will inform me more on this in the morning. Sounds interesting.
We have a program call Web Collab where tasks can be assigned and checked off when done. I like being able to break down bigger projects into smaller tasks. Then I can check off the smaller tasks as I complete them, even though some of these smaller tasks will be revisited and updates made later. Just gives me a chance to check them off again.

Here is one of our client that want you to be your own boss:

call back function

Worked on tweaking a report script on clients sites that was in an infinite loop. Not exactly sure how the infinate loop got fixed but it did while I was searching for the problem. Once that was fixed I used a choose statement in the xsl so that if the test came up with NaN or 0 it would put in a dash. After that I had to find a way to find all the distinct websites in a list of website. I used this:



here the concat put a forward slash at the end of the url then the substring-after got everything after the double forward slash and the substring got everthing after the last forward slash that I put in earlier giving me aacatering.net out of http://aacatering.net.


but I still needed to make sites like aacatering.net and www.aacatering.net be the same distinct url. So I had to find a way to use a replace string function in xslt 1.0, but 1.0 does not support a replace function. Do I used a callback php function instead as you can see here:

xsl, xml, xslt

today I put together three files. one is a .xml that already has information in it. another is .xsl that I created stylesheet and template for. the other is a index.php that contains the xslt processor. I have the three working good together.

Still not sure where I placed in the disc golf tournament in Flagstaff. I hope they post the placements soon.


Here is another client you should check out: gift4youonline.net

Disc Golf and scripts

wrote some interesting scripts today that updated fields in the database from a curl of a site that had the information using a regular expression match. Also had the script store the name of the user executing the script in the database. The scripts are working great.
On another note I went to Flagstaff Arizona to play in a disc golf tournament. I think I came in about 23 place in my division of 36 (Advanced Amateurs).
Here is the site for the Tournament: http://www.pdga.com/schedule/event.php?TournID=7310
also please check out one of our clients: http://topcoloradohealthinsurance.com

keywords

today was a good day. got keywords working great.

amendments to analytics

Today I worked on amendments to the analytics scripts. I got Keywords on analytics to be bolded if they have not been purchased yet and a dash box next to it. get Keywords on analytics to be not bolded if they have been purchased and a check mark box next to them. I did this by giving the purchased keyword a class name and having CSS bold the keyword and a checkbox if it had that class name. have the keyword sorted by name and purchased. I sorted using using and it worked great. making these keywords links to the search engine they came from with the keyword as the searched item. I am doing this using xsl also. I will let you know how it goes.

Please check out one of out clients sites: onestopcaliforniarealtor.com

cached site and css

This morning I fixed some css problems on analytics. I learned about classes in css. With the use of CSS Classes you can have more than one style per HTML element. Then this afternoon I learned about caching a analytics page for 7 days using php script, since the original page took up to 30 second to load. first I created a folder where the cached files will reside. then used these functions to see if there is a cached version of the site within the last 7 days. $File is the location of the folder and the file name. This works great....

$Cached = "folder/Site.xml";
if($Xml = $this->GetCachedXml($Cached))
{
$this->XML = $Xml;
}
else
{
//load new XML
}

private function GetCachedXml($File)
{
if(!file_exists($File))
{
return false;
}
elseif(filemtime($File) < dom =" new">load($File);
return $Dom;
}
}

private function SaveCachedXml($File, $Xml)
{
$Xml->save($File);
}

Please check out one of our clients: http://canadamortgagefinder.net/

Analytics

worked on debugging analytics for sites that are being optimized for search engines.