Questions tagged as 'mysqli'

Tagged questions
1
answer

Is it possible to display the data in a table separately? [duplicate]

I have a table in my database and it contains a column with the following data: link.com/1, link.com/2, link.com/3, link.com/4 What I would like to know is if I have the query in PHP and return the value of the column where each value com...
asked by 15.02.2018 / 07:10
0
answers

Select record of each category mysql

How do I get the two records with the highest view of each category? I have 7 categories and would like to get the two items with the highest views of each of those 7 categories.     
asked by 06.02.2018 / 12:34
0
answers

I can not make left join and use GROUP BY

This is a system for selecting how many likes you have in each post! in the third image shows the relation of likes. of = user id and for the post id First image shows the result of how many likes each post has, but I also need to show pos...
asked by 10.02.2018 / 16:05
0
answers

report by date

I need help with putting together a report that has a search by date. Today, this report brings all DB data to the database, so I need it to be for selected dates. SQL can do it, the problem is even the report where the user places the date t...
asked by 30.03.2018 / 00:15
0
answers

Problem creating log

To create a log for my system to know that it has changed information, but the way I mounted it is giving Fatal error: Call to undefined function anti_injection () in: Can anyone help or give me some example log change logging in php / mysql?...
asked by 02.02.2018 / 16:37
0
answers

Perform a search on a table or another with PHP

What I would like is the following: I have two tables, being tabelaA and tabelaB . I want the search term if not found in one table, be queried in another table. I do not know if there's anything you can do to put the two tables tog...
asked by 05.02.2018 / 22:00
0
answers

Error importing bank records to chart

In my old system I had a hightcharts chart that imports the records values from my database table, however, when using the same model on another system, the following error began to appear:    Notice: Undefined index: SCJan in C: \ Program Fi...
asked by 27.01.2018 / 12:44
1
answer

Error: Catchable fatal error: Object of class stdClass could not be converted to string in

I'm trying to make an html table equal to my database table, however, on the page that is in the table the following error appears:    Catchable fatal error: Object of class stdClass could not be converted   to string in The part of the c...
asked by 24.01.2018 / 12:44
0
answers

Filter in .json file parameters

I created an .json file using the following code: <?php function get_data(){ $connect = mysqli_connect("localhost", "root", "", "videos"); $query = "SELECT * FROM 'tb_indice'"; $result = mysqli_query($connect, $query); $data = array(); whi...
asked by 20.01.2018 / 18:36
1
answer

Calculate the total of a column table based on the checkbox picking only the selected ones

I have the following table: <div class="table-responsive"> <form class="form-inline" action="registrosVazios.php" method="GET"> <table id="tabelaCupons" class="table table-condensed table-bordered table-striped" bord...
asked by 19.01.2018 / 14:37