Skip to main content

Creating Database(SQL)


Create a database if it does not exist!

SQL























-Stands for  Structured Query Language

Used to manage database //Update data on a database or retrieve data from a database


Start by creating your connection
$servername="localhost"
$username="root"
$password=""
Connect to MySQL
$link = mysql_connect($servername, $username, $password);
if (!link)
{
die('Could not connect ' . mysql_error());
}
Suppose we're creating a database with name 'test'. You must first of all make that db your current db.
$db_selected = mysql_select_db('test', $link);
You can now create your database with an appropriate name!
if (!db_selected)
{
$sql = 'CREATE DATABASE test';
if (mysql_query($sql, $link))
{
echo "Database test has been successfully made!";
require table.php;
}
else
{
echo "Error creating database: " . mysql_error() . "\n";
}
}
mysql_close($link);
?> 

Note: You might be wondering why am I calling a table.php when the db is successfully created.
Well, this is not mandatory. I called the table.php because it will create a database table with given name.

Creating the database table

Suppose we are creating a database table with name test-table in our database.

This time while connecting to MySQL, you should insert your $dbname!
$conn = new mysqli($servername, $username, $password, $dbname); 

After connecting to MySQL, you can start creating your database table.
$sql = "CREATE TABLE test.test-table"
(
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
)";
We've created our table name with:
1. id //declared as Integer and it will auto increment as well with length 6
2. firstname //declared as Varchar and length 30
3. lastname //decared asVarchar with length 30
4. email // declared as Varchar with length 50

Check if table has been created successfully!
if ($conn->query($sql) === TRUE)
{
echo "Table test_table created successfully";
}
else
{
echo "Error creating table: " . $conn->error;
}
?>
Get in on github



Popular posts from this blog

How to install the FReMP Stack on Ubuntu 20.04?

Technology keeps on evolving everyday and developers constantly look for more and more things to get their hands-on. In this article, I will be introducing a new full stack framework, called FReMP . The abbreviation used is not the best one, but it just gets the work done in justifiable ways. What on earth is FReMP stack? The FReMP stack is a highly scalable full stack framework, which can be used to build awesome web apps. The acronym stands for F lask, Re actJS, M ongodb and P ython. Unlike other famous stacks such as MEAN and MERN, the FReMP stack uses Python to handle back-end operations. Examples of such operations can be machine learning and artificial intelligence operations, web scraping tools or digital image processing. Step 0: Update your list of installed packages While this is optional, it is always a good practice to update your list of packages and upgrade them for newer versions before starting any installation on your environment. Run the following to do so: $ apt-get

How to disable SSLv3 in ubuntu?

Why disable SSL 3.0? SSLv3 is not sufficiently secure. The replacement versions, in particular, Transport Layer Security(TLS) 1.2, are way more secure and capable protocols.  Poodle attack and End of SSLv3  In late September, a team at Google discovered a serious vulnerability(POODLE) in SSLv3 that can be exploited to steal confidential information, e.g things like cookies and passwords, enabling the latter to access a user's private account on a social website. You can learn more about SSL on our Android app SSLearn. Steps: Firstly, let's start with an Update: After the update, install apache: Note: If you already have apache installed, you may skip this step. After installing apache, type the following command to configure and disable SSLv3: Then simply press the arrow down on your keyboard and search for SSLprotocol. Add '-SSLv2 -SSLv3' at the end. Then 3 lines upwards, you should be able to see #SSLHonorCipher

[Drupal]Drupal 8 Sandbox

Installation of Drupal 8 Sandbox Why Use the Sandbox version? If you want to give drupal a try, but you're unsure of how it'll look like or want to check how it works, the sandbox version is just for you. If you already know how to set up drupal on your lamp server, then you'll have no problem at all to set up the sandbox version. If, somehow, you can't figure it out, then you can just follow the simple steps below and you'll be there. In the steps below, we'll use Sandbox version of Drupal to generate a new issue, and patch it using Git.                    Requirements: Git Steps: Step 1: Clone it Start by opening your terminal and clone the repository by running the following the command: git clone --branch 8.x https://git.drupal.org/sandbox/bhirsch/1388780.git drupal-sandbox This command will clone drupal 8 sandbox and the all the files will be in a folder 'drupal-sandbox'. You can change the name of the f