Questions tagged as 'mysqli'

Tagged questions
0
answers

Query to return followers of friends

I'm starting in SQL and I'm having trouble making a query with multiple rows returned. I'm creating a generic twitter clone.    Goal: Return users who are followed by people who   logged in user follows and displays as people he or s...
asked by 29.05.2018 / 18:28
1
answer

Doubt about highcharts and php

For styling a web page, I often use the highcharts graphics with information from a mysql database via php. For those unfamiliar with highcharts, here's a sample code below. Highcharts.chart('minhadiv', { chart: { type: 'bar' }, xAxis: {...
asked by 24.05.2018 / 13:17
0
answers

How to minimize mysql migration problems 4 to 5

Good evening guys, I have a system that was developed last year for a client. The client hired a server and the staff installed mysql 5 on it. The problem now that I'm in is that field int and date that are empty in the registration query of...
asked by 08.05.2018 / 03:26
0
answers

MYSQL - Detect break in sequence, with conditional

Hello, I need help to make a query or procedure to detect gaps in a numeric field, I have a fiscal invoice table, which has a num_nfe field, it must follow a sequence, there can not be gaps in the numbers and I must check in another field, the s...
asked by 20.04.2018 / 14:29
0
answers

INSERT Database

I have a system similar to Vagalume / Spotify Where the artist has his page with the album list, and within the album, the songs ... But there are music with several artists participating in the title, I would like to use for example: Kid...
asked by 09.04.2018 / 00:05
0
answers

Maps Api JavaScript - Problem saving site search in MySql database

I need the user to click on the save button that is displayed when the marker is clicked, the location information is saved to the database. Hidden fields that receive values from the location when searched: <input type="hidd...
asked by 08.04.2018 / 00:13
2
answers

Search with a null value, mysql

I'm a beginner in programming and I'm trying to find something new, in this case, I have two selects fields that tell my values, but I'd like the search to be done even if a field is null This is the request code if($_SERVER['REQUEST_METHOD...
asked by 14.03.2018 / 13:38
0
answers

PHP Error: Too many connections

I'm getting some messages from my application, from many connections running. PHP Warning: mysqli_connect(): (08004/1040): Too many connections in /home/rmour123/public_html/admin/conexao.php on line 31 Below is the form I've implemented...
asked by 07.03.2018 / 14:36
1
answer

PHP / Mysqli (phpmyadmin) I try to insert into the database, but there is no error

Good luck, I need help with the following: I want to insert 3 simple information into the database, product name, price and image. Out of the form I opened a tag to show the output, but only shows the name! and in the database do not appear new...
asked by 30.01.2018 / 09:57
1
answer

Site only works locally, does not work online

I have a simple connection that my application uses to connect to the mysql database. Locally everything was fine, but putting online does not work anymore. I already changed several possible terms for the error I saw here in the topic...
asked by 20.01.2018 / 21:49