Sorting and Ordering tables with PHP

Learn how to sort and order tables with PHP

[@elemjosh]

Thank you so much for this! I spent most of the day trying to figure this out, and then your video was succinct and perfect!

[@pablojosecardenaspalomino7184]

Thank you very much for sharing your knowledge. This helped me a lot. Greetings from Bogotá, Colombia.

[@mantasvalantinas9086]

Actually you're one of the best "Teachers/Lecturers" we have there @KZbin. But in the same time, it would be nice to have your code sheet @description area.

[@kanikan8660]

I have no words. Too great to be true. Keep up the good work!

[@luukschouten9108]

thank you so much i spend waaaay too long trying to get this lol, finally finished my assignment now xD

[@KaarlisStruuve]

Thank you for this amazing tutorial!

[@yitzchakkatzir1547]

I love the simplicity of this instead of using jquery and lots of other changes. The only thing I added was a set style color for the hyperlink to make it more visible/stable. Eg: style="color: yellow"

[@kazimahin9137]

thank you so much . you are my guru .

[@gussi123]

Excellent.. Cannot thank you enough..

[@Fendrickson]

echo "You are THE MAN.";

[@RonaldoKME]

your coding is super useful..!!! thx!!!

[@alexeyo264]

Good tutorial! Thank you!

[@TheMizz512]

thanks a lot!!!! u help me a lot with ur tutorial!

[@r_bilek]

Super ! THX !

[@jood12]

thank you very very much

[@murdochrutherford753]

This is so helpful. Thanks a load!

[@kangminglim3799]

tq so much ==,help me solve my practical ^^

[@faithdwsn1]

Q1: Is it possible to use this code while using a PHP Database object and mysql? Or does one have to be using mysqli exactly the way you are showing it? Feedback: I did almost everything the same, except I am getting a message back saying that "Trying to get property 'num_rows' of non-object"...I have checked and all the SELECT fields and I know I am grabbing genuine keywords from the database. So I don't know if this num_rows() function only grabs numbers, but Q2: what do I do if want to sort strings in my array lists and not numbers like yours? My table is made up of four headings of strings and names, not numbers.

[@phpBasics]

Feel free to send me a message on skype and I can explain both of these. CoolEditz

[@moniquenoche]

Good tutorial!

[@DramaticOgre]

Can you make a video how to re order the rows? Using move up/down buttons?

[@usmantahir09]

i apply your code but i get this error Warning: Attempt to read property "num_rows" on bool in D:\Usman\Web Development\XAMPP\htdocs\Work\index.php on line 138 No Record Can you help me asap??

[@BinkoBunko]

Also another quick question, sorry for all of these lol. Is there a way to take the delete database records video you made, and incorporate that in this? As in have another column with a little x or whatever that deletes the database record thats in the row with it? So at the end of row 2, you press delete, and the database record that corresponds with row 2 is gone?

[@phpBasics]

Got Skype?

[@BinkoBunko]

Yeah, you can add me at epicman987

[@alexaresposaiii7035]

the answer to my prayers

[@comptegmail273]

works thanks

[@shuyanchi5224]

Cannot thank you enough..

[@laurenkleinas1601]

Hi. This is exactly what I need! Is your code accessible anywhere?

[@ennem1945]

Hey, first of all, thank you for this video. So I'm using this video to sort tables as well, and I'm using the same variables as you are, but with some minor changes to suit my code. I noticed that you're using the variables order and sort in your $_GET statements, I'd just like to know where they're from, I'd like to know what changes I need to make to get it working properly with my code. Thank You :)

[@ennem1945]

All is well, forget the previous comment, I found the problem and it wasn't in the $_GET statements, thank you for the video though, it was very helpful :)

[@christianbosch9600]

Very good tutorial. But - as usual in tutorials - examples are used with easy settings. How can I sort column 3 and column 5 (as in Excel) for example? Do you have a tutorial for this too or planing to produce one?

[@phpBasics]

SELECT * FROM yourtable ORDER BY `column1` DESC, `column2` DESC

[@christianbosch9600]

Thanks. Sorry for my not very clear question. For example with your table if I sort "Asset Number" I want the "Serial Numbers" sorted too. And this means I have to put the code in the "

[@vandamieespadero6633]

How to sort data by their numeric amount? Like 34, 37, 38, 45, sort into 45, 38, 37, 34.

[@zerocz5425]

This does not work for me, but instead of link I created arrows, so my problem was solved. But I use your idea so, I would like to thank you for this tutorial. (sorry for my english)

[@rudisuciptokang2972]

How do you add search table feature in this sorting and ordering table with php ? any video for that ??

[@phpBasics]

If you want, send me a message on Skype:CoolEditz

[@BinkoBunko]

Once the table has been created and essentially appears like the end of the tutorial, is there a way to implement a search bar tha filters the list? So if I type in "1" it'll only show the rows that have "1" in them somewhere? Like this : pastebin.com/YwBeptus

[@nemanjamarkovic9818]

Awesome tut, i have done everything but it doesnt work, and not even show any error but still i dont get option to sort by name and surname, how can i contact you just to tell me what have i done wrong. Thank you

[@phpBasics]

Skype CoolEditz

[@nemanjamarkovic9818]

@@phpBasics I will send you a message in a moment

[@nemanjamarkovic9818]

@@phpBasics Messages sent i am Nemanja Markovic

[@nemanjamarkovic9818]

@@phpBasics Thank you so much you are the best

[@jayjay2979]

HELP ME :) HAVE ERROR :( THANKS ^ ^ Notice: Trying to get property of non-object in C:\xampp\htdocs\employee\sorting.php on line 19 No Records returned.

[@phpBasics]

That will happen when the query is looking for a column that isn't there. You probably have a typo or wrong information somewhere.

[@jayjay2979]

okay sir thanks. im a student want to learn more :D

[@heidimitchum705]

I have an error HELPPP

[@phpBasics]

Hi Heidi. Can you send me your code via pastebin?

[@heidimitchum705]

Not sure what pastebin is.

[@heidimitchum705]

I signed up for it but now it wil not let me send it to you since I did not pay for it.

[@phpBasics]

It's as website that simply allows you to copy and past text and share it. If you have skype, I can assist that way as well.

[@heidimitchum705]

I do have skype but also how would you see it if I post in PasteBin