fork download 
  1. create_database('student details')
  2. $this->db->query('use Library');
  3.  
  4. $fields = array(
  5.   'memid' => array(
  6.     'type' => 'INT',
  7.     'constraint' => 9,
  8.     'unsigned' => TRUE,
  9.     'auto_increment' => TRUE
  10.   ),
  11.   'id' => array(
  12.     'type' => 'INT',
  13.     'constraint' => 30
  14.   ),
  15.   'student' => array(
  16.     'type' => 'VARCHAR',
  17.     'constraint' => 30
  18.   ),
  19.   'email' => array(
  20.     'type' => 'VARCHAR',
  21.     'constraint' => 60,
  22.     'unique' => TRUE
  23.   ),
  24.   'phone' => array(
  25.     'type' => 'INT',
  26.     'constraint' => 40
  27.   )
  28.   'coui' => array(
  29.     'type' => 'VARCHAR',
  30.     'constraint' => 40
  31.   )
  32.   'ACTION' => array(
  33.     'type' => 'VARCHAR',
  34.     'constraint' => 40
  35.   )
  36.  );
Success #stdin #stdout 0.02s 25564KB
comments (?)
stdin 
Standard input is empty
stdout 
create_database('student details')
$this->db->query('use Library');

$fields = array(
  'memid' => array(
    'type' => 'INT',
    'constraint' => 9,
    'unsigned' => TRUE,
    'auto_increment' => TRUE
  ),
  'id' => array(
    'type' => 'INT',
    'constraint' => 30
  ),
  'student' => array(
    'type' => 'VARCHAR',
    'constraint' => 30
  ),
  'email' => array(
    'type' => 'VARCHAR',
    'constraint' => 60,
    'unique' => TRUE
  ),
  'phone' => array(
    'type' => 'INT',
    'constraint' => 40
  )
  'coui' => array(
    'type' => 'VARCHAR',
    'constraint' => 40
  )
  'ACTION' => array(
    'type' => 'VARCHAR',
    'constraint' => 40
  )
 );
https://ideone.com/772963
language:
PHP (php 7.3.5)
created:
2 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!