Table with child rows from mysql table

Lukket Opslået 2 år siden Betalt ved levering
Lukket Betalt ved levering

I have a Mysql table, from which, using plugin called DataTables, I create a table on my Wordpress website. So basically I fetch a table with 10 columns and 300-400 rows. I want to understand how to fetch two more columns from SQL, let's say "price" and "salary", and insert those into child rows. I have seen some examples on the website but they seem either too complex for me or not suitable for SQL data. My current table is not using AJAX nor JSON to fetch data, I just make a query to sql, fetch results and input them into a table using something like "while ($queryRow = $queryResult->fetch_row()) {

echo "<tr>";

for($i = 0; $i < $queryResult->field_count; $i++){

echo "<td>$queryRow[$i]</td>";"

Reference for what I want to see: [login to view URL]

If it's not possible to do child rows using my current table's format, it's okay to change it if you explain me how to use it. Please consider that I'm using Wordpress and my webdev skills are not impressive. Thank you in advance!

PHP MySQL WordPress Datatables JavaScript

Projekt ID: #31904117

Om projektet

5 bud Remote projekt Aktiv 2 år siden

5 freelancere byder i gennemsnit $40 timen for dette job

evgendob

Hello. WordPress development expert ready to help you with a project. I have more than 400 good reviews and more than 9 years of development experience behind, so all job will be done with the best quality and timefram Flere

$50 USD på 1 dag
(643 bedømmelser)
8.2
nixtech

Hello Sir Can we discuss the job in details? I am willing to start right away Please check my profile for work and experience. Regards Ashwin

$70 USD på 1 dag
(364 bedømmelser)
7.1
satyajeetkeshari

Hello Client, I am an expert in WordPress, PHP / MySQL, JavaScript/JQuery, CSS and HTML. I can do the specified task . Thanks! Satyajeet

$30 USD på 1 dag
(148 bedømmelser)
5.5
ivanchenkodevel

Hi, there. As a web developer, I've been developing for over 5 yrs. We can discuss more details and work together. Thanks.

$20 USD in 7 dage
(2 bedømmelser)
2.2