1/7/2024 0 Comments Mysql tableeditI have just resolve my issue by modifying tableedit plugin. Also within the files "index.php" and "action.php" you will have to give the authentification for root instead of "" in the file, if you have configured a root password.įeli_x thanks for your suggestions and efforts. If there is a password, you will have to give it on the command line. INSERT INTO `tbl_2_ids` (`id0`, `id1`, `last_name`) VALUES ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1 In order to create the database "testing" with the tabel "tbl_2_ids" you can use the following batch file "database_mysql.batch".įor mysql perform the batch file by the command: mysql -u root -p < database_mysql.batch Live Table Data Edit Delete using Tabledit Plugin in PHP Be sure also to adopt the code for actions "edit" and "delete" within the file "action.php". This is achieved using a regular expression: $id_array = preg_split("/ /",$id_ser) (Serialization by the php function serialize() did not work, as there are quotations marks generated by the function, which are not transportet well by the INPUT_POST of tabledit.) Within the file "action.php" one has to "unserialize" the $id_ser back. A few of MATE's features are advanced search, order by columns, edit multiple rows, language support and join other tables. With it you can easily create web pages to edit mysql tables. $id_ser = $row." ".$row Īnd I use this "serialized" id as values for the first column of the displayed table. MySQL Ajax Table Editor is the best mysql table editor around. Therefore I used a kind of handmade serialization of the two identifiers by just putting them after each other separated by a semicolon. I changed the code from webslessons to this end. What you can do is to dump the two identifiers into one column. Tabledit does not work with two identifiers per se. (Honestly, second try, I only had to add the file into the directory.) Just tried the code from your source at webslessons, it worked at the first try.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |