Creating full-stack web applications based on database schema for free!

Posted on by Mark Feehily0

Today, we’re excited to announce the free pricing plan for our CRUD tool. That means that more customers than ever before can use Flatlogic for creating a proper CRUD React/Vue/Angular web application based on the database schema.

What can you do with the free plan for the CRUD tool

You can expect the same features and functionality whether you choose our Paid access or Free option. But obviously with some limitations:

Create up to 10 applications on different technology stacks: React, Vue, Angular, Node.js, Laravel, PostgreSQL, MySQL
Create a full-fledged CRUD application (up to 3 database entities) with code written using best practices
Download or push source code to Github an unlimited number of times
Preview the code before downloading/pushing it on Github
Get updates on libraries used in your app stack
Host instantly your application demo and see the latest deployment logs

Free vs Paid access to the CRUD tool: Choose what you need

Since launching Flatlogic, we see constant growth in the creation of CRUD applications. But we understand that not all of our users need the full functionality of the CRUD tool. We also understand that in the modern world of developer tools, before investing huge resources in mastering new tools, you want to get some value here and now for free – with this motivation we introducing a free plan for creating CRUD applications.

Thus the free plan fits your needs. If you:

Want quickly prototype the CRUD app

Want to test or get familiar with new technologies before investing much time in them
See the best practice on how to organize modern CRUD apps using best practices
Prefer to use starter kits/boilerplates while starting CRUD web applications

And while our Professional plan has always offered a more enhanced way to create CRUD applications, it also required additional steps to understand your needs before getting access.

Now, you can sign up for a free account for a CRUD tool, create applications in minutes, and understand without any hassle whether Flatlogic fits your needs or not.

Create a CRUD app for free!

The post Creating full-stack web applications based on database schema for free! appeared first on Flatlogic Blog.

Flatlogic Admin Templates banner

What is MySQL

Posted on by Mark Feehily0

MySQL: What is it?

MySQL is an open-source relational database management system that allows you to manage relational databases based on Structured Query Language (SQL) queries. It supports multiple platforms such as Windows, Ubuntu, Linux, macOS, etc. It was developed by Swedish company MySQL AB in 1994, which was acquired in 2008 by American tech company Sun Microsystems. Afterwards, in 2010 the American giant Oracle acquired Sun Microsystems, and since then MySQL de-facto belongs to Oracle.

The database is a structured set of data, for example, a straightforward shopping list or places to store massive quantities of information throughout a business network. The relational database is a digital repository that collects data and organizes it according to a relational model, where tables consist of rows and columns and the relationships between data items follow a strict logical structure. MySQL is a simple software toolkit we can use to perform, manage, and execute queries on such a database. 

Why use MySQL?

MySQL is the most popular RDBMS, let’s look at why this is like that:

Easy-to-use. The only thing you should learn before using MySQL is a basic knowledge of SQL (Structured Query Language).

Open-source. Virtually anyone can install, modify, and use MySQL because of its incredible ease of use. The source code uses the GPL, that is, the GNU General Public License, which specifies guidelines for what you can and can’t do with this application.

High Productivity. MySQL is possibly the fastest database language, according to a multitude of standard tests.

Scalability. MySQL supports multi-threading, meaning the ability of systems to easily operate on small and large quantities of data, clusters of machines, etc. 

Security. MySQL is composed of a strong security level of data that protects confidential data from attackers. The interface is also secure because it has a versatile password system and guarantees host-based validation before accessing the database. 

Multiple data types. MySQL contains many data types, like integers, float, double, char, varchar, text, blob, date, time, DateTime, timestamp, etc.

Community. The community is very large, so if you get stuck anywhere then you can get help from the community.

Client-Server Architecture. MySQL is a client-server based architecture and accessible from anywhere through networking, i.e. each machine communicates with the server via an Internet connection. The server handles requests from the client and returns the result to the client machine. Clients can send queries to remote servers using an Internet connection, but the main requirement is keeping the server active at the time.

Who uses MySQL

MySQL is the most popular and useful database system, the largest and most important companies are probably choosing it such as:

Uber
Twitter
Slack
Airbnb
Pinterest
Amazon

Using the Flatlogic Platform you can also generate an application with a MySQL database system.

How to create your app with Flatlogic Platform

Step 1. Choosing the Tech Stack

In this step, you’re setting the name of your application and choosing the stack: Frontend, Backend, and Database.

Step 2. Choosing the Starter Template

In this step, you’re choosing the design of the web app.

