Mysql like flat file database system.
Version: Alfa2
Declaration:
Create table:
Insert a new row:
Update row:
[PHP
$statement = "UPDATE users SET age=%, town=% WHERE unique=Max";
//or $statement = "UPDATE users SET age=%, town=%";
$texty->query($statement, 35, 'L.A');
[/PHP]
Select users
Delete from:
Debug:
Free result:
All methods of Texty class have a function eg: $texty->password(); and texty_password();
except $texty->query();
This versios has some bugfixes and some rewritten facilities.
In the next version: (coming next days)
- Database indexes: eg: $texty->query("SELECT * FROM users WHERE age=%s", 22);
- Prepared statements
- maybe a panel for managing the databases
- bug fixes
I want your feedback!
Thx in advance.
Version: Alfa2
Declaration:
PHP Code:
require('Texty/texty.php');
$db = texty_connect(); //or $texty->connect();
PHP Code:
texty_create_table('photos#name,link'); // or $texty->create_table('');
PHP Code:
$statement = "INSERT IN photos SET name=%, link=% WHERE unique=Name";
$texty->query($statement, 'Name', 'google.com');
[PHP
$statement = "UPDATE users SET age=%, town=% WHERE unique=Max";
//or $statement = "UPDATE users SET age=%, town=%";
$texty->query($statement, 35, 'L.A');
[/PHP]
Select users
PHP Code:
$query = $texty->query("SELECT * FROM users");
while ($row = texty_fetch_assoc($query))
echo 'Name = '.$row['name'].'<br/>';
PHP Code:
$texty->query("DELETE FROM users"); // delete all users
$texty->query("DELETE FROM users WHERE unique=test"); // delete unique = x user
PHP Code:
$texty->error(); // or texty_error();
PHP Code:
$texty->free_result(); // texty_free_result();
except $texty->query();
This versios has some bugfixes and some rewritten facilities.
In the next version: (coming next days)
- Database indexes: eg: $texty->query("SELECT * FROM users WHERE age=%s", 22);
- Prepared statements
- maybe a panel for managing the databases
- bug fixes
I want your feedback!
Thx in advance.
Comment