Recently I made a change in the table and after that SELECT and INSERT INTO stopped working.
At first INSERT INTO could not include data in the last column that includes (centid), it returned column 'centid' cannot be...
When connecting to MYSQL database using the mysqli class I am getting the error:
Warning: mysqli :: mysqli (): Headers and client library minor version mismatch .
The error occurs when using version 5.4.16 of PHP, in version 5.6 the error no...
I found a project made in PHP OO to be used in PostgreSQL with this connection file.
<?php
class BD {
public function __construct() {
pg_connect("host=localhost port=5432 user=usuario password=senha dbname=nome_do_BD...
I have dynamic checkboxes, and wanted to fetch the values from those that were selected, like doing this with codigniter:
Model to go the fields and create the necessary checkboxes:
public function apoioPertendido(){
$query = $thi...
The old PHP function mysql_connect had the new_link parameter that allowed connection to several different banks in the same script :
Example:
$connect = mysql_connect($host,$user,$pass,$new_link);
How does this work...
Person, as I tidy this my code, it is giving error:
<?php
//IMPRIME TODOS OS VALORES DO BANCO CADASTRO
$servidor = "localhost";
$usuario = "root";
$senha = "admin";
$banco = "cadastro";
//conecta-se ao banco de dados Mysql
$con = n...
I am studying mysqli and PHP to migrate a personal blog, from PHP 5.6 to 7 (mysql to mysqli), the blog has a table with names and another with items related to names, dates and times, write a similar example.
Before, I made a query in table 1...
With mysql_* entering the deprecated state, the PHP documentation recommends using the PDO and MySQLi.
Which do you recommend for use? PDO seems to be more suitable for working with object-oriented only than at the same time I saw...
I have a database with about 500 records with system requests, but I need to display those records in the DataTable for better organization and search.
When loading the page it takes a long time to display the data in the DataTable.
PHP:...
I'm trying to repeat a region however, although mysqli_num_rows indicates that it has 9 records, in the while nothing is coming. My code looks like this:
$qry = "SELECT
pe_orclinhas.id_orclinha,
pe_orcgrupos.grupo_orc...