Questions tagged as 'mysql'

Tagged questions
0
answers

Creating table schema with pre-defined keywords

Hello, I am creating a table schema that needs to be optimized, the reason for this being tables that will have 3 to 5 million records. The big concern here is with regard to search, in this case the famous LIKE %% ... can not even pass close, be...
asked by 23.10.2017 / 05:46
0
answers

MySQL PHP XAMPP - Connect to the database

Hello, I need to create a webservice, but I have little experience with php and mysql, so I have some questions, I'm using XAMPP and MySQL Workbench, I made the connection test in the workbench and said that it worked, so maybe not is the problem...
asked by 07.09.2017 / 07:03
0
answers

PDO returning error when there is no error

Randomly, I get the following error while updating my system: Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] Cannot assign requested address By mistake, it can not connect to the server, but the server is there, and it's on, of...
asked by 21.09.2017 / 14:39
0
answers

Postback getting base data with PHP

I have a database in MYSQL where one of the fields tells the status of a particular transaction. For example: status = waiting or status = full. I want to do a cron that every 10 minutes takes all the clients that have the status = complete a...
asked by 18.09.2017 / 19:41
0
answers

List in PHP using Next and Previous

I have a system of next and previous with zoom What I want is that when I click on next or previous product change by ID from the Bank. and zoom in on the image on the page. because I am facing problems....
asked by 02.09.2017 / 17:12
1
answer

Return all data in a mysql_fetch_assoc

I have a query that returns the data below: nome -------- vencimento Joao -------- 09/08/2012 Maria ------- 04/12/2015 That is, two records . However, by putting it in PHP code only the top record is returned, even using +=...
asked by 31.08.2017 / 15:36
1
answer

Comparison and calculation of time and date [duplicate]

Well I retrieve the date and time of a record like this: $sql = $conexao->query(select data, hora from pedido); $resultado = mysqli_fetch_object($sql); $resultado->data; $resultado->hora; I need to add 5 hours and check if the d...
asked by 31.08.2017 / 13:31
0
answers

Performance in somatic database

I have a system in development but are already using in beta, this system has a specific focus:    'control 100% of shares, share per share, without losing any history   how it was and how it is now ' With this I ended up falling into a pr...
asked by 02.10.2017 / 21:18
0
answers

update table with foreign key [closed]

I'm trying to update a table with foreign keys, just in foreign keys I want to leave them with value NULL when doing update but I'm not getting this is my query: $sql = 'UPDATE agenda SET id_pessoa=:id_pessoa ,id_tp_pessoa=:id_tp_pessoa...
asked by 06.09.2017 / 05:12
1
answer

Searching for user data from a session [closed]

I'm making a website where multiple users can log in. I logged in but I can not get the other user data that is in the database. How can I do this? I have the function $usuario = buscaUsuario($conexao, $_POST['email'], $_POST['senha']);...
asked by 17.08.2017 / 22:35