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
Thursday, July 17, 2008
Thursday, July 10, 2008
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.
Thursday, July 3, 2008
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
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
Tuesday, June 10, 2008
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
check out this client of ours: topunlimitedwealthsystem.com
Monday, June 9, 2008
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:
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:
Wednesday, June 4, 2008
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:
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:
Subscribe to:
Posts (Atom)