Questions tagged as 'mysql'

Tagged questions
0
answers

Fields in the order by clause should be indexed?

I'm reading a lot about using indexes in Mysql. I noticed that it really is necessary to know how to use it at the right time and in the appropriate columns, in order to make queries faster and not the other way around. Now, imagine the follo...
asked by 14.08.2016 / 19:26
1
answer

Records Query on DATE Fields per Month

Hello! I would like an aid I am performing queries on a VIAJEM table where I have 2 fields IDA E CHEGADA . Both of type DATE . I need to query all records for a given MES . Ex. ida = '2016-08-15' chegada= '...
asked by 17.08.2016 / 20:59
0
answers

Select MYSQL, list row not present in table NULL

I'm doing a hotsite with a quiz (questions and answers), with more than 3000 users. The question is in the list of quizes for each user, I have two tables (I simplified to focus on my doubt): QUIZ: (which stores all the quizes created by ad...
asked by 16.08.2016 / 15:20
0
answers

'' could not find '' - xamp - can not connect database

I have to maintain a zend application, but I can not run it at all, it seems the bank is not connecting, it generates this warning.    "could not find"; Countless times. the problem is that I have already removed the lines in php.ini ex...
asked by 30.10.2016 / 08:11
0
answers

Improving my input and output validation

I have the function inserir , and it has input and output validation, it first makes a select with the function count with a where referencing the product code, then it drops in the if($quantidade_db >= $quantida...
asked by 31.10.2016 / 16:47
1
answer

MySQL database structure

Hello I'm having a hard time structuring my data in a database. I have a table for exam procedures with id, exam name and value. But the problem is that a "procedure" can contain other procedures, and in that case the unit value of each proce...
asked by 08.08.2016 / 16:12
0
answers

Querying the same data on different dates

I'd like to know how I can bring some DB data. Such as customer name, ID and date. In the company I work with, there are some Service Orders, but some of these OSs are of the same customer (same client but different OS). The company wants to kno...
asked by 08.08.2016 / 15:23
1
answer

PDO PHP: How to make a logged in user delete your account?

User accesses the logged in page: <?php session_start(); echo 'Bem vindo, '.$_SESSION['username']; ?> <br /><a href='logout.php'>Logout</a> I want him to push a button or link and delete his own account (without typi...
asked by 21.08.2016 / 22:05
0
answers

Auto increment ID relative to another field

Some time ago I was looking for something to solve this problem that I have encountered in other systems that I have developed, I would like to know a solution for how to do an auto increment id, but an auto increment related to another field, f...
asked by 23.08.2016 / 13:30
1
answer

Error in php connection file for database mysql

Errors:    Warning: mysqli_stmt_bind_param () expects parameter 1 to be   mysqli_stmt, boolean given in /home/a9630388/public_html/register.php    on line 7       Free Web Hosting       PHP Error Message       Warning: mysqli_stmt_execu...
asked by 22.08.2016 / 16:41