MYdb : The opensource database

Function List

Here is a list of functions as of MYdb lite 1.0 beta. This is the PHP List. Please check soon for the PSP version when I release the PSP and python versions.

Open Database

Function: mydb_open(Database , Username , Password);
Requires: include("mydb.inc.php");
Description: Opens a database with username and password. Requires mydb.inc.php to be included

Close Database

Function: mydb_close(Database);
Requires: include("mydb.inc.php");
Description: Closes a database. Requires mydb.inc.php to be included.

New Record Sheet

Function: mydb_newsheet(Database , SheetName);
Requires: include("mydb.inc.php");
Description: Makes a new record sheet in the current database.
Returns: $ret will return "created"

Delete Record Sheet

Function: mydb_delsheet(Database , SheetName);
Requires: include("mydb.inc.php");
Description: Deletes a record sheet in a current database.
Returns: $ret will return "deleted"

Edit Record

Function: mydb_editrec(Database , RecordSheet , OldVal1 , String);
Requires: include("mydb.inc.php");
You MUST specify the OldVal1 which is the first value in the collum. It was what used to be there.
Description: Edit a record in a record sheet.

Add Record

Function: mydb_addrec(Database , RecordSheet , String);
Requires: include("mydb.inc.php");
Description: Add a record to a record sheet

Delete Record

Function: mydb_delrec(Database , RecordSheet , Val1 , String);
Requires: include("mydb.inc.php");
You must specify the Val1 which is the first value in the collum.
Description: Delete a record from a record sheet

Write Record

Function: mydb_writesheet(Database , Recordsheet , String);
Requires: include("mydb.inc.php");
Description: Write to a record sheet (overwrites everything)

Open Record

Function: mydb_openrec(Database , Recordsheet);
Requires: include("mydb.inc.php");
Description: Open record sheet values into an array
Returns: array is put into the value $return (on mydb.inc.php)

List Sheet

Function: mydb_listsheet(Database);
Requires: include("mydb.inc.php");
Description: Lists all sheets to $list as an array. Note ignore the .db after every one.
Returns: $list will return it as an array

View Sheet

Function: mydb_openrec(Database , Sheet);
Requires: include("mydb.inc.php");
Description: View a sheet.
Returns: $return will return it as an array