Questions tagged as 'mysql'

Tagged questions
1
answer

PHP accent problem, MySQL

I have a very strange problem with my PHP code. All my charset are correct <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <meta charset="utf-8"> I already use the code below to correct accent problems h...
asked by 20.04.2015 / 23:08
1
answer

Sort by lowest price in a Mysql table

How to list products that have the lowest price for the largest! From lowest to highest! Using PHP and Mysql.     
asked by 17.04.2015 / 22:36
1
answer

PDO Selection in the database mysql parameter BLOB

I'm having trouble trying to retrieve one or a list of images that I've already inserted into mysql 5 with PDO. I have a class of what has the architecture of my querys to work with the database. class ImagemDao { public function inserirImage...
asked by 21.04.2015 / 23:18
1
answer

C # Threads How to optimize a SELECT with BLOB

I have a C # application (.Net 4.5) that when loading a screen among other operations it searches the database for a background image and sounds. It turns out that for some loaded screens this operation (search for images + sounds) takes 29 seco...
asked by 16.04.2015 / 17:09
1
answer

Error: "Lock wait timeout exceeded; try restarting transaction "

I'm developing a java application that uses Hibernate to do the mapping. I created the DAO's of classes, but when doing insert, update and delete operations it returns me this MySQL error. Here are my classes (I'll only post the insertion met...
asked by 26.11.2014 / 19:13
1
answer

UPDATE, field with placeholder query failed to execute

Follow the code: $campo = $_POST['campo']; $valor = $_POST['valor']; $id = $_POST['id']; $mysqli = new mysqli("localhost","root","","tabela"); mysqli_set_charset($mysqli,"utf8"); $consulta = $mysqli -&g...
asked by 20.01.2015 / 01:38
1
answer

Is it possible to work with attribute tables of spatial objects in Delphi and dbExpress?

I have a spatial database in MySQL where the geometry and attributes of spatial objects are stored. I tried to create a basic form, as basic as possible using SQLConnection , Provider , Dataset , ClientDataset and dbware , to edit the obj...
asked by 25.01.2015 / 17:21
2
answers

Search for MySQL data list

Currently on my system, I'm calling each column at once: $sql2 = mysqli_query($db, "SELECT group_id FROM login WHERE userid = '$userid'"); $exibe2 = mysqli_fetch_assoc($sql2); $_SESSION['group_id']=$exibe2['group_id']; And in the file I'm c...
asked by 21.03.2015 / 18:07
1
answer

Get data according to date in MySQL

I need to provide the option to view the data according to a time X determined by the user, for example I want the data from 03/01/2011 to 12/25/2014 How can I do this with MySQL? How do I set the table so everything can work out?     
asked by 26.12.2014 / 03:33
1
answer

Change MySQL column information with UPDATE

In summary through PHP below I can send the specific information already registered in the column in the BD, but in addition to just "emitting" the data there, I would like a function that would change such information without changing the page...
asked by 26.12.2014 / 18:36