Tag Archive for 'mysql'

Booking Calendar Lite 1.1 released!

New version of “Booking Calendar Lite” have been released. This great script is best choice to publish if some resource are reserved, occupied or free. It is very quick to setup and easy to manage. In this version you will find a lot of improvements. Here is the list:

  • improved installation script,
  • improved administration – all settings may be changed in admin panel (no need to edit configuration files in notepad as in previous versions),
  • possibility to disable copyright notice with one click  (Powered by…),
  • optimized MySQL queries (less server load and faster responses),
  • some more code cleanup.

If you are interested in new release you may get more details on Booking Calendar Lite page.

Booking Calendar Lite released as free GPL script

I have decided to release some of my code as a free scripts under a GPL licence. My first choice is my “Booking Calendar Lite” written in PHP with MySQL support. Nice script that allow to publish on your website if some resource is free, reserved or occupied (or any other states you set in a config). You may find it under “CODE” section on my blog and see the script with a demo here “Booking Calendar Lite“. I hope you will enjoy my script as much as I did when I was writing it :).

MySQL login details in WordPress

If you have decided to move a copy of your wordpress to other host propably you will have problem with your mysql login details. Even if mysql database name, login and password are same – propably you will have to change login host (until it is not localhost :) ). It is very easy to do. All you need to change after you copy WordPress script to your new account is to edit wp-config.php file. Open it in any text editor (Notepad would be ok), find and edit following lines:

define('DB_NAME', 'put_db_name_here');
define('DB_USER', 'put_db_login_here');
define('DB_PASSWORD', 'put_db_password_here');
define('DB_HOST', 'put_mysql_host_here');

And that’s all :)

URL Shortening Script

Here is a demo of my url shortening script. It let your visitors to make short redirections of their very long url’s (for example it is useful for twitter users where they are limited to 140 characters). Script is made to be as simple as possible. HTML is separated from PHP so it may be customized by editing one HTML file without touching any PHP code! It do not need MySQL database – all data is stored in the file system. Users are redirected by .htaccess file to desired shortcut. Additionally there is administrator backend module to manage (edit/add/delete) url shortcuts. Below you may click for demo installed on my dev server.

Url shortening script frontend

Frontend demo

Url shortening script backend

Backend demo (Login: admin, Password: demo999)

You may get a copy of this script for $30 (installation included) – contact me if interested.

Update: Free version of this script have been released. Click here for more details.

Sort VARCHAR as INT in MySQL query

If you need to sort varchar data as int, there is one very nice function in MySQL. Problem I had to solve was to sort values as below in a human logical way. Values were similar to this (and I wanted it to be sorted like below):

1; 2; 2a; 3; 4; 5; 5a; 5b; 5c; 6; 7; 11; 14; 14a; 16;

The problem was that if I put this data to MySQL database as varchar and sort by this column, MySQL returned it this way:

1; 11; 14; 14a; 16; 2; 2a; 3; 4; 5; 5a; 5b; 5c; 6; 7;
Continue reading…

PayPal shopping cart

Very simple to use PayPal shopping cart. It may be customized by CSS sheet to your needs. You can use any currency supported by PayPal and define any type of products or services to sell. There are two types of groups for selling items – with radio button (client can choose only one option from group) or with checkboxes (client can choose many options from the group). Number of groups in cart is unlimited! All orders details are available thru admin. Additionaly descriptions over and under shopping cart may be customized with simple templates. Script is written in pure PHP and data is stored in MySQL database.

Demo shows example of using this cart for ordering “Wedding photographer”. If it doesn’t, probably someone have already been testing it… Anyway database resets every 24h so I am not going to change this description… :D If you want you may test it by clicking links below.

Shopping cart

Shopping cart demo

Admin panel demo

Admin demo (Login: admin, Password: demo999)

You may get a copy of this script for $30 (installation included) – contact me if interested.

Booking calendar

Calendar with possibility to mark if resources for some date are free or not. There are 3 options: “Reserved”, “Occupied”, “Free”. Calendar is generated by the script and it let users to go through years back and forward. Calendar days are displayed regarding the real dates (feb 29!). Administrator can mark dates just by clicking on one of the calendar cell’s. Script is written in PHP (with MySQL) and JavaScript.

Calendar demo

Calendar demo

You may get a copy of this script for $30 (installation included) – contact me if interested.

Update: Script have been released under GPL license and can be downloaded for free. Click here for more details.

User management backend module

Here is a simple ajax based user management backend written in PHP (with xajax libary). User data is stored in MySQL database. It is just a module that may be customized and used to any new script. Don’t be afraid to test as database resets every 24h.

Module demo (Login: admin; Password: demo999)

Module demo (Login: admin, Password: demo999)