All Scripts backed by 10 years in business, free support, free updates and a 30 day money back guarantee.
Download Purchase Programming F.A.Q. Support Contact
Commercial Perl Scripts
All Form Pro Updated
Count It
Form Mailer + Attachments
Client File Manager
Da Godfaddah
Dropbox Updated
FAQ Builder
HT Manager Updated
RegisterHT
Mailing List Server
Page Updater - Text
Page Updater Pro Updated
PS Guestbook Updated
PS Lightning Search Updated
Quick File Mailer
Quick MySQL
Select-A-File
Upload Center
Free Perl Scripts
Access Log Viewer
All Form
Epoch Converter
Error Log Viewer
Invoice Center
PS Upload
Question Manager
Quick CHMOD
QuickHT
Site File Finder
Site File Lister
SSI Tag Maker
Perl Modules
Monger Calendar
Monger File
Monger Mail
Monger Persist
JavaScript Generators
PopUp Windows
Meta Gen
RGB / Hex Converter
Page Colors
Sudoku
Tutorials and FAQs
Cookies
Using CuteFTP
Using WS_FTP
Installing Scripts
Debugging
Utilities
env_vars.pl
backup.pl
restore.pl
check_email.pl
date.pl
dayname.pl
fileage.pl
format_length.pl
format_url.pl
getfile.pl
parse.pl
redirect_html.pl
Free Services
Epoch Converter
TLD Registries
RGB/Hex FInder
Colour Checker
ASCII Codes
Policies
Terms and Conditions
Privacy Policy
Refund Policy
Site Map

Form Processor with no SPAM from robots.

Anti-spam, anti-robot, anti-flame, Guestbook for your website.

Manage Remote websites from your website. Allow clients to update sections of their own web pages.

Secure file manager with upload progress meter. A printer's best friend. Find out more.

Quick MySQL 1.1

Supported Servers : Unix, Linux, FreeBSD, Sun, BSDOS
Price : USD $19.00
Requires : Perl / cgi-bin / MySQL
Version : 1.1
Original Release Date : September 2004
Latest Release Date : March 2009
F.A.Q : Click here for F.A.Q.
Users Guide : Click here for Users Guide

  1. Overview
  2. Requirements
  3. Disclaimer
  4. How to install the program
  5. What are the Quick Table Functions?
  6. What are the Quick DB Functions?
  7. What are the Quick Table Transfer Functions?
  8. What is a Quick Query (Manual)?
  9. What SQL syntax is supported?
  10. What is the recovery area?
  11. Support
  12. Does this program work on mSql?
  13. Will this program work with the DBI API?


Overview
Quick MySQL combines the speed of a number of useful preset functions with the ability to completley control your stored data via direct execution/query of your own SQL statements. There is nothing limiting about this program, after 15 minutes of using it you'll wonder how you ever managed without it!

WARNING: This program is oriented to professional webmasters and programmers with experience in SQL syntax and statements. As such, this is a very powerful program. Misuse of this program can result in the deletion of an entire database with very little or no warning.

Prior to using this program, we strongly suggest you familiarize yourself with its protocol and safe usage methods. Perl Services is not liable for any loss of data or cost to you due to misuse us this program. Note that there is nothing in this program that will cause any deletion of data unless such a command is initiated by you the user. Your use of this program implies acceptance of our usage policies and warnings.

To Top




Requirements
Here are the requirements to run Quick MySQL:

  1. UNIX web server
  2. Perl4 or higher
  3. MySQL database server (any release above 2.0 should be fine).
  4. Mysql.pm module must be installed on the server with it's supporting module Statement.pm. These can be downloaded in the Mysql.pm distribution from CPAN at http://www.cpan.org/.


To Top




Please read the Perl Services Licensing Agreement

By downloading, purchasing, acquiring and/or implementing any PerlServices software, you agree to be bound by the terms and conditions of the distribution policy.

To Top



How to install the program
Installation is fast and easy. First you must make sure the path to Perl is correct at the top of the script (as with all other CGI programs written in Perl). Now, FTP the program onto your server in ASCII format. CHMOD 755.

That's it. The program is installed and ready to run. When you first call the script, you will be presented with the login page:

Login screen shot


Simply enter the Hostname, Database Name, Username and Password for the Database and click the connect button. If the connection is successful then you will be presented with the main program screen ( shown on the Index page ). You may also choose to have the login details remembered for this database by checking the box that is labeled "Remember Password". The details are stored in a persistent cookie. We do not set or use any other cookies in this program! You can easily delete the cookie by unchecking the box labeled "Remember Password". Login details are only stored if the connection was successful. Each database's login details are then added to the "Drop down menu" where if selected, will immediately populate the remaining fields for you.

