views:

32

answers:

0

How would it be best to approach this task?

require_once('models/databaseModel.class.php');

class crudModel extends databaseModel{

  public function __construct(){
   parent::__construct();
  }

  public static function create(&$data, $tbl){

  // TEST $data array 
  // $data = array('name'=>'philip','email'=>'[email protected]','age'=>28);

  //This is how I would like $value1
  // ":$name', ':$age',  ':$email' ";

  //This is how I would like $value2
  // "ssi";    

  //MY TEST
  $params = array();

  $results = array();

  foreach($data as $k => $v){
   if(is_string($v)){
    $params = 's';
   }
   if(is_int($v)){
    $params = 'i';
   }

   $results = array_fill(0, count($v), $params);

   if(is_array($results)){
    $value2 = implode('', $results);
   }
  }

  $sql = "INSERT INTO $tbl('".implode(',', array_keys($data))."')VALUES('".$value1."')";
  $stmt = $link->prepare($sql);
  $stmt->bind_params($value2, $value1);
  $stmt->execute();

  }


}