d-marc1 / simple-mysqli Goto Github PK

I do not see a way to open a connection using a socket (unix).
It seems the constructor is closed to using hostname and port.
It is interesting to respect the use of a socket (allowed in mysqli).

You can also think changing the design to allow use of an externally created connection.
The component can delegate unto others, like an external framework, to host the top level configuration, handling of a connection-pool, redundancy or whatever new features appear.

So it is better suited for integration with others projects. To use this component as a thin abstraction layer on top of mysqli (connection).

  $path = $obj->pathstr;
  $survey = $obj->surveyno;
  $ret = $db->select('SELECT * FROM land where polyPath = ? and surveyNo =?', [$path,$survey], ['%s']);

This gives me internal server error. Could someone help me?

Without using AND clause, the query works.
$db->select('SELECT * FROM land where polyPath = ?', [$path], ['%s']);

If you made this object singleton, you could just do: SimpleMySQLi::query();

P.S. Thy not PDO?