If your database is running as "localhost", then put "localhost" in the Hostname field.

WARNING: It is recommended that you run this program on a secure server. We always run our copy of it on a secure server only. Why? Do you want someone port sniffing your transmission when your sending out the access information for your database?

If you do install this on a secure server, there is one more step you must take. Because some secure servers resolve the server name differently from what you are entering in your browser, you must manually set the URL to the script. In the script around line 55 you will see the variable "$ScriptURL". Set this variable to the absolute URL to the program. Don't forget the "https://" !!

To Top




What are the Quick Table Functions?
Quick Table Functions
There are six Quick Table functions that you can perform on any table in the working database. The working database is the database you are currently signed into. To access these Quick Table functions, select a table name from the list, select a function by clicking on it's radio button and finally click on the "Execute" button. The page will refresh with the results. The results will be displayed in the recovery area.

The Quick Table Functions available are:

  1. Empty: This will remove all records from the table without altering or dropping the table. This is permanent and irreversible. This Quick Table function is equivalent to:
    "DELETE FROM tablename"


  2. Drop: This will remove all records from the table and drop the table from the database. This is permanent and irreversible. This Quick Table function is equivalent to:
    "DROP TABLE tablename"


  3. Show Contents: This will show the entire contents of the table. I had to choose a format that would be suitable for most people and that would be most useful. Therefore, the contents of the table are displayed in the form of an SQL insert statement (we will customize this output for US$75.00). If necessary, you can cut and paste the resulting lines into a program of your own for execution. They are pre formatted and ready to go.

  4. Show Definitions: This will show the definitions for each column in that table that were defined when the table was created and will include any definitions if the table has been altered/modified since creation.

  5. Re-Build Statement: This will return an SQL Create statement so that you can easily store (the definitions) or rebuild the table somewhere else.

  6. Count Records: This will return an integer representing how many records there are in the table. Remember, each row in the table is a record.


NOTE: Any time you drop a table or add a table or transfer a table, you may need to click on the "Refresh" button to make sure the list of tables is up to date. It's not a bug, it was written that way.

To Top




What are the Quick DB Functions?
Quick DB Functions
There are seven Quick DB Functions that you can perform. These Quick DB Functions will be performed on the current database that you are logged into. These functions are:

  1. Show All Definitions: This will show the definitions for each column of every table in the database. The definitions will be the ones that were established when the table was created and will include any definitions if the table has been altered/modified since creation.

  2. Show All Contents: This will show the entire contents of the database. I had to choose a format that would be suitable for most people and that would be most useful. Therefore, the contents of the table are displayed in the form of an SQL insert statement (we will customize this output for US$75.00). If necessary, you can cut and paste the resulting lines into a program of your own for execution. They are pre formatted and ready to go.

  3. Rebuild All: This will return an SQL Create statement for every table in the database so that you can easily store or rebuild the tables somewhere else.
  4. Count All Records: This will return a series of integers representing how many records there are in each table of the database. Remember, each row in the table is a record.
  5. Server Variables & Server Status: These return specialized information about the database server that will only be of interest if you are administering the database server.
  6. New Connection: Any time you want to get out of the current working database and connect to a new one, click the "New Connection" button. You will be taken back to the main entry screen and the current database pseudo-connection will be destroyed.


To Top




What are the Quick Table Transfer Functions?
Quick Table Transfer Functions
There are three Quick Table Transfer Functions that you can perform on any table in the database. Note that you can only perform the Quick Table Transfer functions on one table at a time.

The first thing you have to do is select a table from the current working database. The current working database tables can be found in the drop down list labeled "From Table". This list is identical to the list under Quick Table Functions. Just remember the table must be selected from the list under Quick Table Transfer.

If you have chosen to "Remember Login" details, you will be able to quickly populate the reamining fields by selecting a Database to transfer to.

When you are rebuilding a table on a remote server or are rebuilding and transferring data to a remote server, you can re-name that table to any legal name you want. Note, if you attempt to Rebuild on remote or Rebuild and transfer to remote, that table name can NOT be on the remote server. If it is already on the remote server, the function will fail. If you wish to take a table on your current working server and copy it to the same database on the same server (in case you want to test some new code without affecting the live data), you can simply specify the current working server as the remote server by filling in the appropriate information.

