tag:blogger.com,1999:blog-1892780101239299215.post677225037066447089..comments2024-03-29T02:37:18.881-05:00Comments on PHP, MySQL, Drupal, .htaccess, Robots.txt, Phponwebsites: Sorting column by clicking column header with php and mysql in tableGuruhttp://www.blogger.com/profile/00326436856590034534noreply@blogger.comBlogger43125tag:blogger.com,1999:blog-1892780101239299215.post-74576397943549881402021-05-23T08:14:27.553-05:002021-05-23T08:14:27.553-05:00You make so many great points here that I read you...You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. <a href="https://luxe-online.biz/%E3%82%B3%E3%83%AD%E3%83%8A%E6%99%82%E4%BB%A3%E3%81%AB%E6%B3%A8%E7%9B%AE%E3%81%AE%E3%83%8F%E3%82%A4%E3%83%AA%E3%82%BF%E3%83%BC%E3%83%B3%E6%8A%95%E8%B3%87%E8%A1%93%E2%80%95-%E3%81%93%E3%82%8C-2/" rel="nofollow">増田裕介</a><br />sameerhttps://www.blogger.com/profile/11479874470572537361noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-40275028794892857212021-04-01T00:21:12.968-05:002021-04-01T00:21:12.968-05:00Notice: Undefined index: field in C:\xampp7.3\htdo...Notice: Undefined index: field in C:\xampp7.3\htdocs\abc\sort.php on line 16 Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-81406684741496035332016-04-11T18:31:33.965-05:002016-04-11T18:31:33.965-05:00thanks sir for your great work.thanks sir for your great work.Richa Bohrahttps://www.blogger.com/profile/11567494854394173064noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-48684900149998858062016-03-16T04:49:39.692-05:002016-03-16T04:49:39.692-05:00Good work sir and it is so helpful for me you done...Good work sir and it is so helpful for me you done a good job.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-12585373809970699862015-10-14T14:48:15.026-05:002015-10-14T14:48:15.026-05:00if(isset($_GET['sirala']) && isset... if(isset($_GET['sirala']) && isset($_GET['sorting'])) {<br /> if ($_GET['sirala'] == 'uye_adi') {<br /> $_SESSION["sirala"] = "uye_adi";<br /> } elseif ($_GET['sirala'] == 'tarih') {<br /> $_SESSION["sirala"] = "tarih";<br /> }<br /> $field = $_SESSION["sirala"];<br /><br /> if ($_GET['sorting'] == 'ASC') {<br /> $_SESSION["sort"] = "DESC";<br /> } elseif($_GET['sorting'] == 'DESC') {<br /> $_SESSION["sort"] = "ASC";<br /> }<br /> $sort = $_SESSION["sort"];<br /> }<br /><br /> if(isset($_SESSION["sirala"])) {<br /> $field = $_SESSION["sirala"];<br /> }<br /> if(isset($_SESSION['sort'])) {<br /> $sort = $_SESSION["sort"];<br /> }Gürhan Battırhttps://www.blogger.com/profile/17286213941368357146noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-91982480631074675592015-10-14T14:43:13.603-05:002015-10-14T14:43:13.603-05:00This comment has been removed by the author.Gürhan Battırhttps://www.blogger.com/profile/17286213941368357146noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-76230651329740744032015-10-14T14:37:53.197-05:002015-10-14T14:37:53.197-05:00This comment has been removed by the author.Gürhan Battırhttps://www.blogger.com/profile/17286213941368357146noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-33097926846661681332015-10-14T14:23:26.639-05:002015-10-14T14:23:26.639-05:00This comment has been removed by the author.Gürhan Battırhttps://www.blogger.com/profile/17286213941368357146noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-23286455814863645492015-10-14T11:32:26.209-05:002015-10-14T11:32:26.209-05:00This comment has been removed by the author.Gürhan Battırhttps://www.blogger.com/profile/17286213941368357146noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-62840669832754780102015-10-13T16:26:35.266-05:002015-10-13T16:26:35.266-05:00This comment has been removed by the author.Gürhan Battırhttps://www.blogger.com/profile/17286213941368357146noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-30230846229497617092015-10-13T16:24:05.632-05:002015-10-13T16:24:05.632-05:00This comment has been removed by the author.Gürhan Battırhttps://www.blogger.com/profile/17286213941368357146noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-38241858352053982322015-10-13T16:20:19.777-05:002015-10-13T16:20:19.777-05:00This comment has been removed by the author.Gürhan Battırhttps://www.blogger.com/profile/17286213941368357146noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-15838796125803010012015-10-13T14:21:09.223-05:002015-10-13T14:21:09.223-05:00This comment has been removed by the author.Gürhan Battırhttps://www.blogger.com/profile/17286213941368357146noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-8244111434591282482015-10-08T04:41:55.853-05:002015-10-08T04:41:55.853-05:00This comment has been removed by the author.Gürhan Battırhttps://www.blogger.com/profile/17286213941368357146noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-38489511415353113062015-08-22T09:50:09.396-05:002015-08-22T09:50:09.396-05:00i have written the same code as you given above bu...i have written the same code as you given above but it cannot sort the table plz correct my errors from below codes. Thanks in advance.<br /><br />$select_query=mysqli_query($DB_Connect,"SELECT * FROM users ORDER BY $field $sort");<br /><br /><a href="users.php?sorting='.$sort.'&field=ID" rel="nofollow">ID</a><br /><a href="users.php?sorting='.$sort.'&field=First_Name" rel="nofollow">First Name</a><br /><br />if(isset($_GET['sorting']))<br />{<br />if($_GET['sorting']=='ASC')<br />{<br />$sort='DESC';<br />}<br />else<br />{<br />$sort='ASC';<br />}<br />}<br /><br />if(isset($_GET['field'])=='ID')<br />{<br />$field="ID";<br />}<br />elseif(isset($_GET['field'])=='First_Name')<br />{<br />$field="First_Name";<br />}Shree Kordehttps://www.blogger.com/profile/08933023951102507990noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-54566579123271175542015-04-08T23:51:36.961-05:002015-04-08T23:51:36.961-05:00<html>
<head>
<style type="t...<html><br><br /><head><br><br /> <style type="text/css"><br><br /> Add above style here..<br><br /> </style><br><br /></head><br><br /><body><br><br /> Add above PHP code here and add class to table<br><br /></body><br><br /></html>Guruhttps://www.blogger.com/profile/00326436856590034534noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-410636558818205452015-04-08T10:53:37.387-05:002015-04-08T10:53:37.387-05:00do you know how i can add below styles to php tabl...do you know how i can add below styles to php table?<br /><br />a:link {color: white;} /* unvisited link */<br />a:visited {color: white;} /* visited link */<br />a:hover {color: white;} /* mouse over link */<br />a:active {color: white;} /* selected link */<br />a:link {text-decoration: none;}<br /><br />a:visited {text-decoration: none;}<br /><br />a:hover {text-decoration: underline;}<br /><br />a:active {text-decoration: underline;}<br /><br />table.tableizer-table {<br />border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif;<br />font-size: 12px;<br />}<br />.tableizer-table td {<br />padding: 4px;<br />margin: 3px;<br />border: 1px solid #ccc;<br />}<br />.tableizer-table th {<br />background-color: #104E8B;<br />color: #FFF;<br />font-weight: bold;<br />}Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-61927431302780198472015-04-08T00:10:56.367-05:002015-04-08T00:10:56.367-05:00I want to add below style php table. How you can d...I want to add below style php table. How you can do that?<br /><br /> a:link {color: white;} /* unvisited link */<br /> a:visited {color: white;} /* visited link */<br /> a:hover {color: white;} /* mouse over link */<br /> a:active {color: white;} /* selected link */<br />a:link {text-decoration: none;}<br /><br />a:visited {text-decoration: none;}<br /><br />a:hover {text-decoration: underline;}<br /><br />a:active {text-decoration: underline;}<br /><br />table.tableizer-table {<br /> border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif;<br /> font-size: 12px;<br />} <br />.tableizer-table td {<br /> padding: 4px;<br /> margin: 3px;<br /> border: 1px solid #ccc;<br />}<br />.tableizer-table th {<br /> background-color: #104E8B; <br /> color: #FFF;<br /> font-weight: bold;<br />}<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-26206597024415722082015-04-07T23:32:20.561-05:002015-04-07T23:32:20.561-05:00it works. Thanksit works. ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-420251753228066962015-04-06T23:46:14.351-05:002015-04-06T23:46:14.351-05:00Add this code at top of your code snippet.
error_...Add this code at top of your code snippet.<br /><br />error_reporting('E_ALL ^ E_NOTICE');Guruhttps://www.blogger.com/profile/00326436856590034534noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-66453229369652291332015-04-06T14:22:00.337-05:002015-04-06T14:22:00.337-05:00HI,
sorting is working fine but i got this error ...HI,<br /><br />sorting is working fine but i got this error "Undefined index: field" when i rain the code.<br />do you know why?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-59622409998615173302015-02-12T04:02:18.579-06:002015-02-12T04:02:18.579-06:00hi men,
i have wrong code at:
'NIK'
the r...hi men,<br />i have wrong code at:<br />'<a href="javascript:void(0);" rel="nofollow">NIK</a>'<br /><br />the right code is:<br /><a href="javascript:void(0);" rel="nofollow">NIK</a><br /><br />without '<br /><br />and now it works perfectly thanks guruAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-39247608929962722802015-02-12T03:52:56.298-06:002015-02-12T03:52:56.298-06:00yup i have set $sort = DESC; And this is my code
...yup i have set $sort = DESC; And this is my code <br /><br />$sort='DESC';<br />echo $sort;<br />if(isset($_GET['sorting']))<br />{<br /> if($_GET['sorting']=='ASC')<br /> {<br /> $sort='DESC';<br /> }<br /> else<br /> {<br /> $sort='ASC';<br /> }<br />}<br /><br />< my code ><br /><br />according to me, $sort catch this value<br />else<br />{<br />$sort = 'ASC';<br />}<br /><br />do you have any idea?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-49822006111923359142015-02-12T01:37:02.070-06:002015-02-12T01:37:02.070-06:00Did you get any error?Did you get any error?Guruhttps://www.blogger.com/profile/00326436856590034534noreply@blogger.comtag:blogger.com,1999:blog-1892780101239299215.post-17019497244607374842015-02-12T01:26:25.839-06:002015-02-12T01:26:25.839-06:00Hi thanks for your articel,
But i have problem, my...Hi thanks for your articel,<br />But i have problem, my table cant sort DESC.<br /><br />When I click the header, he always sort the table ASC.<br />so i cant sort it DESC<br /><br />Any idea ??Anonymousnoreply@blogger.com