New version 3.3.0 of ApPHP Shopping Cart was released

The new version 3.3.0 of ApPHP Shopping Cart script is available now for downloading. There are some bugs fixed and many new additions and improvements.

ApPHP Shopping Cart is a powerful hotel management and on-line reservation site script. This script is the fully functional PHP solution to manage small to medium size of hotels, holiday flats or guesthouse.

Here the main additions and

New version 6.4.1 of ApPHP DataGrid Pro released

The new version 6.4.1 of PHP DataGrid is available now for downloading. There are many improvements and new features, like possibility to move records, 3 PostBack methods - GET, POST and AJAX, caching for feature, possibility to allow image and file re-uploading etc. This version requires full re-installation, if you work with one of previous. Read carefully Getting Started.Here the main

New version 2.3.2 of ApPHP Hotel site was released

The new version 2.3.2 of ApPHP Hotel Site script is available now for downloading. There are some bugs fixed and many new additions and improvements. ApPHP Hotel Site is a powerful hotel management and on-line reservation site script. This script is the fully functional PHP solution to manage small to medium size of hotels, holiday flats or guesthouse. Here the main additions and

New version 3.1.7 of JS Auto Form Validator Pro released

The new version 3.1.7 of JS Auto Form Validator Pro is available now for downloading. There are some bugs fixed and also new additions and improvements. The JS Auto Form Validator Pro is an easy-to-setup form validation script which enables you to handle the whole form validation process without writing any JavaScript code. Here the main additions and improvements:* Feature: [added] possibility

New version 3.0.4 of ApPHP EasyInstaller Pro released