Step 3. Schema Editor

In this part you will need to know which application you want to build, that is, CRM or E-commerce, also in this part you build a database schema i.e. tables and relationships between them.

If you are not familiar with database design and it is difficult for you to understand what tables are, we have prepared several ready-made example schemas of real-world apps that you can build your app upon modification:

E-commerce app;
Time tracking app;
Books store;
Chat (messaging) app;
Blog.

Like all databases in MySQL, there are such types of table relationships as relation_one, relation_many. You can enforce the relationships by defining the right foreign key constraints on the columns.

Relation (one) – one-sided relation capable of storing one or another entity, for example, Employee: [{ name: ‘John’}].
Relation (many) – two-sided relation capable of storing any number of other entities, for example, Employee: [{ name: ‘John’ }, { name: ‘Joe’ }].

Afterwards, you can deploy your application and in a few minutes, you will get a fully functional CMS application with a MySQL database system.

The post What is MySQL appeared first on Flatlogic Blog.

Flatlogic Admin Templates banner

What is PHP?

Posted on by Mark Feehily0

Introduction: What is PHP

PHP (an acronym for Hypertext Pre-processor or the previous one Personal Home Pages) is a server-side open-source scripting language. It is great for dynamic content management, session tracking, databases, and has fantastic community support.

PHP is a weak dynamic typing language, meaning it auto determines a lot of implicit conversions, even though there may be a lack of precision or equivocal conversions. In 2020 PHP 8 came out. It has a JIT (just-in-time) Compilation, which sped up the work of the Preprocessor multiple times.

PHP is a popular programming language and is the foundation of such CMSs as WordPress (powers 43% of all the websites on the Internet), DRUPAL, Joomla, and the most popular E-Commerce Magento 2. Also, there are very popular PHP-based MVC Frameworks Symfony such as Yii2 (very popular in Russia) and Laravel (takes the 1st place in GitHub RANKING).

How PHP works

Let’s elaborate how the Hypertext Preprocessor works. The browser sends an HTTP request to a web server. Then the index.php file is generated, which is handled by the preprocessor. Finally, the web server receives the output and sends it back over the Internet to a user’s web browser.

Why use PHP

PHP is incredibly easy for beginners and provides multiple advanced features for professional programmers. With it, you can learn and start writing basic scripts in a short period. Here is the list of the best features:

Versatility

PHP is a server-side programming language. Therefore, you need to set up a server to work with it. This language is also platform-independent. You don’t need a specific operating system to use it because it works on any platform, whether it’s macOS, Windows, Linux. For that reason, this is why it may be deployed on various systems and platforms easily and inexpensively.  

Secure and swift

PHP used to be scolded for its ability to attack the site with SQL injection, but with the release of MVC frameworks, this is now impossible. The major advantage is that due to the wide distribution and support of the community, there are now multiple tools, frameworks, and security and cyberattack protection solutions available. The second equally major feature is speed, try to use versions 8 and up, as these versions introduced the JIT Compilation, which speeds up PHP.

Well-linked with databases

PHP provides an easy way to establish a reliable connection to almost any database. So it can instantly connect to MySQL, PostgreSQL, MongoDB, or any other database.

Testing

Among programming languages, PHP has a reputation for being stable and reliable. Its code has been tested under a wide variety of real-world and experimental conditions. If there’s a possible error or shortcoming, chances are someone in the community has found a way to deal with it. There are numerous frameworks and toolkits which are helpful for secure, efficiency and effectiveness of web development.

Community

PHP has a very responsive online community. The official documentation contains feature guides, chats and forums, so you can quickly solve your problem if you get stuck.

Low-cost open-source software

PHP is a no-cost language that can significantly help you save on your development expenses. A lot of the development tools normally used with this language are open-source and available for free, so they keep the cost of the project down even more. Numerous frameworks offer Hypertext functionalities and make the development process easier and much better, for example, the most popular and widely used is Laravel.

Conclusion

Rasmus Lerdorf is a Danish-Canadian programmer who released the first version of PHP in 1994. It continues to be a widely used and actual language in web development. It has been available for quite a long time. Major companies like Slack, Meta (Facebook), HPVM, and Wikipedia use the language extensively. Web Hosting Platforms like BlueHost, Site ground run their hosting servers using Hypertext Preprocessor.

On the Flatlogic Platform, you can also use PHP when choosing the Laravel backend framework for creating your application. Afterward, you will get in a few minutes the Laravel CRUD admin panel with DataBase models and API.

