Questions tagged as 'mysql'

Tagged questions
1
answer

Problem with MySQL and PHP query

I have the following problem, when I use the WHERE clause I am not able to use the values being passed by parameter. As a return I get the following message: PDOStatement :: execute (): SQLSTATE [HY093]: Invalid parameter number: number...
asked by 13.06.2016 / 18:58
2
answers

SQL query returning null value

SQL Fiddle DB Simulation: link JavaScript: // Auto-salvar $(function () { $.post("actions/autosalvar.php", function (data) { console.log(data); $("#cliente").val(data.cliente); }, "json");...
asked by 24.01.2017 / 19:11
1
answer

Codeigniter - Dynamic form

Alright? Well .. I'm a beginner in the world of Web Programming and I'm trying to develop a codeigniter system. could you help me? I'm trying to make a dynamic form in which I have a select that has the months of the year .. and I would like it...
asked by 22.05.2016 / 04:17
2
answers

MySQL query and case sensitive

I want my login.php to check if the password is uppercase, because when it exists, it recognizes it, since I have my database with the collation utf8_general_ci . I have already tried collation in utf8_bin and latin1_gener...
asked by 20.05.2016 / 17:39
1
answer

HEROKU connect to mysql database

I'm doing reverse engineering on a system, and I want to use the same database as the old system. But I am not able to connect the system bank in production with this database. And for being in MYSQL I'm using the mysql2 gem, as follows: herok...
asked by 03.10.2016 / 19:03
1
answer

Error creating MySql foreign key in phpMyAdmin?

I'm having trouble creating foreign keys in mysql through phpmyadmin . I have these tables CREATE TABLE 'cidade' ( 'idCidade' int PRIMARY KEY AUTO_INCREMENT, 'nome' varchar(25), 'Uf' CHAR(2) ); CREATE TABLE 'aeroporto' ( 'idAe...
asked by 22.05.2016 / 19:27
2
answers

form read database

Hello everyone, I'm trying to make a form read MySql database options, but the line of code below shows me only the word "Array". What is my error on this line? Can someone help me. <form id="cadastro" action= "cadastroprodutos.php" meth...
asked by 07.05.2016 / 17:58
1
answer

How to run the same php script via cron without overloading?

What is the best way to run a same php script multiple times by doing random queries for a given column with a limit of 1000 per query of the same mysql table via cron (cpanel) without generating so much overhead? [cron 1] * * * * *...
asked by 17.07.2016 / 03:59
1
answer

web site with items bank image and page

How do I create items for a virtual store type site.  Pull DB items and put paging with 15 items limit.     
asked by 05.05.2016 / 17:13
1
answer

How to save data from multiple MySQL queries?

I have a table with data of several metals and I need to get this data to use on my page, but I can not get all of it, only the first one works. Code: $link = mysqli_connect("localhost", "root", "", "metais"); $result = mysqli_query($link...
asked by 29.03.2016 / 16:19