![scriptcase show new tables scriptcase show new tables](https://static.filehorse.com/screenshots/developer-tools/scriptcase-screenshot-05.png)
Toolbar > Application ThemeClick on this icon to preview (and edit) the theme of your application. Toolbar > Project PropertiesClick on this icon to bring the Project Properties area where you can specify the database connection parameters. If you haven't saved your project before, you'll be prompted for a file name and location. Toolbar > Save Project Click on this icon to save the currently open project. Toolbar > Open Project Click on this icon to open a previously saved project. Table properties > Table view title The table view title is the title of the table as it will appear in the pages of the generated PHP application. You will have an empty project that contains only an empty database and predefined default styles. This is the starting point for any AppGini application.
#Scriptcase show new tables how to#
In this first example, we’ll see how to insert a new line directly from PHP.Toolbar > New project Click on this icon to start a new empty project. In PHP, there is a pack of functions, starting by mysqli_* that allow you to work with MySQL database. I’ll show you with PHP as it’s the most used language for MySQL, but you can find similar functions in other languages too.
#Scriptcase show new tables password#
You now know almost everything, the only step missing is how to check the used password is correct on sign in. But for my basic table, it’s enough ? PHP You can find the MySQL documentation here if you have any specific thing to handle. Once you have the MySQL Query set for your new users, you can click on “SQL” and paste it directly in PHPMyAdmin. This query will do the same thing for example: INSERT INTO users So, we just add the “MD5()” function to the password in text, and it will insert a line with a MD5 hash.īy the way, the auto_id field is not mandatory, and will be filled automatically even if you don’t set it to “NULL” in the query. In any case, here is an example: INSERT INTO users If you followed the previous method with PHPMyAdmin, you may have seen the MySQL query displayed on your screen.
![scriptcase show new tables scriptcase show new tables](https://live.staticflickr.com/4048/4398745585_46e4b4fa9d_n.jpg)
This should be more convenient than PHPMyAdmin to do this automatically. In this part, I’ll show you how to do the same thing directly in MySQL, but also with PHP. The password is correctly encrypted in the field Set a MD5 Password in MySQL and/or PHP directly
![scriptcase show new tables scriptcase show new tables](https://www.scriptcase.net/samples/tutoriais/form/img/img50.png)
![scriptcase show new tables scriptcase show new tables](https://www.scriptcaseblog.net/wp-content/uploads/2021/10/Design-sem-nome84-1-430x269.png)