Questions tagged as 'mysql'

Tagged questions
1
answer

Save Json to a mysql database

I'm not sure how to process a JSON within the database. The whole process looks like this: I am sending from another server through the script below: $sql = "SELECT * from mgs_castloang"; $Ds_Retorno = ibase_query($sql); $count = 0; w...
asked by 12.05.2018 / 22:38
1
answer

Query that changes the amount of items in MySql [closed]

I have a query that changes the amount in MySQL (below). Initially this query works perfectly, but when I register new items in the table, some of them do not change the quantity correctly, but some remain normal. For example, in this qu...
asked by 26.06.2018 / 20:55
1
answer

Why can not I fetch any data from a mysql table [closed]

What error is there in Foreach? <?php $banco = "mysql:dbnmae=banco;host=localhost"; $user = "root"; $senha = ""; try{ $conn= new PDO($banco,$user,$senha); echo "<h1>conectado com sucesso</h1>";...
asked by 01.07.2018 / 16:35
2
answers

What is the fastest way? [closed]

I made a game in Java and the data of the players are in the database, when a player enters, it is placed in a ArrayList<PlayerData> where it contains the getters and setters
asked by 25.08.2018 / 23:19
1
answer

Print table data

I have this code: $sql = mysqli_query($strcon, "SELECT * FROM cadastro"); $exibe = mysqli_fetch_row($sql); echo "<table>"; echo "<tr><td>Nome:</td>"; echo "<td>".$exibe[1]."</td></tr>"; echo "<tr...
asked by 24.08.2018 / 18:50
1
answer

Check if date and hour / minute have already expired

I am having a problem, when uploading my website to PHP 5.6 the code I use to check if such date and such time / minute has expired is simply not respecting the time, if it is the date already speaks that expired without checking the hour / minu...
asked by 11.04.2018 / 22:25
1
answer

Search the database

I am in doubt as to how to do a search in DB. He's going to catch. Does anyone know why? And how to solve it? This is the function public void consultar(){ String sql ="select * from tbaluno where idaluno=?"; try { Prepared...
asked by 18.04.2018 / 04:42
1
answer

Change URL of all MySQL DBMS tables with PHP

I have a MySQL DBMS with multiple tables, I tried unsuccessfully doing a routine, I need to change all the URLs of all the tables to another URL. Ex: link for link     
asked by 12.04.2018 / 22:01
1
answer

How to access a database using C [closed]

I would like to know if you have any way to access a database in C?     
asked by 27.04.2018 / 03:56
3
answers

Can not catch error in sql [closed]

try DModuleGrid.ZQuery1.Close; DModuleGrid.ZQuery1.SQL.Clear; DModuleGrid.ZQuery1.SQL.Add('SELECT * FROM tdcupant'); DModuleGrid.ZQuery1.SQL.Add('WHERE numcupom = :co2 AND ccf = :cc3 AND dtcompra = :dtc4 AND impcaixa =...
asked by 16.05.2014 / 15:30