| Ratings | | Unique User Downloads | | Download Rankings |
 42% | | Total: 1,343 | | All time: 2,885 This week: 34 |
|
| Description | | Author |
This class can generate classes to manipulate MySQL table records.
It takes the name of a given MySQL database table and generates code for classes to create, list, update and delete records of that table.
The class also generates scripts to perform each of those database table records operations. | |
 |
|
Innovation award
Nominee: 1x
Winner: 1x |
|
Recommendations
Example
<?php
require_once("Class_crud.php");
$crud = new crud;
$crud->setTable($_GET['table']);
$crud->loadCrudArrays();
if (is-dir($_SERVER['DOCUMENT_ROOT']. "/crud/" .$_GET['table']))
{
echo " The directory for " . $_GET['table'] . " is already established.";
}else
{
@mkdir($_SERVER['DOCUMENT_ROOT'] . "/crud/" . $_GET['table']);
}
$crud->generateClass();
$crud->generateListPhp();
$crud->generateCreatePhp();
$crud->generateUpdatePhp();
$crud->generateDeletePhp();
echo "crud generated";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Generate Crud Sql and forms</title>
</head>
<body>
</body>
</html>
|
Details
System Overview
When developing internet applications, a lot of time is spent maintaining the various MySql database tables. Gray and White wrote this CRUD system about three yeas ago and it has been helpful in many applications.
While developing the Virtual Cash Register system the Jtable Crud system was cloned from Github. That system had many features, including an attractive interface, that the Graynwhite system did not have . Conversely the Graynwhite crud system did generate the four crud files namely: Create, Retreive,Update and Delete.
Private settings
A file entitled crudPrivateSettings.php must be created with the following entries:
-
$this->companyName = "Your Company name ";
-
$this->dbname="the db name you are using";
-
$this->mysqlServer = "The server";
-
$this->mysqlUserName = "usernam";
-
$this->mysqlPassword = "password";
- $this->mysqlDatabase = "data base name";
| |
Applications that use this package |
|
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.
Download
Files
Install with Composer
checkMark.jpg
Class_.php
