Solution Expert Online Blogs

jQuery and Ajax Best Demos

Found nice article, which includes a collection of jQuery, Ajax, JSON and PHP Tutorials with live demos, tutorials posted on 9lessons blog. In these demos I had explained about jquery connectivity with MySQL database, Ajax implementation, JSON with PHP and Animation addons to your web pages.
Please follow the link.

Apache Virtual Host Parsing Bash

Below script will parse Apache config and will grab only the VirtualHost section from config file. Script can be extended to parse any directives in apache config file.
#!/bin/bashmyifs=$IFSIFS=$(echo -en “\n”)scan_file=`sed -n ‘/^<VirtualHost*/,/<\/VirtualHost>/p’ /etc/httpd/conf/httpd.conf | grep -v “#” |  sed ’s/^[ \t]*//;s/[ \t]*$//’ | sed ’s/<//g’ | sed ’s/>//g’ | sed ’s/:/ /g’ | sed ’s/\/V/V/g’` [...]

Easy PHP Pagination

There is an interesting article about the PHP Pagination and easy to integrate. As a developer you’ll soon find a need to paginate data when displaying contents from the database, and rather than use JavaScript which could require all the data to be loaded into the page on load, we can use PHP to ensure [...]

Rich HTML form select input plug-in – Forms generation

Rich HTML form select input plug-in – Forms generation and validation package blog
The  HTML forms select inputs are very useful but their limitations do not allow presenting a more detailed and pleasant to read information about the options that the user can select.
The form list select custom input plug-in was released with the goal [...]

Security Log Scanner For Apache

Scanning apache logs offline to find out security related issues is important task to get site running without any hacks. Want to find attacks on site so that it can be fixed well ahead in time before unauthorized access. You can use scalp, its a apache log scanner to find possible attacks on the webserver.
Please [...]

Collection Of PHP Scripts

Looking for php scripts.
Found an interesting link which has cool collection of php scripts. Really interesting, It has collection of php, java, Ajax and many other.
Check out by visiting site .

MySQL Best Practices

Some of the MySQl Best Practices

Optimize Your Queries For the Query Cache

EXPLAIN Your SELECT Queries

LIMIT 1 When Getting a Unique Row

Index the Search Fields

Index and Use Same Column Types for Join

Do Not ORDER BY RAND()

Avoid SELECT

Almost Always Have an id Field

Use ENUM over VARCHAR

Get Suggestions with PROCEDURE ANALYSE()

Use NOT NULL If You Can

Prepared Statements

Unbuffered Queries

Store [...]

Collection Of Log Parsing Tools

Found an interesting link to parse logs of specific application and much more details about logging mechanism and many other resources. Thought of sharing it as it might help many. Really a good collection of tools.
Please follow link to check.

Link Checker tool

Found a freeware tool for checking links for website (Xenu’s). It provides with a reports with details like :
* Broken links, ordered by link
* Broken links, ordered by page
* List of redirected URLs
* List of valid URLs you can submit to a search engine
* Site Map of HTML pages with a Title
* Broken page-local links
* [...]

Compile PHP4 And PHP5 On Same Server

PHP has now been widely used as a development platform for web-based applications. As PHP is in continued development process, we observe different enhancements in PHP itself. One of the major changes we have recently observed is the release of its new version PHP5.
Now your application is developed in PHP4 and you want to upgrade [...]