Showing posts with label database. Show all posts
Showing posts with label database. Show all posts

Sunday, June 19, 2016

Flatfile Database Manager PHP Script Manage Flatfile Database With This PHP Script

A flat file is a file that contains records. Each record is specified in a single line. Fields from each record may either have a fixed width, or may be delimited by commas (CSV), tube (|), whitespace, tabs, or any other character.
Flat File Database Manager will allow you to manage (update/delete/add) records in your flatfile database.
Note: Currently flat files of fixed field width are not supported. Features:
  • user defined delimiter (usually pipe, colon, or comma (|:,)
  • customizable presentation of different data types. Following data types supported:
    • LIST - Rendered as list box or combo box.
    • STRING - Rendered as regular input field.
    • LOGICAL - Rendered as check box (flag).
    • TEXT - Rendered as text area.

    Download Flatfile Database Manager PHP Script

Tuesday, June 14, 2016

WebSite Backup Database mySQL Backup

These classes are made by ThoR® aka Kender functioning to back up files and MySQL database. You can download it here (6kb).

Below are the instructions of use and sample of how to use it:

INSTRUCTIONS

/********************************
BACKUP OF FILES
*********************************/
$mkBackup = new BackUp;
this initialize the class

$mkBackup->WhatBackup(PATH_TO_SAVE);
this set which folder will be compressed
Relative path. Full path should work. No final "/"

$mkBackup->WhereBackup(MOVE_COMPRESSED_FOLDER_HERE);
this set in which folder the compressed archive will be saved
Relative path. Full path should work. No final "/"

$mkBackup->FileName(NAME_OF_ARCHIVE);
this set the name to give to archive
you can create name on-the-fly, using date(); or whatever you want

$mkBackup->Debug();
if you want to display all the infos about compression
This will display all vars set before: What Backup, Where, and name of archive
Nothing more...

/********************************
BACKUP OF DATABASE
*********************************/
$mkBackup = new BackUp;
this initialize the class

$mkBackup->DBFileName(NAME_OF_SQL_FILE);
this set the name of file of SQL Dump, and save it directly to server
Relative path. Full path should work.

$mkBackup->SaveAs(NAME_OF_SQL_FILE);
this set the name of file of SQL Dump, and ask to "save as..." to save it on own disk...
if this is set, the "DBFileName" function of the class, is ignored

$mkBackup->DBMakeBackup("server","port","user","password","database_name");
this create the backup. Vars are very simple:
server is the mySQL server (if empty, "localhost" is used)
port is the port of mySQL server (if empty, "3306" is used)
user is the user used to connect to mySQL server (if empty, "root" is used)
password is the password used to connect to mySQL server (if empty, empty password is used)
database_name is the name of the Database to save (if empty, it will display an error)

/********************************
BACKUP EXAMPLE
*********************************/
Backup files:

$mkBackup = new BackUp;
$mkBackup->WhatBackup("www/mysite");
$mkBackup->WhereBackup("www/backup");
$filename = date("Y_m_d__H_i_s___WebSiteBackup");
$mkBackup->FileName($filename);
$mkBackup->Backup();

Database Backup, directly on server:

$mkBackup = new BackUp;
$mkBackup->DBFileName("www/backup/2004_05_18__TestingBK.sql");
$mkBackup->DBMakeBackup("localhost","","root","","my_database");

Database Backup, save as...:

$mkBackup = new BackUp;
$mkBackup->SaveAs("2004_05_18__TestingBK.sql");
$mkBackup->DBMakeBackup("localhost","","root","","my_database");


Saturday, June 11, 2016

Database Servers Down Alarm

This class is made by Alexander Selifonov and can be used to send alarm messages when databases are down.

It can check one or more database servers by connecting to them to see if they are up or down.

The class can send an alert e-mail or SMS message to the systems administrators when a database server is down.

When the database server is up, another alert message is sent.

Currently it supports checking multiple types database servers: MySQL, Mini-SQL, Microsoft SQL Server, IBM DB2, Oracle, PostgreSQL, etc..

You can download the packeage from here (12 kb !!).

In the package are:
as_dbserver_check.php Class main class module
checkdb.php Example using sample
as_dbserver_check.en.htm Doc. Documentation (english)
as_dbserver_check.ru.htm Doc. Documentation (russian)

License: BSD License




Thursday, June 9, 2016

Automatic Database Installer PHP Script

Micro DB Installer is a small PHP script which helps you to automate MySQL database creation. If you dont want to use web your existing web admin interface or you want to extend your script with easy DB installation then you can use this tool.

Installation:


You only need to upload some file and your SQL file and visit the Micro DB Installer page. You need to define host-name, user-name and password and the script executes the SQL file and prompt you the result.

Download Automatic Database Creator PHP Script


Monday, June 6, 2016

cPanel Database Creator PHP Script

cPanel php script does not allow you to create databases directly from MySQL/PhpMyAdmin on cPanel webhosting. You would have to login to cPanel and use its interface to create database each time you need a new one.
cPanel Database Creator will make this process much easier. In order to create a database on your hosting server you just need to run this script from browser, shell, or cron job, passing database name as parameter.

Before using this script you will need to update it with cPanel username, password, and host name (domain or IP).

Usage: cpanel_create_db.php?db=database-name&user=username&pass=password
where database-name should be replaced with a database name to be created on your hosting server.
Database Creator will also create a database user and assign it to the database with ALL permissions. Script will not create database user if you omit the user parameter. In this case usage would be cpanel_create_db.php?db=database-name

Note: if script does not work try running it via cURL. This requires cURL installation on the server. Default cURL path is set to /usr/bin/curl. Feel free to change it in the script code if cURL path is different on your hosting server.

Download cPanel Database Creator PHP Script

Saturday, June 4, 2016

Optimize All Tables In A MySQL Database

If you have a database driven site and you want to optimize MySQL tables then this is perfect. It goes through all the tables in a MySQL database and does table optimization on each one using the MySQL Optimize Table syntax.

<?php 
dbConnect() 
$alltables = mysql_query("SHOW TABLES"); 
while ($table = mysql_fetch_assoc($alltables)) 
   foreach ($table as $db => $tablename) 
   { 
       mysql_query("OPTIMIZE TABLE ".$tablename."") 
           or die(mysql_error()); 
   }     
?>



Saturday, May 14, 2016

Database to XML Converter PHP Script

This small tool helps you to convert your MySQL database layout into XML. Just specify connection information and you can display or save the generated XML output.

Download Database to XML Converter PHP Script

Friday, May 13, 2016

How To Add Radio Button Value In Database In PHP

Today I will share a working script example which will help you to insert radio button value in database using PHP.

<?php
if(isset($_POST[submit]))
{
$number=$_POST[number];
if($number!="")
{
$query=mysql_query("UPDATE users SET number = $number WHERE name = ".$user->name.";");
if($query)
{
header(Location: /me);
}
else
{
$error_message = <font color="red"><strong>Please choose a number.</strong></font><br /><br />;
}
}
}
?>


<form method="post" action="">
<input type="radio" name="number" value="1" />1
<input type="radio" name="number" value="2" />2
<input type="radio" name="number" value="3" />3
<input type="submit" name="submit" />
</form>
?>

This simple script will enable you to add radio button values in database easily.Hope you found this post useful.

Enjoy!


Wednesday, May 11, 2016

PHP Data Insert Into MySQL Database

In this post i will show you that how to insert data into mysql database , this tutorial will use php , html and mysql together and using html user friendly form that get some information and inserts the data into mysql database specified table,  using some php functions and mysql insert query it’s easy to insert data into database table , so let’s have a look.


Read more »

Tuesday, February 2, 2016

Database Processing 12th Edition Download Free eBook

Database Processing (12th Edition) Download Free Ebook
Database Processing (12th Edition) Download Free Ebook

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book.
Get straight to the point of database processing.
Database Processing reflects a new teaching method that gets readers straight to the point with its thorough and modern presentation of database processing fundamentals.
The twelfth edition has been thoroughly updated to reflect the latest software.


  • By
    David M. Kroenke , David Auer
  • Pages
    640
  • Year
    2011
  • Publisher
    Prentice Hall
  • Language
    English
  • ISBN
    978-0132145374
  • File Size
    25.48 MB
  • File Format
    PDF


Database Processing (12th Edition) Download Free eBook below:




Download This Book for Free


Please Take Some Time To Share this Ebook or Like Our FB Page for more Updates

Report Any Broken Download Links in Comments and We will fix it for You.