Tag: mysql

Show a text depending on the value of a column MySQL

I would like to know, how can I build a query that shows me an extra column where instead of showing the true value of the original column it shows me the text that i want? For example, The Column, in this case “inputOutput”, save values 0 or 1, and I would like to show in a query that if

How to display my JSON response in a table using Laravel?

ajax laravel mysql php search

I’m trying to create Live search in Laravel using AJAX with one of my tables. I watched a YouTube video on this and I got to around 18:00 min on the 21 minute video. At this point there was no LIVE …

laravel BelongsToMany pagination

eloquent laravel laravel-5 mysql php

i have 2 model 1 – category with parent and child class Category extends Model { protected $primaryKey = ‘id’; public $fillable = [‘slug’,’title’,’icon’,’parent_id’]; /** * Get the index name …

How to make a mysql query constantly refresh in PHP?

ajax ajax-polling javascript mysql php

I’m making a basic chat room. My code: $conn = (“127.0.0.1″,”root”,””,”mymessages”); $stmt = “SELECT * FROM posts ORDER BY timestamp LIMIT 100”; $result = mysqli_query($conn, $stmt); if(!$result) { …

How should I change the database layout of my html form to make it more scalable?

database database-design forms mysql php

I have a HTML form which sends the results to a database currently. The questions are hardcoded to the html page and I am trying to make the form more scalable, dynamic and flexible. I got suggested …

Reverse Table rows in While Loop

mysql php

I am appending rows to a table that has pagination. My db query sorts by ASC which is what I need but the order of records should be reversed on each page. So the first page should be the newest …

MySQL server has gone away, inconsistent error, caused by a single script

database-connection mysql php timeout

I have a PHP script that is launching an SQL query, which takes a few seconds and returns about 15K+ results, after making a complex calculation based on data found on a DB table on my server, named …

I want to show or fetch data from two tables [closed]

mysql php

I want to show or fetch teacher’s name but it always fetch only the teacher’s id, Thanks for your help. This is my code: <?php include('../dbcon.php'); $query=mysqli_query($connection,…

left join query of mysql php

foreign-keys html mysql php

I’m working on a project where i have two tables 1 is the Users table and another one in the Department table. here i have given foreign key connection to department table to the users table and …

FPDF: Add Comment at the last page

fpdf mysql php

Currently, I created a system that can generate data from MySQL to pdf. The arrangement of data that display to the pdf is: 1) The first page will display only 1 data rows 2) 2nd Page onwards will …