How will I fetch data from a MySql database table?

[Cihat aydın]

Hi friends,

I've been searching a grid solution to bring data from a table I have in my database for such a long time. I tried almost all. Among all, Handsontable looks quite appealing and adequate, so I want to try. But as I don't have practical info about coding, I don't know how to do it with mysql tables. If I had a fully working example, I could manage to change the relevant parts.

Could anyone out there help me?

[pwl.sm...@gmail.com]

The apropriate example is already there. Have a look at integrating HandsonTable with PHP backed to get an idea behind fetching data from database and putting them into HandsonTable.

https://github.com/warpech/jquery-handsontable/tree/master/demo

(php.html and files in php/ directory)

Regards

Paul

Wiadomość napisana przez Cihat aydın <ciha...@gmail.com> w dniu 11 lip 2013, o godz. 18:39:

Hi friends,

I've been searching a grid solution to bring data from a table I have in my database for such a long time. I tried almost all. Among all, Handsontable looks quite appealing and adequate, so I want to try. But as I don't have practical info about coding, I don't know how to do it with mysql tables. If I had a fully working example, I could manage to change the relevant parts.

Could anyone out there help me?

--
You received this message because you are subscribed to the Google Groups "Handsontable" group.
To unsubscribe from this group and stop receiving emails from it, send an email to handsontable...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Cihat aydın]

Hımm, I couldn't express myself properly I think. I've already seen the example and related php files. And I've already searched the issues on github. But even the example itself doesn't work.

I'm not a man of codes as I told before. The codes in php files include sqlite (I guess). During my other trials I got acquainted to mysql strings just a bit. That's why I don't understand what to change. Maybe it's more secure but security isn't my concern because I'll use it in a private system.

I'm not sure if it's proper to say like that but I'll say because I need HoT: "Can anybody change the codes for me with the values below?

Host: "localhost"

User: "root"

Pass: "blank"

DbName: "sorgu1"

TblName: "satislar"

Database Type: "MySql"

If I've been rude with asking for help like that, please forgive me. Then I'll try to live without HoT.

11 Temmuz 2013 Perşembe 20:38:52 UTC+3 tarihinde Paweł Smoleński yazdı:

[alberto.ca...@gmail.com]

Buenas noches la verdad que no he podido enlazar una tabla de mi base de datos con handsontable. EStoy realizando una consulta con php sobre mysql y no he podido ver los resultados en handsontable. El ejemplo que viene en el tutorial funciona a las mil maravillas, pero cuando se realiza con una tabla en mysql no funciona, tampoco funciona si la conexion con mysql se realiza a traves de PDO o si la tabla tiene de mysql tiene mas de 12 columnas. Alguien a podido realizar este tipo de pruebas y le ha funcionado?