Questions tagged as 'mysql'

Tagged questions
1
answer

Popular form already created with PHP (Mysql)

I need to populate a form with Mysql database information in the onChange event of an input Select. I know how to create a form of 0 by filling in the values property, but filling a form already created I'm not getting. input type="button"...
asked by 01.03.2017 / 16:51
1
answer

How to convert string time to Ionic time for PHP with MySQL?

Good morning, I'm passing the server a string that would be for time: 23:45 is an example. In my $ _GET I'm trying to convert this way: $prazo_entrega_min = time("hh:mm", strtotime($_GET['prazo_entrega_min'])); But to no avail. What can...
asked by 01.03.2017 / 15:26
1
answer

Rename values in mysql

I have the following sql query: select nf,status from notas where status = 3 Instead of bringing the number 3 in the sql query result, I wanted to show another message: "complete." How do I rename?     
asked by 29.08.2017 / 15:46
2
answers

Update Inner Join (update in two tables) - Php; Mysql

I have two tables and I want to make a join to do an update on both at the same time. Table1: Clipping (id, dia_semana, data) Table2: imagemClipping( id, id_clipping, titulo, dia_semana, data, imagem) The id_clipping is th...
asked by 29.08.2017 / 22:52
1
answer

Database with many changes

Situation I'm making a system for a drugstore. The Client can enter the pharmacy and take products only from the gland and pass directly in the box, or you can pass the counter and just take the antibiotic at the counter with a pharmacist, or...
asked by 30.08.2017 / 00:02
1
answer

Can not find the php controller with laravel [closed]

Hello everyone, I'm starting with laravel, I've come across a problem. I created the controller, the routes, but still, it is giving me the following error: Class App \ Http \ Controllers \ Contact 2Controller does not exist. What should I...
asked by 15.04.2017 / 22:01
2
answers

Problem when mounting JSON with database return

It all comes down to this image:
asked by 15.04.2017 / 18:11
1
answer

Query with array returning only first record

I have the following querys: <?php $VarMensagem = 1; $pdo = new PDO($dsn, $un, $pwd, $opt); $data = array(); $dataGeral = array(); try { $stmt = $pdo->query("SELECT * FROM mensagem WHERE me...
asked by 14.03.2017 / 04:23
1
answer

Dynamic Select with query

I want to make a dynamic form like this: link I'm having difficulty linking mysql, php, and javascript to the following extent: -The first select the options values are generated by a query (Select * from Continent) - As selected Contine...
asked by 23.02.2017 / 18:23
1
answer

Expiring user usage time Mysql

I'm doing a C # sign-in system where the user is logged in to verify their login, password and how much time they have left to use the system. Even the part of checking login and password I managed to do, but I'm having trouble checking the usag...
asked by 24.02.2017 / 13:25