EasyUI Forum
May 15, 2024, 05:17:18 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Newbie Question  (Read 7991 times)
thezman
Newbie
*
Posts: 2


View Profile Email
« on: March 04, 2013, 08:15:04 PM »

I have a single mysql table I want to display using the DataGrid. Am I required to fetch the data from the table into a json or is there a way to populate the DataGrid directly from the mysql table?
Logged
devnull
Sr. Member
****
Posts: 431


View Profile
« Reply #1 on: March 04, 2013, 09:10:44 PM »

You can't do it directly, but you can create a generic PHP page and pass the query to it via the url:

soomepage.php?sql=Select * from Users where something is something



« Last Edit: March 06, 2013, 10:03:10 PM by devnull » Logged

-- Licensed User --
thezman
Newbie
*
Posts: 2


View Profile Email
« Reply #2 on: March 05, 2013, 07:48:10 PM »

Thanks. I have a PHP script to retrieve the data so I can probably just modify it for my purposes. Thanks.
Logged
devnull
Sr. Member
****
Posts: 431


View Profile
« Reply #3 on: March 06, 2013, 10:02:38 PM »

I guess I should state that creating a PHP page that allows SQL statements to be sent via the URL is a huge security risk !
Logged

-- Licensed User --
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!