Questions tagged as 'mysql'

Tagged questions
1
answer

Unwanted characters using jquery + php

I'm having a little problem, when I use the jquery append to display elements returned from a php query. Note: this is not the full append, it's a bit long and I've just put the part I need you to see. $("#topics").append('<div class="to...
asked by 05.12.2017 / 23:50
1
answer

Define variable as null in a Query in php

I have the following QUERY on my system: $Query = "SELECT * FROM Monit WHERE ($Modulo IS NULL OR Modulo = '$Modulo') AND ($Usuario IS NULL OR Usuario = '$Usuario') AND ($Data IS NULL OR Data_reg = '$Data') ORDER BY Data_monit...
asked by 20.02.2018 / 15:34
1
answer

Picking category from a table in Mysql

Personal I have a product registration table and in it I have categories: $consulta = mysql_query('select categoria from produtos order by categoria'); while ($var=mysql_fetch_array($consulta)) { echo "<a href='editar.php?categ...
asked by 28.02.2018 / 13:57
1
answer

Select products by category PAI, with products registered in the child category

Next, I made the following tables: CREATE TABLE produto ( codigo INT UNSIGNED NOT NULL AUTO_INCREMENT, nome VARCHAR(128) NOT NULL, url VARCHAR(255) NOT NULL, PRIMARY KEY (codigo) ); CREATE TABL...
asked by 28.02.2018 / 01:13
1
answer

JOIN with two queries in the same table

I need two different results coming in the same table with JOIS It works like this I have the PRODUCAO table and the BANK table In the production table, I get the bank ID in the bank bank and it returns the bank name, but I have a secon...
asked by 18.12.2017 / 22:11
1
answer

Catch all values from the database [closed]

Could someone help me figure out the error: <?php $mysqli = new mysqli("localhost", "user", "senha", "dbname"); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } $sth = $mysqli->prepare("S...
asked by 13.01.2018 / 15:46
1
answer

Problem inserting data into the database

A Notice appeared stating that the variable was not defined, but everything is fine in my view. add_category.php page <!DOCTYPE html> <?php session_start(); ?> <html> <head> <meta charset="utf-8"> <met...
asked by 24.11.2017 / 00:12
1
answer

Search by number in MySQL table with PHP [closed]

I have a search form where the user types a number and if it is equal to the number that is in the database it returns the data of that number. But when I click on button enviar it shows me the page teste.php with the following err...
asked by 23.11.2017 / 13:45
1
answer

Is there a way to connect a cordova app directly to Mysql?

I want to make a system with local mysql server on a desktop, however without using PHP or ASP . Then the android would make the direct connection. It's possible? Thank you.     
asked by 26.11.2017 / 18:11
1
answer

Adding values from a table

I have the following query: $qrysel = "select * from won_auctions w left join registration r on w.userid=r.id where payment_date!='0000-00-00 00:00:00'"; This query will show a list of users of the won_auctions table and get the user name...
asked by 27.11.2017 / 12:22