PHP implementation MySQL simple operation class _php skill

Its encapsulated MySQL simple Operation class, has been stuffed in the Ben Framework, based on PDO to write, the code has some nonsense style ...

mysql.class.php

<?php class MySQL extends pdo{public $server;
  Public $database;
  Public $user;
  Public $password;
  Public $sql;
    Public function __construct ($server, $database, $user, $password, $port =3306) {$this->server = $server;
    $this->database = $database;
    $this->user = $user;
    $this->password = $password;
    Parent::__construct ("mysql:host= $server;p ort= $port;d bname= $database", $user, $password);
  $this->query (' SET NAMES utf8 ');
    The Public Function Drop ($table) {$sql = ' drop table '. $table. ';
    $re = $this->query ($sql);
    if ($re) {return true;
    }else{return false; The Public function inserts ($table, $name, $value =null) {$sql = INSERT INTO. $table. '
    (';
    if ($value = = null) {$arrname = Array_keys ($name);
    $arrvalue = Array_values ($name);
    }else{$arrname = explode (' | ', $name);
    $arrvalue = Explode (' | ', $value);
       for ($i =0; $i <count ($arrname); $i + +) {if ($i ==count ($arrname)-1) { $sql = $sql. $arrname [$i];
      }else{$sql = $sql. $arrname [$i]. ","; }} $sql = $sql. ")
    VALUES ("; For ($i =0 $i <count ($arrvalue); $i + +) {if ($i ==count ($arrvalue)-1) {$sql = $sql. "" ".
      $arrvalue [$i]. "'"; }else{$sql = $sql. "'".
      $arrvalue [$i]. "', ';
    }} $sql. = ");
    $re = $this->query ($sql);
    if ($re) {return true;
    }else{return false;  The Public function Delete ($table, $Conditionsname, $Conditionsvalue =null) {if ($Conditionsvalue!=null) {$sql = "DELETE from". $table. " WHERE ". $Conditionsname."
    = ' ". $Conditionsvalue." '; "; }else{$sql = "DELETE from". $table. "
      WHERE ";
      $arrname = Array_keys ($Conditionsname);
      $arrvalue = Array_values ($Conditionsname); For ($i =0 $i <count ($arrname); $i + +) {if ($i ==count ($arrname)-1) {$sql. = $arrname [$i]. ='."'".
        $arrvalue [$i]. "'"; }else{$sql. = $arrname [$i]. ' ='."'".
        $arrvalue [$i]. "', ';
    }  $sql. = '; ';
    $re = $this->query ($sql);
    if ($re) {return true;
    }else{return false;
      The Public function Select ($table, $name, $Conditionsname, $Conditionsvalue =null) {if ($Conditionsvalue!=null) { $sql = "Select". $name. " From ". $table." WHERE ". $Conditionsname."
    = ' ". $Conditionsvalue." '; "; }else{$sql = "select". $name. " From ". $table."
      WHERE ";
      $arrname = Array_keys ($Conditionsname);
      $arrvalue = Array_values ($Conditionsname); For ($i =0 $i <count ($arrname); $i + +) {if ($i ==count ($arrname)-1) {$sql. = $arrname [$i]. ='."'".
        $arrvalue [$i]. "'"; }else{$sql. = $arrname [$i]. ' ='."'".
        $arrvalue [$i]. "' and ';
    }} $sql. = '; ';
    $re = $this->query ($sql);
    $row = $re->fetch ();
  return $row [$name];
      Public Function Update ($table, $name, $value, $Conditionsname, $Conditionsvalue =null) {if ($Conditionsvalue!=null) { $sql = "UPDATE". $table. " SET ".$name. " = ' ". $value." ' WHERE ". $Conditionsname."
    = ' ". $Conditionsvalue." '; "; }else{$sql = "UPDATE". $table. " SET ". $name." = ' ". $value." '
      WHERE ";
      $arrname = Array_keys ($Conditionsname);
      $arrvalue = Array_values ($Conditionsname); For ($i =0 $i <count ($arrname); $i + +) {if ($i ==count ($arrname)-1) {$sql. = $arrname [$i]. ='."'".
        $arrvalue [$i]. "'"; }else{$sql. = $arrname [$i]. ' ='."'".
        $arrvalue [$i]. "' and ';
    }} $sql. = '; ';
    $re = $this->query ($sql);
    if ($re) {return true;
    }else{return false; The Public function group ($table, $name) {$sql = "select". $name. "
    From ". $table."; ";
    $return = Array ();
    $re = $this->query ($sql);
    while ($row = $re->fetch (PDO::FETCH_ASSOC)) {Array_push ($return, $row [$name]);
  return $return;
    The Public Function Fetchall ($sql) {$return = array ();
    $re = $this->query ($sql); while ($row = $re->fetch (pdo::fetcH_ASSOC)) {Array_push ($return, $row);
  return $return;
 }
}