PHP Scripts from Stargeek.

PHP Scripts

PHP Oracle Excel Writer

This is a modification I found on a spanish website of my code that adopts it to work with an Oracle database instead of a MySQL table. This script will read the contents of an Oracle table and export it into an excel file.

View the Source

PHP link directory

This is a very simple script that will allow you to create a mysql and php based link directory. The php link directory script is fully customizable to your look and feel and contains only one php file to install.

View the Source

URL rewriter php script

This is part of a hack to rewrite dynamic PHP urls to resemble static html pages. Read about using this in our Designing search engine friendly PHP pages article.

View the Source

Keyword Density Analysis Functions

This set of php keyword density functions enables you to generate a keyword density report of a given url. It includes a stop words function and a punctuation cleaning function. This is the code that runs stargeek's Keyword density analyzer.

View the Source

weblogsDotCom parser

This script reads weblogs.com's list of newly updated feeds and returns an array of them.

View the Source

OPML reader

This php script reads an OPML xml file (a list of blog url, and their corresponding RSS urls) and parses it into an sql table. it may be easily modified to output in any format.

View the Source

_array_slice()

This php script is a rewite of the array_slice() function that takes the array's key's into account.

View the Source

stop words function

This simple php script is a function that takes a list of stop words (commnly occuring words that are of no use to a search engine) and strips them out of a variable term. This is similar to google removal of common words.

View the Source

php login script

This simple php login script features functions to add hashed and encrypted passwords and usernames to a mysql table, and then a function to validate users based on these PHP login credentials. One of the most popular uses of a PHP script is to secure acess to various portions of a website based on a user's login name and password. We only use one way encryption, when storing the php login passwords in the mysql database, because our php login script never needs to know the actual plaintext of the username or password, thereby securing the php login script. Also, check out my php login tutorial

View the Source

PHP Benchmark Script

This PHP Performance Benchmark Script allows you to run specified php scripts multiple times while timing the execution to derive an average load time.

View the Source

convert windows newlines to unix newlines

this script allows you to upload a text file in with windows newline characters, it wil then remove the "/r" char and output the newtext file to the browser.

View the Source

Google Crawl trackerscript

This php script will track google's crawls through your website based on UA (none of the stealthy crawls will be detected, if you want to do that find out the ips and hack it up, don't forget to email it to me tho ;)).

View the Source

PHP email form

This is release 3 of my php email form script, used for creating a PHP contact form. It's a cleaner rewrite that organizes the code better for less expeirenced php users. Creates a php email form which allows a website viewer to send an email to the owner of the website from a form. This script is useful for php contact forms, like stargeek's PHP Contact Form. Also check out the PHP Email tutorial, this will guide you through the usage of my script and installing the php contact form.

View the Source

things to do php webcalendar script

a codefork of my original webcalendar generation function, hacked up in collaboration with phpfreak from phpfreaks.com This class uses a db with eve

View the Source

simple template structure

a very simple, extremely flexible php templating system, that uses either full or short tag echo syntax as content place holders in a file.

View the Source

Essential Reading Link Archive

using a mysql table with a category field and iframes to generate a simple two-tiered link archive.

View the Source

php website Usage statistics script

this php website usage statistics script generates a dynmic graph showing, raw htis, average hits, raw unique IPs and average unique ips statistics, it also monitors, ave click per vist, referrers, google search terms and per page hits. Also check out stargeek's php stats script tutorial.

View the Source

Stargeek Scripts Archive

Creates a browse-able archive of php scripts, using highlight_file(), .phps files and a MySQL table.

View the Source

Froogle Feeder / tab delimited froogle data feed example

This simple php script uses an associative array to create a tab delimited froogle datafeed file. The most important part of this php script is the fact that it contains a tab delimited froogle feed example, which is in the froogle format that you can th

View the Source

php calendar script

This PHP function, hacked from the original calendar script source, at http://www.keithdevens.com/software/php_calendar/source.php this php calendar script returns a color-coded calendar as a string, based on the entries in a mysql database table, correseponding to entries posted in a news table. It is a monthly calendar and entirely real time dynamic php.

View the Source

RSS Output

RSS Output
The RSS output file that runs stargeek's feed. Cleans input to generate valid RSS. Optional category searches.

View the Source

Text to DB

Text to DB
Dump delineated text file export of table to SQL (MySQL) table.

View the Source

php excel

SQL to Excel
this php script will write data from php using text from an SQL table (MySQL, supply your own SQL query) to a microsoft excel (.xls) file. The Excel file is specified as such by a set of headers, defining content, using php's header() function.

View the Source

php rss aggregator script

php rss aggregator
this php script will Pull a List of RSS feed addresses out of a mysql database. Perform responsiveness check with socket connection, compare poll results to database of headlines, if unique, add. Also formats template for display.

View the Source