The post What is PHP? appeared first on Flatlogic Blog.

Flatlogic Admin Templates banner

Auto Save Example In PHP & MYSQL.

Posted on by Mark Feehily0
Auto Save Example In PHP & MYSQL.

In this post we’re going to learn how to save data automatically in database on specific time interval using Ajax Jquery with PHP and Mysql. This type of functionality you have seen into WordPress Admin side, any modern editor . However, also at Admin side when we’ve produce new post also after a specific interval of time it’ll save as draft our post or page automatically in Database, If you have used WordPress CMS. So our data will safe if we’re forget to publish our content and we come after some time also our content will be placed in Database as draft. So, Tthis type of functionality we’re going to learn into this post. In this post We’ll describe you a simple post illustration. We’ve simple form for posting simple composition with title and description.

When user enter title and description then after some time interval post automatically save into database table. This effects happens only after user enter post title and description. In this tutorial if post enter for first time also it fit into database table but if post formerly fitted also it’ll modernize that post data on regular time interval.

Step 1

Step 2

Step 3

Step 4

Create Below Table.

CREATE TABLE `posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Create config.php file and add below line of code.

$host = “localhost”; /* Host name */
$user = “root”; /* User */
$password = “”; /* Password */
$dbname = “auto_save_demo”; /* Database name */

$con = mysqli_connect($host, $user, $password,$dbname);
// Check connection
if (!$con) {
die(“Connection failed: ” . mysqli_connect_error());

Create index.php file and add below line of code.

<html lang=”en”>
<head>
<title>Auto Save Example In PHP</title>
<link rel=”stylesheet” href=”https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css”>
<!– <script src=”https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js”></script>
<link rel=”stylesheet” href=”https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css”> –>
<script src=”https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js”></script>
<script src=”https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js”></script>
</head>
<body>
<h3 class=”text-success” align=”center”>Auto Save Example In PHP</h3><br>
<div class=”container”>
<div class=”panel-group”>
<div class=”panel panel-primary”>
<div class=”panel-heading”>Auto Save Example In PHP</div>
<form class=”form-horizontal” method=”post”>
<div class=”panel-body”>
<div class=”form-group”>
<label class=”control-label col-sm-2″ for=”title”>Post Title:</label>
<div class=”col-sm-5″>
<input type=”text” class=”form-control” id=”title” name=”title” required>
</div>
</div>
<div class=”form-group”>
<label class=”control-label col-sm-2″ for=”description”>Description:</label>
<div class=”col-sm-5″>
<textarea class=”form-control” id=”description” cols=”5″ rows=”5″ name=”description”></textarea>
</div>
</div>
<input type=’hidden’ id=’postid’ value=” >

<input type=’button’ id=’submit’ class=”next btn btn-success” style=’margin-left:30%’ value=’Submit’>
</div>
</form>
</div>
</div>
</div>
</body>
<head>
<script>
setInterval(saveData, 5000);
function saveData(){

var postid = $(‘#postid’).val();
var title = $(‘#title’).val().trim();
var content = $(‘#description’).val().trim();

if(title != ” || content != ”){

$.ajax({
url: ‘autosave.php’,
type: ‘post’,
data: {postid:postid,title:title,content:content},
success: function(response){
$(‘#postid’).val(response);
}
});
}

}

</script>
</head>
</html>

Create autosave.php file and add below line of code.

<?php
include “config.php”;
if(isset($_POST[“title”]) && isset($_POST[“content”]))
{
$post_id = mysqli_real_escape_string($con, $_POST[“postid”]);
$post_title = mysqli_real_escape_string($con, $_POST[“title”]);
$post_description = mysqli_real_escape_string($con, $_POST[“content”]);

if($post_id != ”)
{
//update post
$sql = “UPDATE posts SET title = ‘”.$post_title.”‘, description = ‘”.$post_description.”‘ WHERE id = ‘”.$_POST[“postid”].”‘”;
mysqli_query($con, $sql);
}
else
{
//insert post
$sql = “INSERT INTO posts(title,description) VALUES (‘”.$post_title.”‘, ‘”.$post_description.”‘)”;
mysqli_query($con, $sql);
$last_insert_id = mysqli_insert_id($con);
echo $last_insert_id;exit;
}
}

Upload Image In Angular With PHP                   Upload File In VueJs With PHP.

The post Auto Save Example In PHP & MYSQL. appeared first on PHPFOREVER.

Flatlogic Admin Templates banner