The new version 3.0.4 of PHP EasyInstaller is available for downloading from here. There are many new features were added and improved in this version, like multi-database and multi-language support, updating and un-installation etc. Read carefully Getting Started. There are some important changes and additions in this version: * Feature: [added] software version parameter in settings* Feature: [

New version 3.4.2 of ApPHP MicroCMS Pro released

We are happy to announce that new update for ApPHP MicroCMS was released and available now for downloading. PHP MicroCMS (PHP MCMS) is a simple, but very powerful Content Management System that everyone can use. This script can be installed easily by web developers, webmasters, graphic designers, etc. PHP MCMS was developed in OOP and allows you to build websites in a few minutes and then easy

New version 3.0.9 of ApPHP DataForm Pro released

The new version 3.0.9 of PHP DataForm Pro is available now for downloading. There are many improvements and new features like possibility to use customized layouts, email notification on successful insertion etc. This version requires full re-installation, if you work with one of previous. Read carefully Getting Started.Here the main additions and improvements:* Feature: [added] new language

New version 6.1.1 of ApPHP DataGrid Pro released

The new version 6.0.8 of PHP DataGrid is available now for downloading. There are many improvements and new features like possibility to clone records, 3 PostBack methods - GET, POST and AJAX, caching for Details Mode, possibility to allow image and file types for uploading etc. This version requires full re-installation, if you work with one of previous. Read carefully Getting Started.Important

New version 2.0.2 of ApPHP TreeMenu released

The new version 2.0.2 of ApPHP TreeMenu is available now for downloading. There are some new additions and improvements in this version.The ApPHP TreeMenu is a PHP script that generates multilevel tree menu control. It was specially designed for web developers. Tree menu is one of the most popular and commonly used navigation controls and it allows you to set up and use in no time. Here the main

New version 3.0.6 of ApPHP Calendra Pro is released

The new version 3.0.6 of ApPHP Calendar Pro is available now for downloading. There are some bugs fixed and also many additions and improvements. This version requires full re-installation, if you work with one of previous. Here the main additions and improvements:* Feature: [added] possibility to add events repeatedly via Events -> Add Event -> Add occurrences for this event [Repeatedly] *

New product released: ApPHP Hotel Site!

ApPHP Hotel Site is a powerful hotel management and on-line reservation site script. This script is the fully functional PHP solution to manage small to medium size of hotels, holiday flats or guesthouse.Visitors of Hotel site will be able to search rooms availability with an online booking reservation system. They also could view rooms inventory, check availability, and book reservations in a

New version 3.0.6 of ApPHP AdminPanel

The new version 3.0.6 of PHP AdminPanel Pro is available now for downloading. There are many bugs fixed and also Many NEW additions and improvements. This version requires full re-installation, if you work with one of previous. All recent changes can be viewed here.

Check here our Tour and Screenshots!

And new DataGrid Pages Wizard Online DEMO

The Features:
• Feature: [added] possibility for

ApPHP MicroBlog PHP MicroBlog Pro 2.1.1 released

The new version 2.1.1 of ApPHP MicroBlog Pro available for downloading from here.ApPHP MicroBlog (ApPHP MicroB) is very simple and powerful PHP blog software. This product enables you to start your own blog within minutes. You can easy add and manage your posts and posting categories. Here are the main changes and additions in this version:* Feature: [added] search possibility* Feature: [added]

New version 3.0.1 of ApPHP Tabs (AJAX Enabled) released

The new version 3.0.1 of ApPHP Tabs Pro (AJAX Enabled) is available for downloading from here.ApPHP Tabs Pro - PHP script for generating multilevel tab menu control.Here are the main changes and additions in this version:• Feature: [added] submission using AJAX• Feature: [added] new options for displaying child tabs• Feature: [added] possibility to open tabs in a new window• Feature: [added]

How to remove excess whitespaces from a string?

I was looking for a small and quick way to remove excess whitespaces from a string. Sometimes you get SQL statement (or any other string) with whitespaces and need to clean it before your function starts to work with it.For example: $sql = "SELECT id, field1, field2 .... FROM table WHERE status = 1";And after trying some ways we found, that using preg_replace() function is

New version 6.0.8 of PHP DataGrid released

The new version 6.0.8 of PHP DataGrid is available now for downloading. There are many improvements and new features, like caching, drawing horizontal "barchart" fields, file extension icons etc. This version requires full re-installation, if you work with one of previous. Read carefully Getting Started.Here the main additions and improvements:* Feature: [added] possibility to show count of

ApPHP Shopping Cart - New Product Release

We are happy to announce that new product ApPHP Shopping Cart Advanced was released and available now for downloading from the site.A Short List of Features: * Virtual multiple product shopping cart * Multi-Language * Multi-Currency * Orders management and history * Integrated PayPal module * Admins/Customers management * News module * Gallery module * Contact Us module

New version 3.1.0 of ApPHP MicroCMS released

We are happy to announce that new update for ApPHP MicroCMS was released and available now for downloading. A Short List of Features for v3.1.0: * One-Year FREE Updates * Fully functional WYSIWYG * Easy installation * Embedded CSS Design Templates * Customized header/footer * Site/Pages META tags creating/editing * WYSIWYG pages editor * Using of

Count number of rows with php mysql

This is a small script which will help you find the number of rows from a mysql database for your query.

First connect to your database, just create a database connection file.

<br />// Connect to the database<br /><br />include "connect.php";<br /><br />// Query the database and get the count<br /><br />$result = mysql_query("SELECT * FROM tablename");<br /><br />$num_rows = mysql_num_rows($result);<br /><br />// Display the results<br /><br />echo $num_rows;<br />

so now you can use this $num_rows variable throughout your program for any manipulation.

New version 2.0.1 of ApPHP TreeMenu released

The new version 2.0.1 of ApPHP TreeMenu is available now for downloading. There are some new additions and improvements in this version. The ApPHP TreeMenu is a PHP script that generates multilevel tree menu control. It was specially designed for web developers. Tree menu is one of the most popular and commonly used navigation controls and it allows you to set up and use in no time. Here the

New version 3.0.4 of ApPHP Calendar released

The new version 3.0.4 of ApPHP Calendar is available now for downloading. There are mansome bugs fixed and also many additions and improvements. This version requires full re-installation, if you work with one of previous. Here the main additions and improvements:* Feature: [added] possibility to work with events, related to certain user by using SetUserID() method * Feature: [added]

New version 6.0.7 of PHP DataGrid released

The new version 6.0.7 of PHP DataGrid is available now for downloading. There are many improvements and new features, like new field types ("color", "percent"), new PEAR database drivers, new version of JS AFV using etc. This version requires full re-installation, if you work with one of previous. Read carefully Getting Started. Here the main additions and improvements:* Feature: [added] in

New product released: ApPHP TreeMenu!

The ApPHP TreeMenu is a PHP script that generates multilevel tree menu control. It was specially designed for web developers. Tree menu is one of the most popular and commonly used navigation controls and it allows you to set up and use in no time.It has a collapsible vertical tree listing, that resembles the Windows Explorer folder view. It also makes it easier for visitors of your website to

Create Guestbook / Shoutbox in php, mysql with css

Hi everyone,
Today i am going to show you how to Create Guestbook / Shoutbox in php mysql, in a very easy way and with simple code.
First thing that you might be thinking is what is a Guestbook or Shoutbox ?
These are the places where your website visitors or users can type their views or some information in a simple box.
In this program we are going to create a simple shoutbox / Guestbook which will allow your website visitor to enter some simple data about your website.

So lets start,
First we need to create the table which will store our data into database.
Create the table structure in your MySQL database as follows

<br /><br />CREATE TABLE `guests` (<br /> `id` int(10) NOT NULL auto_increment,<br /> `name` varchar(50) NOT NULL default '',<br /> `message` varchar(255) NOT NULL default '',<br /> `date` varchar(50) default 'CURRENT_TIMESTAMP',<br /> `guestip` varchar(30) NOT NULL default '',<br /> PRIMARY KEY (`id`)<br />) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;<br /><br />

After creating database and table you need to create a database connection file.
If you don't know how to create a database connection file then you should check this.
Specify the settings in database connection file.

Now we will be creating a form which will accept user's name and their shout or opinion.
So lets design it.
If the form is not posted then we will display the form and show the existing records from the database.

if (!isset($_POST["submit"])) 
{
 $query = "SELECT id, name, message, DATE_FORMAT(date, '%D %M, %Y') as newdate FROM guests ORDER BY id DESC LIMIT 0, 8";
    $result = mysql_query($query);
?>

Post a message


    
Name:

    
    
 
    
Your message:

    
    
    

    
    




 }
?>

So now you will see a form which will show you a textbox and a textarea for entering name and some shout. Just enter name and shout and click submit.

Now is the actual part of entering shout into database and come back to entry page.
So now we will be checking if the form is submitted then we will process the form.

For security we will be adding a simple spam comment prevention logic, we will not allow one ip to enter more than 5 shouts, comments to our form on same day.

$name = stripslashes($_POST['name']);
$message = stripslashes($_POST['msg']);


if(isset($_POST["submit"]))
{
    // Add new entry to the database
 $ip = $_SERVER['REMOTE_ADDR'];
 $now = date("Y-m-d");

 $query1 = "SELECT * FROM guests WHERE guestip='$ip' and date ='$now'";
    $result1 = mysql_query($query1);
 $cnt = mysql_num_rows($result1);

 if($cnt<5)
 { 
  $now = date("Y-m-d");
  $query = "INSERT INTO guests (name, message, date, guestip) VALUES ('$name','$message','$now','$ip')";
  $result = mysql_query($query) or die(mysql_error());  
  // go back to entry page
  $referer = $_SERVER['HTTP_REFERER'];
  header ("Location: $referer");
 }
 else
 {
  echo "Thank you for your comments. But you cannot submit more comments today as its a spam prevention mechanism to avoid spammers.";
  echo "
If you are a spammer then just GO away.";
 }
}

And you are done. Our shoutbox is ready to accept your website viewers shouts.

Now some interesting part to design your form and display with css

So you are ready with a nice looking shoutbox.
See here is the full source code for your testing

//code
<?php

// Database Settings

include "connect.php";

//connecting to databae and selecting database
mysql_connect($host, $user, $pass) OR die ("Error connecting to the server.");
mysql_select_db($db) OR die("Error selecting the database.");     

$name = stripslashes($_POST['name']);
$message = stripslashes($_POST['msg']);


if(isset($_POST["submit"]))
{
    // Add new entry to the database
 $ip = $_SERVER['REMOTE_ADDR'];
 $now = date("Y-m-d");

 $query1 = "SELECT * FROM guests WHERE guestip='$ip' and date ='$now'";
    $result1 = mysql_query($query1);
 $cnt = mysql_num_rows($result1);

 if($cnt<5)
 { 
  $now = date("Y-m-d");
  $query = "INSERT INTO guests (name, message, date, guestip) VALUES ('$name','$message','$now','$ip')";
  $result = mysql_query($query) or die(mysql_error());  
  // go back to entry page
  $referer = $_SERVER['HTTP_REFERER'];
  header ("Location: $referer");
 }
 else
 {
  echo "Thank you for your comments. But you cannot submit more comments today as its a spam prevention mechanism to avoid spammers.";
  echo "
If you are a spammer then just GO away.";
 }
}

if (!isset($_POST["submit"])) 
{
 $query = "SELECT id, name, message, DATE_FORMAT(date, '%D %M, %Y') as newdate FROM guests ORDER BY id DESC LIMIT 0, 8";
    $result = mysql_query($query);
?>

Post a message


    
Name:

    
    
 
    
Your message:

    
    
    

    
    




 <?php
}
?>

Let us know whether you liked it or not. This is just a basic sample example for you.
Its not fully secure. If you know some simple function to prevent bots using this for data entry then let me know.

New version 2.0.2 of ApPHP Tabs was released.

The new version 2.0.2 of ApPHP Tabs is available for downloading from here.ApPHP Tabs - PHP script for generating multilevel tab menu control.Here are the main changes and additions in this version: • Feature: [added] possibility to link tabs to PHP-files• Feature: [added] possibility to change container's color and its border• Feature: [added] possibility to choose between GET and POST

New version 3.0.3 of ApPHP Calendar was released.

The new version 3.0.3 of ApPHP Calendar is available now for downloading. There are many bugs fixed and also some new additions and improvements, like events managing, multi-language support, statistics module etc. This version requires full re-installation, if you work with one of previous.



Here the main additions and improvements:

* Feature: [added] possibility to display Events in

How to Extract Domain name from URL ?

Hi,

Here is a simple function which can be used to parse the URL.

parse_url is a built in php function which can be used to parse url and get the type of request like whether its http or https or ftp, gives the domain name like www.google.com and path and the query.

eg. consider this url - http://www.chaprak.com/articles.php?cat_id=6

In http://www.chaprak.com/articles.php?cat_id=6 this url if you execute parse_url function then it will show the following result.

scheme - http
url - www.chaprak.com
path - /articles.php
query - cat_id=6

<br /><?php<br />$url = "http://www.chaprak.com/articles.php?cat_id=6";<br />$parts = parse_url($url);<br />print_r($parts);<br /><br />echo "<br>scheme - $parts[scheme]";<br />echo "<br>url - $parts[host]";<br />echo "<br>path - $parts[path]";<br />echo "<br>query - $parts[query]";<br />?><br />

For more information click here.

New Version 2.0.2 of JS Auto Form Validator was released.

The new version 2.0.2 of JS Auto Form Validator is available now for downloading. There are some bugs fixed and also new additions and improvements. The JS Auto Form Validator is an easy-to-setup form validation script which enables you to handle the whole form validation process without writing any JavaScript code. Here the main additions and improvements:* Feature: [added] new language

How to find the Best DataGrid in PHP. Top 10 of PHP DataGrid Components and comparative analysis.

I decided to write this post, because I wanted to get a full picture of what's going on with datagrid components in PHP.Also I want to compare prices, functionality and other features for the major PHP datagrid components. I understand, that this is not professional investigation, but I hope I could make good enough and useful.Ok, so... let start and check them!After 15-minutes check and search,

New Version 2.0.1 of PHP Tabs was released.

ApPHP Tabs - PHP script for generating multilevel tab menu control.The ApPHP Tabs is a simple PHP script that generates multilevel tab menu control which consists of nice-looking tabs. It may be useful for web developers who appreciate their time and do not want to waste it on boring work but instead focus on really challenging tasks. It takes you only few seconds to add or remove a tab. You can

New Version 2.0.5 of PHP EasyInstaller was released.

The new version 2.0.5 of PHP Easy Installer is available for downloading from here. There are some changes in this version. Read carefully Getting Started. There are some important changes and additions in this version: • Feature: [added] blocked autocomplete for textboxes by autocomplete='off'• Feature: [added] possibility to allow encoding for SQL dump files and type of encodding and collation

The new version 2.0.2 of PHP DataForm was released.

The new version 2.0.2 of PHP DataForm is available now for downloading. There are many bugs fixed and also some new additions and improvements. This version requires full re-installation, if you work with one of previous. PHP DataForm (PHP DF) script is a simple tool for creating HTML Forms with ease. It was especially designed for web developers, who do not want to spend excessive time on