Questions tagged as 'mysql'

Tagged questions
1
answer

Pull results from two MySQL tables with PHP class

I created a class for dynamic generation of tables with results coming from MySQL. The syntax I use after instantiating the class is as follows: $table->topo('Menu:','menu','menu'); $table->Corpo('menu_sub','ID,Nome,Menu,Icones','id,nome...
asked by 22.10.2014 / 20:49
2
answers

PDO and mysqli are the only options for working with database in PHP? [duplicate]

And if I needed to use a database that was not supported by the PDO, what could I do? After all, what does the PDO do underneath the cloths? Does it use mysqli?     
asked by 11.07.2017 / 00:34
1
answer

WHERE clause with PHP coming from JavaScript [closed]

I need to pass a PHP variable into a WHERE clause of a SELECT , but this PHP variable receives a value from JAVASCRIPT . I ran a test passing just a native PHP value and it worked: <?php $phpNum = 1; /* Testando com numéric...
asked by 29.08.2016 / 02:13
1
answer

Edit a news page

In the code below, I have the news editor. <?php /* * faz a conexao ao banco * e seleciona a base de dados */ include ('../conn/conn.php'); /* * monta e executa consulta em SQL */ $sql = "SELECT * FROM noticias WHERE n_id = ".(i...
asked by 23.04.2014 / 13:31
1
answer

SQL query for return of date

I can not solve this DB exercise. Ask to use the sql date function. We have the date in day / month / year format, we have to extract the month. We have the seller table containing codvend, namevend and dt_nasc. Question: List all sellers...
asked by 13.11.2014 / 14:32
1
answer

How to do insertion at the same time without giving duplicate key error?

<section class="content"> <div class="row"> <div class="col-md-12"> <div class="box box-primary"> <!-- form start --> <form role="form" class="form-horizontal" action="modules...
asked by 28.12.2018 / 22:10
1
answer

Error "Warning: mysqli_query () expects parameter 1 to be mysqli, null given" [closed]

I'm developing an API in PHP, which is hosted by Hostinger. However, when I do the SQL query in MySQLi, I get the same error, no matter what changes I make in the code: Warning: mysqli_query () expects parameter 1 to be mysqli, null given and...
asked by 30.11.2015 / 20:23
1
answer

Help with installing php 7.0 on ubuntu as video tutorial [closed]

Following this video tutorial link . Already at the beginning of the change of default, the changes made to the default, the nginx default index should be "subscribed" by the index.php configured more for some reason nothing changes even after...
asked by 09.04.2018 / 15:08
1
answer

How to create a code in python and connect it to Mysql [closed]

Ee Galera, I'm learning the database language, but I still do not know everything so I came here to ask for help for you to know how I can do this. I know there is sqlite3 in python but I want to use mysql, which in the case I'm working with in...
asked by 21.05.2017 / 23:46
1
answer

Select multiple movie categories

Well, I come across the following puzzles (for me) which is as follows, I honestly know how to start doing what I want to be several checkbox's each with its value . After that I do not really know how to do it.    WARNING, I'm n...
asked by 07.02.2015 / 04:18