Questions tagged as 'mysql'

Tagged questions
0
answers

End date range Highcharts

Hello, I have a json that php creates for through a select in mysql. I'm putting the data on a chart with a start date until the end date. At the beginning everything is in order, but the final date does not match the final of the select....
asked by 07.01.2016 / 20:45
1
answer

Insert mysql with Ajax inside the While

I'm trying to make a dynamic insert using ajax. as shown in the image below. I want to be able to click on send from any line and make the post referring to it HowcanIdothis?<scripttype="text/javascript" src="js/jquery-1.10.2.min.js">&...
asked by 06.01.2016 / 18:42
2
answers

Why my query is not working with the php variable

I'm having problems with my mysql query . The value is passed from the php form correctly with $_POST , however when I add the variable to make the comparison the query does not send a response, but if I add the exact value that is in the...
asked by 10.12.2015 / 13:40
1
answer

Problems with Utf-8 on server with Mysql

Good afternoon, I'm having an accent problem with my application running the Ubuntu 14.04 VPS American server. All of the application running on my development machine is usually registering at the base along with the accent. I made a backup...
asked by 19.01.2016 / 22:14
0
answers

Table-wise query using PDO

My seemingly simple problem has given me headaches. I have a table that contains three columns: id , idpergunta , resposta . When a reply is sent to be inserted in this table I check if it already exists: $where = [...
asked by 25.01.2016 / 23:34
1
answer

how to prevent sql injection symfony 1.4 and doctrine 1.2?

Hi, I have a 3 inputs of searches that make queries to the database and I get the data obtained. So a malicious user can circumvent my system and get other information. By analyzing the behavior I use for the user to interact with my syste...
asked by 19.11.2015 / 18:14
0
answers

mysql error conect

I am trying to connect to mysql but it is giving error when connecting. Here is the error log: 22:40:11 [mysql] Error: MySQL shutdown unexpectedly. 22:40:11 [mysql] This may be due to a blocked port, missing dependencies, 22:40:11 [mys...
asked by 19.01.2016 / 01:42
1
answer

Crash when editing my.cnf - MySQL

Whenever I try to do the adjustment of the variables in Ubuntu by editing my.cnf located in etc / mysql / my.cnf and restart the system, crashes related to connection failure Can not connect to local MySQL server through socket '/v...
asked by 18.01.2016 / 19:31
0
answers

How to create a column in a table from a Select

I have the users table and the posts table, I need to copy the same information from a users table column to a posts table column. For example, I have this code: SELECT posts.*, users.username FROM posts inner join users on (posts.user_i...
asked by 25.11.2015 / 19:48
0
answers

How to loop within a JavaScript variable?

I have a page index.php . It has a loop that collects line by line from a table of the mySQL database and inserts in the variables that are sent to the file dashboard.js where it has the code below. var visitorsData = { [CO...
asked by 21.11.2015 / 21:52