Questions tagged as 'mysqli'

Tagged questions
1
answer

Warning: mysqli_stmt :: bind_param (): Number of variables does not match number of parameters

Hello everyone I am using mysqli and I have the following error:    Warning: mysqli_stmt :: bind_param (): Number of variables does not match   number of parameters in prepared statement on line 8 Please, if you can help me solve it, than...
asked by 21.04.2016 / 19:41
1
answer

Error Message, handling functions with POO and PHP .. Fatal error: Call to a member function fetch_all () on a non-object in

class OperacionesAlumno{ private $server = 'localhost'; private $usuario = 'root'; private $pass = ''; private $bd = 'dbvasco'; public function Conectar(){ $conexion = mysqli_connect('localhost','root','','intranet'); mysqli_set_charse...
asked by 29.09.2016 / 21:42
1
answer

Notice Array to string in line 72

I have the problem with an insert in php the rest of the models make it perfect except this one, I leave the insert code pointing to the line 72 public function Insertar($r){ try { $sql="INSERT INTO reporte(reporte_id,repor...
asked by 09.11.2018 / 15:17
1
answer

Notice: Undefined index: Sending variable by post

I'm doing a nested select with connection to mysql and sending a data with the post method throws me the error of undefined variable, perform the tests and in fact nothing is being sent. I use Jquery to send this data in my case is the region id...
asked by 27.08.2018 / 17:18
3
answers

How to use an Array array and declare variables

Hello I'm just new to PHP I want to declare variables with the result of a while of an Array <?php include("conexion.php"); $query4= mysqli_query($conexion,"SELECT refprofesor FROM asigna_materia WHERE refgrupo='3-A' AND refcarrera='09TIC...
asked by 18.08.2018 / 05:52
3
answers

Query ready MySQLi

Good people I want to ask a question about How to translate this code in PDO to MySQLi ? I'm having problems how to take it to MySQLi any ideas. Greetings. $stmt = $conn->prepare("SELECT * FROM usuario WHERE rut = :codigo"); $s...
asked by 30.10.2018 / 15:18
1
answer

Multi-table mysql query and repeated data

first of all thank you very much in advance for your help, I am learning php and queries based on data and I have some doubts, I am doing a multitasking query that is something like the following: SELECT t.Tourname, c.FechaConcierto, can.nombr...
asked by 31.01.2018 / 06:51
0
answers

enable PDO module mysql and php in godaddy

I have a windows classic hosting with iis and php 5.3 in godaddy there my website connects to a mysql database this is my connection <?php $dsn = 'mysql:host=dbgts.db.2365702.3ed.hostedresource.net;dbname=dbase'; $username = 'user'; $pa...
asked by 14.09.2017 / 17:55
2
answers

How to run a PHP with Ionic 2

By making the request of my-php.php by GET of Http I literally retorted the code of the php file in a text string , what I need is that the file php be executed and I return the result of the query to the database in Json f...
asked by 25.05.2017 / 01:21
2
answers

MySQL: Get complete orders with a subset of products

The problem we have is the following. We have a shop_orders database with orders placed by customers: id | user_id 1 | 1 On the other hand we have the shop_order_products table, which contains the products that each order contains, where t...
asked by 11.04.2017 / 08:56