PHP create_test_table Examples

Example #1

File: test.php Project: UiL-OTS-labs/babylab-admin

 /** Specifies the contents of the default page. */
 public function index()
 {
     $add_url = array('url' => 'test/add', 'title' => lang('add_test'));
     create_test_table();
     $data['ajax_source'] = 'test/table/';
     $data['page_title'] = lang('tests');
     $data['action_urls'] = array($add_url);
     $this->load->view('templates/header', $data);
     $this->authenticate->authenticate_redirect('templates/list_view', $data, UserRole::Admin);
     $this->load->view('templates/footer');
 }

Example #2

File: mysql_num_rows.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('num_rows'));
var_dump(mysql_query("insert into test_num_rows (name) values ('test'),('test2')"));
$res = mysql_query('select * from test_num_rows');
var_dump(mysql_num_rows($res));

Example #3

File: mysql_affected_rows.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('affected_rows'));
var_dump(mysql_query("INSERT INTO test_affected_rows (name) values ('test'),('test2')"));
var_dump(mysql_affected_rows());

Example #4

File: mysql_fetch_assoc.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('fetch_assoc'));
var_dump(mysql_query("insert into test_fetch_assoc (name) values ('test'),('test2')"));
$res = mysql_query('select * from test_fetch_assoc');
$row = mysql_fetch_assoc($res);
print_r($row);

Example #5

File: mysql_fetch_row.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('fetch_row'));
var_dump(mysql_query("insert into test_fetch_row (name) values ('test'),('test2')"));
$res = mysql_query('select * from test_fetch_row');
$row = mysql_fetch_row($res);
print_r($row);

Example #6

File: mysql_num_fields.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('num_fields'));
var_dump(mysql_query("INSERT INTO test_num_fields (name) VALUES ('test'),('test2')"));
$res = mysql_query('select * from test_num_fields');
var_dump(mysql_num_fields($res));

Example #7

File: mysql_field_len.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('field_len'));
var_dump(mysql_query("insert into test_field_len (name) values ('test'),('test2')"));
$res = mysql_query('select * from test_field_len');
var_dump(mysql_field_len($res, 1));

Example #8

File: mysql_fetch_lengths.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('lengths'));
var_dump(mysql_query("insert into test_lengths (name) values ('test'),('test2')"));
$res = mysql_query('select * from test_lengths');
$row = mysql_fetch_row($res);
$lengths = mysql_fetch_lengths($res);
print_r($lengths);
// A much more intense test on lengths
mysql_query('drop table testlen');
var_dump(mysql_query("create table testlen (id int not null auto_increment, " . "d decimal(10,5), t tinyint, i int, b bigint, f float, " . "db double, y2 year(2), y4 year(4), primary key (id)) " . "engine=innodb"));
var_dump(mysql_query("insert into testlen(d, t, i, b, f, db, y2, y4) values" . "(.343, null, 384, -1, 03.44, -03.43892874e101, 00, 0000)"));
$res = mysql_query('select * from testlen');
$row = mysql_fetch_row($res);
$lengths = mysql_fetch_lengths($res);
print_r($lengths);

Example #9

File: mysql_data_seek.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('data_seek'));
var_dump(mysql_query("insert into test_data_seek (name) values ('test'),('test2')"));
$res = mysql_query('select * from test_data_seek');
var_dump(mysql_data_seek($res, 1));
$row = mysql_fetch_assoc($res);
print_r($row);

Example #10

File: mysql_field_flags.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('field_flags'));
var_dump(mysql_query("insert into test_field_flags (name) values ('test'),('test2')"));
$res = mysql_query('select * from test_field_flags');
var_dump(mysql_field_flags($res, 0));

Example #11

File: mysql_result.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('result'));
var_dump(mysql_query("insert into test_result (name) values ('test'),('test2')"));
$res = mysql_query('select * from test_result');
var_dump(mysql_result($res, 1, 1));

Example #12

File: mysql_warning_count.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
// No warnings from normal operation
var_dump(create_test_table('warning'));
var_dump(mysql_warning_count($conn));
var_dump(mysql_query("INSERT INTO test_warning (name) VALUES ('test'),('test2')"));
var_dump(mysql_warning_count($conn));
// Dropping a non-existent table with IF EXISTS generates a warning.
var_dump(mysql_query("DROP TABLE IF EXISTS no_such_table"));
var_dump(mysql_warning_count($conn));
// Dropping an existing table generates no warnings.
var_dump(mysql_query("DROP TABLE IF EXISTS test_warning"));
var_dump(mysql_warning_count($conn));

Example #13

File: mysql_field_type.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('field_type'));
var_dump(mysql_query("insert into test_field_type (name) values ('test'),('test2')"));
$res = mysql_query('select * from test_field_type');
var_dump(mysql_field_type($res, 1));

Example #14

File: mysql_field_name.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('field_name'));
var_dump(mysql_query("insert into test_field_name (name) values ('test'),('test2')"));
$res = mysql_query('select * from test_field_name');
var_dump(mysql_field_name($res, 1));

Example #15

File: mysql_unbuffered_query.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('un_query'));
var_dump(mysql_query("insert into test_un_query (name) values ('test'),('test2')"));
$res = mysql_unbuffered_query('select * from test_un_query');
$row = mysql_fetch_assoc($res);
print_r($row);
$row = mysql_fetch_assoc($res);
print_r($row);
$row = mysql_fetch_assoc($res);
var_dump($row);

Example #16

File: mysql_free_result.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('free_result'));
$res = mysql_query('select * from test_free_result');
var_dump(mysql_free_result($res));

Example #17

File: mysql_field_seek.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('field_seek'));
var_dump(mysql_query("insert into test_field_seek (name) values ('test'),('test2')"));
$res = mysql_query('select * from test_field_seek');
var_dump(mysql_field_seek($res, 1));
var_dump(mysql_fetch_field($res)->name);

Example #18

File: mysql_info.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('info'));
var_dump(mysql_query("insert into test_info (name) values ('test'),('test2')"));
var_dump(mysql_info());

Example #19

File: mysql_fetch_object.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('fetch_object'));
var_dump(mysql_query("insert into test_fetch_object (name) values ('test'),('test2')"));
$res = mysql_query('select * from test_fetch_object');
$row = mysql_fetch_object($res);
var_dump($row->name);

Example #20

File: mysql_fetch_array.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('fetch_array'));
var_dump(mysql_query("insert into test_fetch_array (name) values ('test'),('test2')"));
$res = mysql_query('select * from test_fetch_array');
$row = mysql_fetch_array($res);
print_r($row);

Example #21

File: mysql_insert_id.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('insert_id'));
var_dump(mysql_query("insert into test_insert_id (name) values ('test'),('test2')"));
var_dump(mysql_insert_id());

Example #22

File: mysql_fetch_field.php Project: badlamer/hhvm

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(create_test_table('fetch_field'));
var_dump(mysql_query("insert into test_fetch_field (name) values ('test'),('test2')"));
$res = mysql_query('select * from test_fetch_field');
var_dump(mysql_fetch_field($res, 1)->name);