Activity for MySQL Edit Table
-
MySQL Edit Table released /readme.txt
-
-
-
-
Ervin posted a comment on discussion Help
Hello! I add one column in my SQL, but now display error if i like to save new recor, or edit old record PHP Warning: Undefined property: MySQLtabledit::$content in /mte/mte.php on line 846 PHP Warning: Undefined property: MySQLtabledit::$content in /mte/mte.php on line 842 Please help me
-
Oleg posted a comment on discussion Help
I solve the problem. Problem was in my database, i just use a sql constructios as in test database
-
Hello! I install Table Editor on localhost and try to add new record. The programm write an error that value of id could not be NULL. I have no idea how to change the code to make this programm able to add new records. But other functions are working.
-
Daniel Tuvestam posted a comment on discussion Help
I have notices in the new version 1.3.2 if the table is empty there is an error. Warning: Undefined variable $rows in /www/webvol7/7e/px07r9frdj9kfnv//mte/mte.php on line 451 Nothing big but just so you know.
-
-
-
-
Martin posted a comment on discussion Help
Thank you, I will add in version 1.3.2
-
Thanks! I will edit this line in the new version.
-
You are the hero of the day!!!
-
Hi Daniel, New version with PHP8 support today.
-
Is there any plans on updating this to support PHP8? I love this but us our host provider is moving to PHP 8 we need to change our site to support this.
-
I found on line 204 in mte.php that you should add (int). old code: $start = $_GET["start"]*1; new code $start = (int)$_GET["start"]*1;
-
I found on line 204 in mte.php that you should add (int). $start = $_GET["start"]1; -> $start = (int)$_GET["start"]1;
-
Geert De Baets posted a comment on discussion Help
Hi all, I wonder if anyone has a solution for this: I would like to add a second drop-down to the search form, in order to 'filter' the search results to one only jobname. Example: [Search argument] for [1st dropdown with list of all the fields] only in [2nd dropdown with a list of all the jobnames] Is this possible? I'm not an expert - I've tried pretty hard but didn't manage to make it work :( TIA for any help :) Geert
-
Jim Frayer posted a comment on discussion Help
Hi Andre, What line int mte.php did you place your code or did you overwrite the lookup_table section? Thanks.
-
Wayne Hancock posted a comment on discussion Help
Anyone been able to add a Navagation row of buttons with it's own CSS file?
-
Gonzalo Vera posted a comment on discussion Help
Hi! I translated to mexican spanish. Can be used for -at least- all latinamerican spanish. Here goes: <?php /** * Spanish language file - version .1 * */ $this->text['Add_Record'] = 'Registro nuevo'; $this->text['Clear_search'] = 'Reinicia búsqueda'; $this->text['Search'] = 'Busca'; $this->text['Go_back'] = 'Regresa'; $this->text['Save'] = 'Guarda'; $this->text['saved'] = 'Guardado'; $this->text['Delete'] = 'Eliminar'; $this->text['Edit'] = 'Editar'; $this->text['deleted'] = 'borrado'; $this->text['Previous']...
-
Freddy Romano posted a comment on discussion Help
me too.
-
Manoj Manmathan modified a comment on discussion Help
upon click save, the webpage shows http 500 error, but the url is fine, Upon click enter key it takes to the proper webpage. Found that the issue happens when loading the function close_print on the line $this->content. Please help to fix. (However, it does save to the db.) This works fine upon adding an 'exit' to the end of function save_rec().
-
upon click save, the webpage shows http 500 error, but the url is fine, Upon click enter key it takes to the proper webpage. Found that the issue happens when loading the function close_print on the line $this->content. Please help to fix. (However, it does save to the db.) This works fine upon adding an 'exit' to the end of function save_rec().
-
upon click save, the webpage shows http 500 error, but the url is fine, Upon click enter key it takes to the proper webpage. Found that the issue happens when loading the function close_print on the line $this->content. Please help to fix. (However, it does save to the db.) This works fine upon adding an 'exit' to the end of function save_rec().
-
upon click save, the webpage shows http 500 error, but the url is fine, Upon click enter key it takes to the proper webpage. Found that the issue happens when loading the function close_print on the line $this->content. Please help to fix. (However, it does save to the db.)
-
Andrey modified a comment on discussion Help
Good morning! I have non auto-increment primary key, so what should I add to code to make it work? Error Column 'ID' cannot be null (ID is primary key) I have discommented those 4 lines, but it still doesnt work I wish you would help me
-
Good morning! I have non auto-increment primary key, so what should I add to code to make it work? Error Column 'ID' cannot be null (ID is primary key) I have discomment those 4 lines, but it still doesnt work I wish you would help me
-
Good morning! I have non auto-increment primary key, so what should I add to code to make it work? Error Column 'ID' cannot be null (ID is primary key) I wish you would help me
-
maryem ghobber posted a comment on discussion Help
Thanks Martin
-
Hi Maryem, Add error_reporting(0); or ini_set('display_errors', 0); in the beginning of your script Martin
-
Hi Maryem, This mte.php is a very old version. The function mysql_connect is deprecated in PHP 5.5.0, and removed in PHP 7.0.0. Your local machine is using > PHP 7. Please use the new version. I hope it is compatible wth Web Builder. Succes! Martin
-
Hi, Martin i'm using WYSIWYG Web Builder 14.0.2 and you will find my mte file in attachment Thanks Martin.
-
Hi Maryem, Don't know which version "WYSIWYG Web Builder 14" uses, but mysql_connect is an old funtion. MySQL Edit Table switched to msqli Can you post your mte-file here? Martin
-
Hi Martin . I think i have the same problem ,I am trying to create a website using the MySQL Table Editor WYSIWYG Web Builder 14. i m filling the blanks with my database information like this : server: localhost database: plan table: users username:root passeword: primary key: id When I run my site on my localhost, I am getting many errors : ( ! ) Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\wamp64\www\test\mte.php on line 93 ( ! ) Error: Call to undefined function...
-
Hi Martin . I think i have the same problem ,I am trying to create a website using the MySQL Table Editor WYSIWYG Web Builder 14. i m filling the blanks with my database information like this : server: localhost database: plan table: users username:root passeword: primary key: id When I run my site on my localhost, I am getting many errors : ( ! ) Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\wamp64\www\test\mte.php on line 93 ( ! ) Error: Call to undefined function...
-
Hi Martin . I think i have the same problem ,I am trying to create a website using the MySQL Table Editor WYSIWYG Web Builder 14. i m filling the blanks with my database information like this : server: localhost database: plan table: users username:root passeword: primary key: id When I run my site on my localhost, I am getting many errors : ( ! ) Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\wamp64\www\test\mte.php on line 93 ( ! ) Error: Call to undefined function...
-
Hi Martin . I think i have the same problem ,I am trying to create a website using the MySQL Table Editor WYSIWYG Web Builder 14. i m filling the blanks with my database information like this : server: localhost database: plan table: users username:root passeword: primary key: id When I run my site on my localhost, I am getting many errors : ( ! ) Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\wamp64\www\test\mte.php on line 93 ( ! ) Error: Call to undefined function...
-
Hi Martin . I think i have the same problem ,I am trying to create a website using the MySQL Table Editor WYSIWYG Web Builder 14. i m filling the blanks with my database information like this : server: localhost database: plan table: users username:root passeword: primary key: id When I run my site on my localhost, I am getting many errors : ( ! ) Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\wamp64\www\test\mte.php on line 93 ( ! ) Error: Call to undefined function...
-
Charles Edward Casteel posted a comment on discussion Help
Thanks!! I really appreciate your quick response. Charles Casteel On Mar 8, 2019, at 5:53 AM, Martin bookman-nl@users.sourceforge.net wrote: Hi Charles, The quick way is: Add this code on line 2 of your edit-script ini_set('display_errors', 0); MySQL Edit Table Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/sql-edit-table/discussion/1308092/ To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
-
Hi Charles, The quick way is: Add this code on line 2 of your edit-script ini_set('display_errors', 0);
-
Hi Charles, The quick way is: Add this code on line 2 of your edit-script ini_set('display_errors', 1);
-
Hi Charles, The quick way is: Add this code on line 2 of your edit-script ini_set('display_errors', 0);
-
I am creating a website locally so it is not live at this time. I am trying to use the MySQL Table Editor WYSIWYG Web Builder 14. When I run my site on my localhost, I am getting errors such as these below: Notice: Undefined index: mte_a in C:\xampp\htdocs\dashboard\mtpleasant\mte.php on line 155 Notice: Undefined index: mte_a in C:\xampp\htdocs\dashboard\mtpleasant\mte.php on line 158 Notice: Undefined index: mte_a in C:\xampp\htdocs\dashboard\mtpleasant\mte.php on line 161 Notice: Undefined index:...
-
Martin posted a comment on discussion Help
Encountered warnings A non-numeric value encountered in /var/www/html/mte/mte.php on line 204 I am not a PHP expert, so I simply fixed it by adding an AND clause if (isset($_GET["start"]) && $_GET["start"] != '') { in line 203.
-
Alessandro Del Rosso posted a comment on discussion Help
Thank you very much Martin, your change works like a charm! I wish you a merry Christmas and a happy New Year.
-
Hi Alessandro, Change in file mte.php: Find: $query_string&mte_a=edit&id=$value Replace by: mte_a=edit&id=$value&$query_string Tell me if this works and I will change it in the updated version. Martin
-
Hi, in my database I have a table populated with some text fields that contain names with a single quote (for example, the surname "D'Addario"). When I try to search this name with your search form, the query is successful and shows me the resulting row. But if I try to edit this row, the command doesn't work. The reason is that the URL associated with the "edit" icon it is truncated starting from " ' ". Returning to the previous example, when I searching "d'addario" the editing URL is the follow:...
-
-
Louis-Berthier posted a comment on discussion Help
Exactly! hahaha, my bad! Thank you, it work great! Did you merge the single quote fix?
-
Hi Louis, Is the field "Nom du site" a varchar (50)?
-
Hi Martin, Thank you for the fast answer. The single quote is now inserted but the string is truncated at 50 characters. Thanks! 0207000 - SEC - CSSS Lac St-Jean Est - Hôpital d'A vs 0207000 - SEC - CSSS Lac St-Jean Est - Hôpital d'Alma
-
Hi Louis, Try the mte.php (attachment) and tell me if this helps. Succes, Martin.
-
Hi, First, thank you for this great tool! The problem I currently have is with single quote. When there is a single quote in a list populated from another table, once inserted in the new table, the filed is truncated at the single quote. In this example, when I go in the database, I get : 0207000 - SEC - CSSS Lac St-Jean Est - Hôpital d I don't have this problem with manually completed field like "Commentaires". I don't want to reference the PK because the records are non static and will eventually...
-
I don't know what is wrong. I tested 'hardy_collection' and it worked. Required settings $tabledit->database = 'test'; $tabledit->host = 'localhost'; $tabledit->user = 'USERNAME'; $tabledit->pass = 'PASSWORD'; $tabledit->table = 'hardy_collection'; $tabledit->primary_key = '_rowid_'; $tabledit->fields_in_list_view = array('_rowid_','ID','Year');
-
Glen River posted a comment on discussion Help
Made those corrections. Still not showing.
-
Change the names of fields with spaces: Where Done -> Where_Done Title or Subject -> Title_or_Subject Where Listed -> Where_Listed
-
Hardy_Collection (Does not show) -- phpMyAdmin SQL Dump -- version 2.8.0.1 -- http://www.phpmyadmin.net -- -- Host: custsql-ipw11.eigbox.net -- Generation Time: Sep 03, 2018 at 10:16 AM -- Server version: 5.6.37 -- PHP Version: 4.4.9 -- -- Database: museum_basic2 -- -- -- Table structure for table hardy_collection -- CREATE TABLE hardy_collection ( _rowid_ int(11) NOT NULL AUTO_INCREMENT, Index varchar(11) NOT NULL, ID varchar(11) NOT NULL, Year varchar(33) NOT NULL, Where Done varchar(255) NOT NULL,...
-
Hi Glen, Can you post a dump of the structure of those tables?
-
Seems all working well but several Tables do not display. They show in drop down menue, however do not show any data. ??
-
Wale Akinyemi posted a comment on discussion Help
What is the best approach to make every field readable?
-
xarilaos posted a comment on discussion Help
How many types of users are supported? (guest/user/administrator)
-
mojtaba posted a comment on discussion Help
Hi dear, I want to add a column using MD5 function. Is it possible? tank you
-
Sepp Hugo Haselmann posted a comment on discussion Help
thank you! worked perfect for me
-
-
Hi, Yes, you can edit $tabledit->fields_in_list_view (the fields you want to see in "list view") Leave out the fields you don't want to see. Succes!
-
Good day, I want to hide columns in the overview. but when i edit i wanto see all columns. is this possible best regards, doc
-
André Fournier modified a comment on discussion Help
Index.php $tabledit->lt_product_tax = array( 'product_tax' => array( 'query' => "SELECT tax, tax_text FROM tax_rate;", 'option_value' => 'tax', 'option_text' => 'tax_text' ) ); $tabledit->lt_product_type = array( 'product_type' => array( 'query' => "SELECT type FROM product_types;", 'option_value' => 'type', 'option_text' => 'type' ) ); mte.php $lt_fieldname = 'lt_' . $key; if (isset($this->$lt_fieldname[$key])) { if (is_array($this->$lt_fieldname[$key])) { $result = mysqli_query($this->mysqli,$this->$lt_fieldname[$key]['query']);...
-
Index.php $tabledit->lt_product_tax = array( 'product_tax' => array( 'query' => "SELECT tax, tax_text FROM tax_rate;", 'option_value' => 'tax', 'option_text' => 'tax_text' ) ); $tabledit->lt_product_type = array( 'product_type' => array( 'query' => "SELECT type FROM product_types;", 'option_value' => 'type', 'option_text' => 'type' ) ); mte.php $lt_fieldname = 'lt_' . $key; if (isset($this->$lt_fieldname[$key])) { if (is_array($this->$lt_fieldname[$key])) { $result = mysqli_query($this->mysqli,$this->$lt_fieldname[$key]['query']);...
-
tdecurtins posted a comment on discussion Help
I ended up creating custom add and edit pages.
-
The only (and dirty) way: change the mte.php: If you want to make field 'email' readonly, add " || $key == 'email' " at line 560: if ($key == $this->primary_key || $key == 'email' ) { $style = "style='background:#ccc'"; $readonly = 'readonly'; }
-
The only (and dirty) way: change the mte.php: If you want to make field 'email' readonly, add " || $key == 'email' " at line 560: if ($key == $this->primary_key** || $key == 'email'**) { $style = "style='background:#ccc'"; $readonly = 'readonly'; }
-
The only (and dirty) way: change the mte.php: If you want to make field 'email' readonly, add " || $key == 'email' " at line 560: if ($key == $this->primary_key || $key == 'email') { $style = "style='background:#ccc'"; $readonly = 'readonly'; }
-
The only (and dirty) way: change the mte.php: If you want to make field 'email' readonly, add " || $key == 'email' " at line 560: if ($key == $this->primary_key || $key == 'email') { $style = "style='background:#ccc'"; $readonly = 'readonly'; }
-
There is only one look up table possible. In your code you replace the var lookup_table ($tabledit->lookup_table) so only the product_types appear in the editor (I think...)
-
Peter funek posted a comment on discussion Help
Hi Martin, i have little question. How can i block more fields like ID field(readonly)? In edit mode of course.
-
I am trying to have more than one drop down in the edit and add sections but when I add one then the other doesnt work. $tabledit->lookup_table = array( 'product_tax' => array( 'query' => "SELECT `tax`, `tax_text` FROM `tax_rate`;", 'option_value' => 'tax', 'option_text' => 'tax_text' ) ); $tabledit->lookup_table = array( 'product_type' => array( 'query' => "SELECT `type` FROM `product_types`;", 'option_value' => 'type', 'option_text' => 'type' ) );
-
Thanks Daniel!
-
Is there a way to get NULL insted of a value?
-
Is there a way to get the "job name" insted of the nuber in the list veiw? like in the edit... Make selectlist on inputfield based on another table in this example: employees.job is based on jobs.jobname: $tabledit->lookup_table = array( 'job' => array( 'query' => "SELECT id, jobname FROM jobs;", 'option_value' => 'id', 'option_text' => 'jobname' ) );
-
Swedish translation /* * Swedish language file - version .1.2 * / $this->text['Add_Record'] = 'Lägg till'; $this->text['Clear_search'] = 'Återställ'; $this->text['Search'] = 'Sök'; $this->text['Go_back'] = 'Tillbaka'; $this->text['Save'] = 'Spara'; $this->text['saved'] = 'Sparad'; $this->text['Delete'] = 'Tabort'; $this->text['Edit'] = 'Redigera'; $this->text['deleted'] = 'Borttagen'; $this->text['Previous'] = 'Föregående'; $this->text['Next'] = 'Nästa'; $this->text['Nothing_found'] = 'Inget hittat';...
-
Ole J. Almenningen posted a comment on discussion Help
Hi, I have added two parameters to mte, giving the possibility for limiting which parts of the table a certain user can see/edit. This required adding a query parameter and hidden POST fields several places, probably not done in the best way. Im a php novice. For several years :) And this will only work until the next mte-version, of course. Maybe others would need such a functionality? In that case - is there apossibility you can add a parametrisable filter (in addition to search) in a more professional...
-
Merci Jules! In the next version I will add most of your changes. The dirty fix on servers that display things: <?php ini_set('display_errors', 0); Was there a problem with line 566? Or did you want a text-box for the auto increment? $field = "<input type='hidden' name='$key' value=''>[auto increment]"; to: $result = mysqli_query ($this->mysqli, "SELECT $this->primary_key FROM $this->table ORDER BY $this->primary_key DESC LIMIT 1"); $row = mysqli_fetch_array ($result, MYSQLI_NUM); $new_last_id =...
-
Merci Jules! In the next version I will add most of your changes. The dirty fix on servers that display things: <?php ini_set('display_errors', 0); Was there a problem with line 566? Or did you want a text-box for the auto increment? $field = "<input type='hidden' name='$key' value=''>[auto increment]"; to: $result = mysqli_query ($this->mysqli, "SELECT $this->primary_key FROM $this->table ORDER BY $this->primary_key DESC LIMIT 1"); $row = mysqli_fetch_array ($result, MYSQLI_NUM); $new_last_id =...
-
Merci Jules! In the next version I will add most of your changes. The dirty fix on servers that display things: <?php ini_set('display_errors', 0); Was there a problem with line 566? Or did you want a text-box for the auto increment? $field = "<input type='hidden' name='$key' value=''>[auto increment]"; to: $result = mysqli_query ($this->mysqli, "SELECT $this->primary_key FROM $this->table ORDER BY $this->primary_key DESC LIMIT 1"); $row = mysqli_fetch_array ($result, MYSQLI_NUM); $new_last_id =...
-
Merci Jules! In the next version I will add most of your changes. The dirty fix on servers that display things: <?php ini_set('display_errors', 0); Was there a problem with line 566? Or did you want a text-box for the auto increment? $field = "<input type='hidden' name='$key' value=''>[auto increment]"; $result = mysqli_query ($this->mysqli, "SELECT $this->primary_key FROM $this->table ORDER BY $this->primary_key DESC LIMIT 1"); $row = mysqli_fetch_array ($result, MYSQLI_NUM); $new_last_id = $row[0]+1;...
-
Jules_R2 posted a comment on discussion Help
Hey dudes. I've been searching for a tool like Mysql table edit for a while, but once I've tried to use it... tons of warnings / errors. So, I just started PHP, but I solved the issues (basically undifined variables for most of them), and this is a fully working version of mte.php: https://www.mediafire.com/?j240dscrs0s554n Hope it helps. And.. please don't take care about my english.. I'm french actually. Jules.
-
Gary Phillips posted a comment on discussion Help
Well... still be nice to know, but I did just discover an easy workaround... and rather obvious. I can change the link name that calls the page that holds the Table Editor to call for that particular field listing and value upon load. Surprised I didn't notice it before. :)
-
Is there a way to make the Table Editor show a particular field with a particular value at startup? For example, show all the listings where the name was exactly the same, but at startup? Right now it shows all the listings with their primary ID numbers. I can have the field I want ready in the pull-down for search, but the search parameter must still be typed and submitted. If a field could be preset to show all with a particular value, that would be fantastic. Thanks! PS: I'm using the Web Builder...
-
Martin posted a comment on discussion Help
Merci beaucoup! The file is included in the new version.
-
Vielen Dank! The file is included in the new version.
-
-
Samuel Desnoës posted a comment on discussion Help
French translation file. Thanks for your work ! <?php /* * French language file -...
-
Robin Holler posted a comment on discussion Help
I quickly translated into german ... you may consider adding this to the language...
-
-
1 >
