New to Translating WordPress? Read through our Translator Handbook to get started. Hide
| Prio | Original string | Translation | — |
|---|---|---|---|
| To specify a search form using ABASE, you will use at least the table="?", columns="?", elements="?" and form="?" attributes. If you would like your search results to appear on the same page, you do not need to specify the URL page of the search results in the form="" attribute. | You have to log in to add a translation. | Details | |
Original untranslated
To specify a search form using ABASE, you will use at least the table="?", columns="?", elements="?" and form="?" attributes. If you would like your search results to appear on the same page, you do not need to specify the URL page of the search results in the form="" attribute.
You have to log in to edit this translation. |
|||
| The format of the first name field will be a text box 100 pixels wide and the font size will be 12 point. The height defaults to 18 pixels. The last name field will be renamed on the form "Password" and the form element will be a password type (so what is typed on the screen is hidden). The password form element will be 100 pixels wide and 15 pixels in height. | You have to log in to add a translation. | Details | |
Original untranslated
The format of the first name field will be a text box 100 pixels wide and the font size will be 12 point. The height defaults to 18 pixels. The last name field will be renamed on the form "Password" and the form element will be a password type (so what is typed on the screen is hidden). The password form element will be 100 pixels wide and 15 pixels in height.
CommentFound in faq paragraph. You have to log in to edit this translation. |
|||
| [abase form="1,insert" table="employees" columns="first_name!'width:100px;font-size:12pt;',Password^last_name!'password 100;15'$Add Employee" elements="first_name,last_name" ack="red"] | You have to log in to add a translation. | Details | |
Original untranslated
[abase form="1,insert" table="employees" columns="first_name!'width:100px;font-size:12pt;',Password^last_name!'password 100;15'$Add Employee" elements="first_name,last_name" ack="red"]
CommentFound in faq paragraph. You have to log in to edit this translation. |
|||
| Formatting takes place in either the columns, fields or cols attribute. Changing the title of a column precedes the name with a carrot (^) character. Element formatting follows the name with an exclamation point (!) in single quotes ('). Within the single quotes can begin optionally with the type of form element followed by a space, then either (a) 1, 2 or 3 integers separated by semicolons, or (b) contents of an HTML style attribute. 1 to 3 integers correspond to width, height and vertical-align values in pixels. An HTML style attribute can specify width, height, vertical-align, font-size, font-family, and anything else. For example, | You have to log in to add a translation. | Details | |
Original untranslated
Formatting takes place in either the columns, fields or cols attribute. Changing the title of a column precedes the name with a carrot (^) character. Element formatting follows the name with an exclamation point (!) in single quotes ('). Within the single quotes can begin optionally with the type of form element followed by a space, then either (a) 1, 2 or 3 integers separated by semicolons, or (b) contents of an HTML style attribute. 1 to 3 integers correspond to width, height and vertical-align values in pixels. An HTML style attribute can specify width, height, vertical-align, font-size, font-family, and anything else. For example,
CommentFound in faq paragraph. You have to log in to edit this translation. |
|||
| The form attribute specifies a form to insert records, and the "1" indicates this form consists of only 1 shortcode (this one). The elements attribute specifies which fields are form input elements and the columns attribute specifies which fields are displayed and their formatting. The "$Add" specifies the submit button following the color field, with "Add" being the button text. The elements attribute specifies the first_name and last_name fields will be form input elements. The ack attribute requests an acknowledgement be displayed in red when data is inserted. | You have to log in to add a translation. | Details | |
Original untranslated
The form attribute specifies a form to insert records, and the "1" indicates this form consists of only 1 shortcode (this one). The elements attribute specifies which fields are form input elements and the columns attribute specifies which fields are displayed and their formatting. The "$Add" specifies the submit button following the color field, with "Add" being the button text. The elements attribute specifies the first_name and last_name fields will be form input elements. The ack attribute requests an acknowledgement be displayed in red when data is inserted.
CommentFound in faq paragraph. You have to log in to edit this translation. |
|||
| [abase form="1,insert" table="employees" columns="first_name,last_name$Add Employee" elements="first_name,last_name" ack="red"] | You have to log in to add a translation. | Details | |
Original untranslated
[abase form="1,insert" table="employees" columns="first_name,last_name$Add Employee" elements="first_name,last_name" ack="red"]
CommentFound in faq paragraph. You have to log in to edit this translation. |
|||
| [abase sql="ALTER TABLE employees ADD FOREIGN KEY ( title_key ) REFERENCES titles (title_id) ON DELETE RESTRICT ON UPDATE RESTRICT"] | You have to log in to add a translation. | Details | |
Original untranslated
[abase sql="ALTER TABLE employees ADD FOREIGN KEY ( title_key ) REFERENCES titles (title_id) ON DELETE RESTRICT ON UPDATE RESTRICT"]
CommentFound in faq paragraph. You have to log in to edit this translation. |
|||
| Finally, set the foreign key relationship. | You have to log in to add a translation. | Details | |
Original untranslated
Finally, set the foreign key relationship.
CommentFound in faq paragraph. You have to log in to edit this translation. |
|||
| [abase sql="ALTER TABLE employees ENGINE = INNODB"]↵ [abase sql="ALTER TABLE employees ADD title_key INT NOT NULL, ADD INDEX ( title_key )"] | You have to log in to add a translation. | Details | |
Original untranslated
[abase sql="ALTER TABLE employees ENGINE = INNODB"]↵
[abase sql="ALTER TABLE employees ADD title_key INT NOT NULL, ADD INDEX ( title_key )"]
CommentFound in faq paragraph. You have to log in to edit this translation. |
|||
| Make your employees table InnoDB also and add the column that will contain the foreign key. | You have to log in to add a translation. | Details | |
Original untranslated
Make your employees table InnoDB also and add the column that will contain the foreign key.
CommentFound in faq paragraph. You have to log in to edit this translation. |
|||
| [abase sql="CREATE TABLE titles (title_id int(11) NOT NULL AUTO_INCREMENT, title_name varchar(50) DEFAULT NULL, PRIMARY KEY (title_id)) ENGINE=InnoDB"] | You have to log in to add a translation. | Details | |
Original untranslated
[abase sql="CREATE TABLE titles (title_id int(11) NOT NULL AUTO_INCREMENT, title_name varchar(50) DEFAULT NULL, PRIMARY KEY (title_id)) ENGINE=InnoDB"]
CommentFound in faq paragraph. You have to log in to edit this translation. |
|||
| To make the Title come from a separate Titles table, create your Titles table so it uses the InnoDB storage engine. | You have to log in to add a translation. | Details | |
Original untranslated
To make the Title come from a separate Titles table, create your Titles table so it uses the InnoDB storage engine.
CommentFound in faq paragraph. You have to log in to edit this translation. |
|||
| [abase sql="SHOW CREATE TABLE employees"] will display the SQL CREATE statement to create the table. | You have to log in to add a translation. | Details | |
Original untranslated
[abase sql="SHOW CREATE TABLE employees"] will display the SQL CREATE statement to create the table.
CommentFound in faq paragraph. You have to log in to edit this translation. |
|||
| [abase sql="SHOW COLUMNS FROM employees"] will display the structure of the employees table. | You have to log in to add a translation. | Details | |
Original untranslated
[abase sql="SHOW COLUMNS FROM employees"] will display the structure of the employees table.
CommentFound in faq paragraph. You have to log in to edit this translation. |
|||
| [abase table="employees" columns="first_name,last_name" ORDER="last_name,first_name"] will display only the first and last name columns in alphabetical order by last name. | You have to log in to add a translation. | Details | |
Original untranslated
[abase table="employees" columns="first_name,last_name" ORDER="last_name,first_name"] will display only the first and last name columns in alphabetical order by last name.
CommentFound in faq paragraph. You have to log in to edit this translation. |
|||
Export as
Comment
Found in faq paragraph.