should use PDO and speed to display data

We're shifting our Forum based support to a more dedicated support system!

We'll be closing our Forum support from 10th June, 2020 and move to Email Support assistance.

  • If you are a WCFM premium add-ons user, contact us- here
  • Want to know more before buying our add-ons? Send Pre sale queries- here
  • If you are a WCFM free user, please open a support ticket at WordPress.org
  • For WCFM App related queries, reach us- here
From now the forum will be read-only!

Multi Vendor Marketplace Plugin | WCFM Marketplace Forums WCFM – Feature Request should use PDO and speed to display data

Viewing 3 reply threads
  • Author
    Posts
    • #42469
      cesar
      Guest

      Hi there, why you don´t use PDO for access to database? i have searching about this, and wordpress was insterested to implement on 2013, but i’ve serching in the core of 5.0.2 and doesn´t use PDO, so you can implement to access data to your plugin use, meanwhile wordpress catch up.

      Other thing, is the lag to display data on any crud. it’s o lazy.

      my best
      Thanks

    • #42498
      WCFM Forum
      Keymaster

      Hi,

      Do you want to access WP database from site ?

      Try this plugin – https://wordpress.org/plugins/ari-adminer/

      Thank You

    • #42566
      cesar
      Guest

      Not, i mean, every data of vendor/customers site data, are saved in SQLi database, and the connections that you use its just query, one of the most insecure, for other hand, PHP allow use PDO (http://php.net/manual/en/book.pdo.php) that it’s so much more secure, this allow use prepare statement and bindParam to put in the query to database values that you want to ask to DB.
      eg.

      <?php
      $sentencia = $mbd->prepare(“INSERT INTO REGISTRY (name, value) VALUES (:name, :value)”);
      $sentencia->bindParam(‘:name’, $nombre);
      $sentencia->bindParam(‘:value’, $valor);

      // insertar una fila
      $nombre = ‘uno’;
      $valor = 1;
      $sentencia->execute();

    • #42610
      WCFM Forum
      Keymaster

      Hi,

      Frankly I am not very comfortable with this.

      We use WP standard for this.

      WP DB object “$wpdb” and it supports all this prepare statement, param etc …

      Thank You

Viewing 3 reply threads
  • The topic ‘should use PDO and speed to display data’ is closed to new replies.