snipplrCallback({"id":68116,"title":"php-simple-class-for-mysql","source":"
  1. <?php<\/span><\/div><\/li>
  2.      \/\/ Define for MySQL \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div><\/li>
  3.      define<\/span><\/a>(<\/span>'LOCALHOST'<\/span>,<\/span>'localhost'<\/span>)<\/span>;<\/span><\/div><\/li>
  4.      define<\/span><\/a>(<\/span>'DB_USER'<\/span>,<\/span>'****'<\/span>)<\/span>;<\/span><\/div><\/li>
  5.      define<\/span><\/a>(<\/span>'DB_PASS'<\/span>,<\/span>'****'<\/span>)<\/span>;<\/span><\/div><\/li>
  6.      define<\/span><\/a>(<\/span>'DB_NAME'<\/span>,<\/span>'****'<\/span>)<\/span>;<\/span><\/div><\/li>
  7.  <\/div><\/li>
  8.      \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div><\/li>
  9.      \/\/ Class<\/span><\/div><\/li>
  10.      \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div><\/li>
  11.      class<\/span> DB {<\/span><\/div><\/li>
  12.           var<\/span> $host<\/span>;<\/span>          \/\/ host<\/span><\/div><\/li>
  13.           var<\/span> $user<\/span>;<\/span>          \/\/ user<\/span><\/div><\/li>
  14.           var<\/span> $pass<\/span>;<\/span>          \/\/ pass<\/span><\/div><\/li>
  15.           var<\/span> $db<\/span>;<\/span>            \/\/ MySQL_LinkID<\/span><\/div><\/li>
  16.           var<\/span> $database<\/span>;<\/span>      \/\/ DB name<\/span><\/div><\/li>
  17.  <\/div><\/li>
  18.           \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div><\/li>
  19.           \/\/ construct<\/span><\/div><\/li>
  20.           \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div><\/li>
  21.           function<\/span> DB(<\/span>)<\/span> {<\/span><\/div><\/li>
  22.                $this<\/span>-><\/span>host<\/span>     =<\/span> LOCALHOST;<\/span><\/div><\/li>
  23.                $this<\/span>-><\/span>user<\/span>     =<\/span> DB_USER;<\/span><\/div><\/li>
  24.                $this<\/span>-><\/span>pass<\/span>     =<\/span> DB_PASS;<\/span><\/div><\/li>
  25.                $this<\/span>-><\/span>database<\/span> =<\/span> DB_NAME;<\/span><\/div><\/li>
  26.           }<\/span><\/div><\/li>
  27.  <\/div><\/li>
  28.           \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div><\/li>
  29.           \/\/ Connection<\/span><\/div><\/li>
  30.           \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div><\/li>
  31.           function<\/span> con(<\/span>)<\/span> {<\/span><\/div><\/li>
  32.                $this<\/span>-><\/span>db<\/span> =<\/span> mysql_connect<\/span><\/a>(<\/span>$this<\/span>-><\/span>host<\/span>,<\/span>$this<\/span>-><\/span>user<\/span>,<\/span>$this<\/span>-><\/span>pass<\/span>)<\/span>;<\/span><\/div><\/li>
  33.                if<\/span> (<\/span> !<\/span>$this<\/span>-><\/span>db<\/span> )<\/span> {<\/span><\/div><\/li>
  34.                    die<\/span><\/a> (<\/span>'mysql connect error : '<\/span> .<\/span> mysql_error<\/span><\/a>(<\/span>)<\/span>)<\/span>;<\/span><\/div><\/li>
  35.                }<\/span><\/div><\/li>
  36.  <\/div><\/li>
  37.                $db_selected<\/span> =<\/span> mysql_select_db<\/span><\/a>(<\/span>$this<\/span>-><\/span>database<\/span>,<\/span>$this<\/span>-><\/span>db<\/span>)<\/span>;<\/span><\/div><\/li>
  38.                if<\/span> (<\/span>!<\/span>$db_selected<\/span>)<\/span> {<\/span><\/div><\/li>
  39.                    die<\/span><\/a> (<\/span>'mysql select db error : '<\/span> .<\/span> mysql_error<\/span><\/a>(<\/span>)<\/span>)<\/span>;<\/span><\/div><\/li>
  40.                }<\/span><\/div><\/li>
  41.  <\/div><\/li>
  42.           }<\/span><\/div><\/li>
  43.  <\/div><\/li>
  44.           \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div><\/li>
  45.           \/\/ Close<\/span><\/div><\/li>
  46.           \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div><\/li>
  47.           function<\/span> close(<\/span>)<\/span> {<\/span><\/div><\/li>
  48.                mysql_close<\/span><\/a>(<\/span>$this<\/span>-><\/span>db<\/span>)<\/span>;<\/span><\/div><\/li>
  49.           }<\/span><\/div><\/li>
  50.  <\/div><\/li>
  51.           \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div><\/li>
  52.           \/\/ Query<\/span><\/div><\/li>
  53.           \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div><\/li>
  54.           function<\/span> query(<\/span>$query<\/span>)<\/span> {<\/span><\/div><\/li>
  55.                $res<\/span> =<\/span> mysql_query<\/span><\/a>(<\/span>$query<\/span>,<\/span>$this<\/span>-><\/span>db<\/span>)<\/span> or die<\/span><\/a>(<\/span>"error : "<\/span> .<\/span> mysql_error<\/span><\/a>(<\/span>$this<\/span>-><\/span>db<\/span>)<\/span>.<\/span>"<br \/>"<\/span>.<\/span>$query<\/span>)<\/span>;<\/span><\/div><\/li>
  56.                return<\/span> $res<\/span>;<\/span><\/div><\/li>
  57.           }<\/span><\/div><\/li>
  58.      }<\/span><\/div><\/li>
  59.  <\/div><\/li>
  60.       \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div><\/li>
  61.      \/\/ ShortCut Function<\/span><\/div><\/li>
  62.      \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div><\/li>
  63.  <\/div><\/li>
  64.      \/\/ mysql_num_rows<\/span><\/div><\/li>
  65.      function<\/span> mnr(<\/span>$res<\/span>)<\/span> {<\/span><\/div><\/li>
  66.           $num<\/span> =<\/span> mysql_num_rows<\/span><\/a>(<\/span>$res<\/span>)<\/span>;<\/span><\/div><\/li>
  67.           return<\/span> $num<\/span>;<\/span><\/div><\/li>
  68.      }<\/span><\/div><\/li>
  69.  <\/div><\/li>
  70.      \/\/ mysql_fetch_assoc<\/span><\/div><\/li>
  71.      function<\/span> mfa(<\/span>$res<\/span>)<\/span> {<\/span><\/div><\/li>
  72.           $rec<\/span> =<\/span> mysql_fetch_assoc<\/span><\/a>(<\/span>$res<\/span>)<\/span>;<\/span><\/div><\/li>
  73.           return<\/span> $rec<\/span>;<\/span><\/div><\/li>
  74.      }<\/span><\/div><\/li>
  75.  <\/div><\/li>
  76.      \/\/ mysql_fetch_array<\/span><\/div><\/li>
  77.      function<\/span> mfar(<\/span>$res<\/span>)<\/span> {<\/span><\/div><\/li>
  78.           $rec<\/span> =<\/span> mysql_fetch_array<\/span><\/a>(<\/span>$res<\/span>)<\/span>;<\/span><\/div><\/li>
  79.           return<\/span> $rec<\/span>;<\/span><\/div><\/li>
  80.      }<\/span><\/div><\/li>
  81.  <\/div><\/li>
  82. ?><\/span><\/div><\/li><\/ol><\/pre>","link":"https:\/\/snipplr.com\/view\/68116\/php-simple-class-for-mysql"});