The Quick Table Transfer Functions that you can perform are:

  1. Rebuild on remote: This will look at the "From Table" selected, extract it's definitions and then rebuild it on the remote server. It is recommended that you immediately check this tables definitions on the remote server.

    NOTE: Due to vagaries in definitions and different versions of MySQL servers, I can not account for every single definition. Therefore, it is recommended that you perform a Quick Table Query for a Re-build statement and check it's veracity. If the rebuild statement is correct, then you may proceed with the Quick Table Transfer function that rebuilds the table on a remote server.

  2. Rebuild & Transfer to remote: This is identical to the above function except that it also transfers the contents of the table to the remote server as well. If it is a large table, then this transfer may be affected by bandwidth, how busy communications channels are, server load, etc. Therefore, after you have performed this function, immediately check the table on the remote server to ensure that all data was transferred to it.

  3. Replace on remote: This function assumes the selected "From Table" has a duplicate on the remote server. That is, a table with the same name and same definitions. The function does two things. First, it erases the data from the table on the remote server and THEN it transfers the data from the current working database to the table on the remote server. If it is a large table, then this transfer may be affected by bandwidth, how busy communications channels are, server load, etc. Therefore, after you have performed this function, immediately check the table on the remote server to ensure that all data was transferred to it. If the table does not exist on the remote server, prior to executing the "Rebuild on remote" or "Rebuild and transfer to remote" the function will fail.

    If the table on the remote server does not have the same definitions, then you will likely only have a portion of the data transferred.


To Top




What is a Quick Query (Manual)?
Quick Query (Manual)
The is the most versatile feature of the program and the most dangerous. In the Quick Query form field, simply enter a properly formatted and syntactically correct SQL statement. When you click the "Quick Manual Query" button, the program will take that SQL statement and process it. There are no warnings, no checks and no cautions. Whatever you enter, will be processed immediately.

You will see the "SQL Samples" drop down list. This list contains several common SQL statements in a generic form. If your not sure about the syntax of a statement, click on the selected operation from the list and a sample of that code will appear in the text entry area.

This program will by default, read everything in that text area as a single SQL statement. You can, however, submit multiple SQL statements and have them all processed. If you want to submit multiple SQL statements, you MUST click the checkbox labeled "Multiple Statements".

I will reiterate here, this is a powerful program. The program will not, however, do anything on it's own. It will only do what YOU tell it to. Therefore, if after processing a function/query you realize that you have irreversibly lost or altered data, it is your OWN fault. There program will only do what YOU tell it to do.

To Top




What SQL syntax is supported?
All standard SQL syntax is supported.

To Top




What is the recovery area?
The recovery area is where you see the results. Everything you process will return a result or query specific data. This returned data will always display in the "Recovery Area".

To Top




Does this program work on mSql?
No. However, we will soon be releasing a version of the program for the mSql database server. Join the Perl Services Mailing List for news and updates including information on new programs and upgrades to programs. Note that your e-mail address will NOT be sold to anyone, we take our clients and friends privacy very importantly.

To Top




Will this program work with the DBI API?
No. However, we will soon be releasing a version of this program that works with the DBI API. Join the Perl Services Mailing List for news and updates including information on new programs and upgrades to programs. Note that your e-mail address will NOT be sold to anyone, we take our clients and friends privacy very importantly.

To Top




MySQL Tips

• Comparison operators
= Equals
< Less than
<= Less than or equal to
> Greater than
>= Greater than or equal to
<> Not equal to
!= Not equal to
LIKE Compare strings


• Mathematical operators
( ) Use parentheses to force precedence
+ add
- subtract
* multiply
/ divide
% modulo


• Conditional operators
|| Logical "or"
| Bitwise "or"
OR Same as Logical "or"
&& Logical "and"
& Bitwise "and"
AND Same as Logical "and"


• Some Common Functions
CONCAT(str1,str2) Concatenates strings
DAYNAME(date) Returns the dayname for the given date
LAST_INSERT_ID( ) Returns the last record ID inserted
LENGTH(column) Returns the length of a string in characters
TRUNCATE(n,n) Returns stated number of decimal places
UNIX_TIMESTAMP( )   Returns the epoch


• Some Aggregate Functions
AVG(column) Average number from returned results
MAX(column) Returns the largest number from returned results
MIN(column) Returns the smallest number from returned results
SUM(column) Returns the sum of all returned results




Note : not all databases support all functions. There are over 100 SQL functions, that can be used alone or nested within one another. You really should buy a book for a complete reference.

To Top




Support Information
If you are unable to set-up this program or are uncomfortable setting up the program then please contact our support department.

We offer an installation service for a fee of US$40. Note that at this stage QuickMySQL will only run on a UNIX server. We plan to release a WINDOWS version for SQL Server 7.0 by October 1st.

If you do not receive a response from our support centre within 24 hours, contact us

To Top






  ©2009 All rights reserved, PerlServices.net. Website hosting by LinuxHostingPlans.com