Questions tagged as 'mysql'

Tagged questions
2
answers

Warning: PDO :: __ construct () expects parameter 4 to be array, string given in

I'm starting to program in PHP and MySql and trying to connect the database with the PDO method marks me the error, This is my code: else { try { $conexion = new PDO('mysql:host=localhost;dbname=registro_prueba1', 'r...
asked by 17.05.2017 / 15:52
2
answers

where is the error in my query

in my general database I have 5 database information schema mysql performance schema phpadmin test wordpress the base I use is test, inside I have my table commenti that contains 3 fields which are nome varchar (15) va...
asked by 08.05.2017 / 23:56
1
answer

Doubt of connection string between azure and php

Greetings, I have a question: I have a mysql database in azure and I want to connect it with php but I do not know how. I have this command but I do not know why to replace where it says "localhost" and $ db. Thanks in advance. <?php...
asked by 06.05.2017 / 22:50
3
answers

Stored procedure insert in MySQL

Create a stored procedure that id auto incremente , I did it in SQLSERVER but I do not know how to do it in MySQL CREATE PROCEDURE insersertar (@nombemple varchar(30)) AS BEGIN DECLARE @num int; DECLARE @id char(5)...
asked by 05.05.2017 / 23:39
0
answers

How to capture the data of a select to update it?

The drawback I have is when I want to update a select of a specific id but when I give it to edit it always shows me the data of the select of the first id inserted but the other fields if the samples correctly minus the one of the select. Th...
asked by 05.05.2017 / 21:08
1
answer

Problem Delete MySQL data from a list in Servlet

I have a problem deleting a record. This is my class Queries where I delete a user. public static int Borrar(int id){ int estado=0; try { Connection con = Consultas.getConnection(); String sql = "call eliminar(?)";...
asked by 05.05.2017 / 23:35
1
answer

I can not access phpmyadmin and the container gives me an error

This is the image of my current container link As you can see, below gives me a strange error that I do not know if it is normal to leave ... in any case, I can not access phpmyadmin (problem of which, I created a post previously, but they gav...
asked by 07.05.2017 / 21:27
1
answer

sum php mysql $ SESSION_START

Good morning, I'm new to the topic of sessions in PHP , and the inconvenience is that I do not know how to add data that is in the session and not inside the DB. I already tried several combinations to make the array run and add the tot...
asked by 02.05.2017 / 00:38
0
answers

How can I use the $ _SESSION, to send data to my corresponding account

Fatal error: No se puede volver a asignar la variable auto-global. Hello, well the problem comes to me when sending data to a database to the field that belongs to the user. This way I put this in my files to not lose the variable. Exampl...
asked by 29.05.2017 / 00:33
0
answers

Query to filter duplicates does not work

Well, I am trying to filter the duplicates of a table with grocery and it seems that it completely ignores my query, I have tried with distinct() , group by() and even both at the same time. What I want is to show the table witho...
asked by 29.05.2017 / 12:51