Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- namespace App\MemberBundle;
- use App\MemberBundle\Model\Member;
- use Lignite0\ORM\Database;
- # data from request
- $_POST['member']['username'] = 'admin';
- $_POST['member']['password'] = 'd033e22ae348aeb5660fc2140aec35850c4da997';
- $_POST['member']['somedata'] = '<a href="#">Lorem ipsum dolor</a>';
- $_POST['member']['postalCode'] = '00-000';
- # init database connection, two ways
- $database = new Database('mysql:dbname=database;host=localhost', 'root', '');
- // or
- $database = \PDO('mysql:dbname=database;host=localhost', 'root', '');
- # create new record, without queries yet
- $tableName = "prefix__members_lang_pl";
- $memberTable = new Member\Table($database, $tableName);
- $memberRecord = new Member\Record($memberTable);
- # the filter config array, for more information http://php.net/manual/en/book.filter.php
- $filter = array(
- 'username' => FILTER_DEFAULT,
- 'somedata' => FILTER_SANITIZE_ENCODED,
- 'postalCode'=> array(
- 'filter' => FILTER_CALLBACK,
- 'options' => array(
- 'callback' => function($filteredValue) {
- preg_match('/[\d]{2}-[\d]{3}/', $filteredValues);
- }
- )
- )
- );
- $source = filter_var_array($_POST['member'], $filters)
- try {
- $memberRecord->bindFromArray($source); // binding data to record where array key is a field of object
- $newPrimaryID = $memberRecord->insert(); // query INSERT ...
- } catch (\PDOException $pdoException) {
- // process exception
- } catch (\Exception $exception) {
- // process exception
- }
- var_dump($memberRecord->admin); // string(5) "admin"
- var_dump($newPrimaryID); // e.g. int(5)
- var_dump($memberRecord->getPrimaryID()); // same as above
- var_dump($memberRecord->memberID); // same as above
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement