Questions tagged as 'mysqli'

2
answers

Query mysql is not giving return

I have a database Registration with two tables joao and maria and old columns and I'm trying to make a query in php just do not know if I'm doing it right because I've been using the database for some time I have the following code: &...
asked by 05.06.2016 / 02:57
0
answers

Commit and Mysqli Rolback

Well, I'm using PHP's Mysqli class and I came across the following situation ... I have two tables, table A is the main one and table B is the daughter until then it is ok, what I need to do is to treat the commit and rollback to avoid failur...
asked by 20.06.2016 / 06:08
1
answer

Question about "-"

Good morning, I have the following code snippet: $sql = "SELECT * FROM users WHERE user_name = '" . $user_name . "' OR user_email = '" . $user_email . "';"; $query_check_user_name = $this->db_connection->query($sql); db_co...
asked by 26.04.2016 / 15:01
1
answer

How to get LAST_INSERT_ID () from a mysqli_multi_query () function with SET and INSERT?

This is my 'method' of Placing Bets on my betting system. In this method, I register data in two tables, a BET call and another BET_MATCHES, the system is controlled by time, so in all the registers I need to set the TIME_ZONE = '-03: 00' to...
asked by 24.05.2016 / 21:06
0
answers

Problems with User Session in PHP

I have a system of bets, in this system I have dealers to sell the bets, and they earn commission for it. The problem is: When many resellers are online selling and posting bets on the system, at some point the dealer's betting line 1 is regi...
asked by 22.06.2016 / 16:23
0
answers

How to interact with msql table fields?

I am creating a book exchange page, I made two tables of wishes and mine. until the part of the user's desire logged in to find the other books I managed to do, but I would like the other users to have the desire of the user's books logged. type...
asked by 24.04.2016 / 01:12
3
answers

How to convert a MySQL connection to MySQL? [duplicate]

I decided to listen to some users to make the conversion but I need your help because I have done a lot of research and nothing works. The first file is: <?php include_once("/pasta/connectserver.php"); $table = "rjpsync_tag, rjpsync_i...
asked by 17.09.2014 / 13:47
1
answer

How do I sum id values from an array in total

I get 2 results of an array, for example: 1 and 9, these numbers are ID's that I will use for a query in the bank and print these results on the screen, until I can print, but for example if it is found in bd 20 results with these ID's it prints...
asked by 11.03.2016 / 16:12
1
answer

MVC connection, which one use MSQLi or PDO? [duplicate]

I'm starting to program a PHP MVC, what kind of connection is most recommended: MSQLi or PDO and why?     
asked by 14.03.2016 / 21:16
1
answer

Help with foreach error

I am developing a system that needs to raise 2 types of img a small and a large one for the database, but when I send up 3 img small and 3 img big test my foreach does not go up all I do not know what to do, but I do...
asked by 11.01.2016 / 22:22