CODE EXAMPLE FOR PHP

How to generate a create table script for an existing table in php/Codeigniter

//PHP
SHOW CREATE TABLE tablename
// FOR CODEIGNITOR
HOW CREATE TABLE $table_name";         
$query = $this->db->query($sql); 
echo '<pre>'; print_r($query->result());