Questions tagged as 'mysql'

1
answer

Error returning bank statement in MySQLi

Well, I'm doing a login system in PDO I do not understand much, but I'm going through this problem, I developed the following code below: $select = $con -> prepare("SELECT * FROM conta WHERE conta = ? AND senha = ?"); $select ->...
asked by 23.02.2017 / 03:15
1
answer

Problem with php code to send simultaneous messages to the database!

I am trying to create a code to send messages between the users of a system in php, the problem and that I can send the message from one user to another but I would like it to be possible to send to all users, one, the same message without havin...
asked by 22.02.2017 / 15:35
1
answer

PHP - SQL query

I am trying to implement a code to list information from 3 tables. I want to display only the data that has been registered by the user id = '20' . This value '20' I'm getting a session variable and I want to put it in my list function but...
asked by 03.02.2017 / 03:47
3
answers

Update in a field that can not be negative

I need to do a update in a certain field, where it should arrive at least until "zero" can not be negative. And when I get to zero I need it from the update of the remaining amount in the next field. "The setting is for it to drop the first...
asked by 05.01.2017 / 19:29
2
answers

Recording data from a SESSION in BD [closed]

Hello, I would like to add the registered_name to the database. <?php require_once("../../../session.php"); require_once("../../../class.user.php"); $auth_user = new USER(); $user_id = $_SESSION['user_session']; $stmt...
asked by 09.01.2017 / 15:45
1
answer

Search field / data filter

Hello, I'm developing a data search field. And this one, is working very well until then; but I would like to add some query parameters to this field. How are you today (search possibilities): Data inicial Data final Nome. How do...
asked by 05.01.2017 / 20:39
1
answer

Save data from a query to an array and display it via JQuery

I'm doing a question and answer game, I need to make an appointment in the bank and I'll get 4 columns (id, question, answer and challenge) and it will return me 10, 15 or 20 lines depending on what is chosen by the user. After that, these colum...
asked by 09.01.2017 / 20:20
1
answer

Error installing Mariadb

I'm trying to install mariadb and the system returns the following error My question is as follows, how to install into a directory other than the / var / cache ...     
asked by 21.03.2017 / 03:14
1
answer

CodeIgniter update works but wrong list

I'm having a problem updating a bank record by codeigniter, I have two tables, one call: Employee (where employees are stored in the company and in which sector that employee works, this table has the foreign key of the sector table (sector_...
asked by 20.03.2017 / 03:38
1
answer

Total registered in Database with Script

My php page uses the following files "1-config.php = connects to the database" "2-total.php = connects to the Form and shows the total of the record on the page" In the Html of my main page I use <?php require_once("total.php"); ?>...
asked by 27.12.2016 / 18:59