Skip to main content

How to MySQL with EasyPHP

Image
By
PHP and MySQL always go side by side. Now if you are going to build a PHP website that would be saving any kind of that you will need a database to store that data. MySQL is that database which will be saving your data, and to access, modify or save data in this database you need SQL which stands for Structured Query Language.

Now if you are aware of the previous post we are going to use EasyPHP for our work here as well.
Considering you have installed and configured EasyPHP from previous post. Lets get started with MySQL.

1. First of all open the EasyPHP dashboard by right(or left) clicking the EasyPHP tray icon.



2. Now click on Start under Database Server to start a database server.




3. If you find multiple option go with any I went with the first.


And click on start.

4. Once started we need to run queries. To do so we need PHPmyAdmin.
Go to the  EasyPHP dashboard again and there you will find MySQL Administration PHPmyAdmin as shown.



5. Upon opening you will find the PhpMyAdmin dashboard. To execute your SQL commands you have to open console which is at the bottom of the Window as shown.


6. Let's execute our first query to see what all databases are already there.

mysql> SHOW DATABASES



Upon doing that I got the list of databases I already have. Out of these "mynotes" is the database I have made previously.

That's it. Now you are good to go. Create your own database, tables and enter data into that.

Let's do some queries now.


Since all of the data is always placed in a database, we need to first create a database.
To do that query mysql

mysql> CREATE DATABASE mydb;

Here mydb is just a name and you can use any name of your choice as you like.
Now the information in a database is stored in the tables. We need to create a table for that.
But before we create a table we need to specify in MySQL that we want a table to be created in the database we just created. In order to do that we query

mysql> USE mydb;

Following SQL query will create a table.

mysql> CREATE TABLE myTable (
                          columnOne INT NOT NULL PRIMARY KEY,
                          columnTwo TEXT,
                          columnThree DATE
                          );

This will create a table with three columns with the names columnOne, columnTwo and columnThree respectively.

You can use the query

mysql> DESCRIBE myTable;


to see how your table looks like.

Now there are two ways of inserting data into these tables.

1. 
mysql> INSERT INTO mytable SET 
columnTwo = "Any textual message here!",
columnThree = "2016-12-8"


2.
mysql> INSERT INTO mytable (columnTwo, columnThree) 
VALUES("Like I said any thing textual!", "2016-11-7")


You must have already noticed that I did not enter anything for columnOne, infact I did not even mentioned it in my queries. It is because I made that column NOT NULL and set it to AUTO_INCREMENT when I defined the table. 

Now to check out our table content we query

mysql> SELECT * FROM myTable

That's all. Your table is up and running your database.
If you are confused as to use the semi-colon or not, it does not matter. 
Labels:

Comments

Post a Comment

Popular posts from this blog

Unity Mobile Game Optimization Checklist

By
- On Image and Text components that aren’t interacted with you can uncheck “Raycast Target” on it, as it will remove them from any Raycast calculus. - Click on your textures in your “Project” window. Click on the “Advanced” arrow, and now check “Generate Mip Maps”, Unity especially recommends it for faster texture loading time and a lower rendering time. - Set the “Shadow Cascades” to “No Cascades” (Quality settings) - If you have dynamic UI elements like a Scroll Rect with a lot of elements to visualize, a good practice is to turn off the pixel perfect check box on the canvas that contains the list and disable the items that aren’t visible on the screen. - Set all non moving objects to "Static" - Above Unity3d 2017.2 you should turn off "autoSyncTransforms" on the Physics tab - Always use Crunch Compression Low on textures - Try to keep the “Collision Detection Mode” on “Discrete” if possible, as “Dynamic” demands more performance. - You can go to the TimeManager w...
Post a Comment
Read more

How to make RPC in Unreal Engine Steam Online Subsystem and EOS

By
Remote Procedure Calls, also known as RPCs, are a way to call something on any other instance.  In the Unreal Engine, RPCs are used to ship events from the patron to the server, the server to the customer, or from the server to a specific group. It's important to word that RPCs cannot have a return cost. If you want to return something, you'll ought to use a seconds RPC within the contrary path. There are precise policies that RPCs observe, which are unique in the official Documentation. Some of these regulations encompass wherein the RPC must be run, such as the server instance of an Actor, on the owner of the Actor, or on all instances of the Actor. There are some necessities for RPCs. First, they must be referred to as on Actors or replicated Subobjects. The Actor (and component) have to additionally be replicated. If the server is looking an RPC to be executed on a customer, handiest the patron who owns that Actor will execute the function. Similarly, if a client is calling...
Post a Comment
Read more

How to drag and drop item in Unity3D

By
  For dragging and dropping to work we will need to first grab the Game Object and ensure while the Game Object remains grabbed it's position reciprocates the mouse position. This will work fine for not only PC bug mobile devices as well. First define GameObject which we will be dragging. public GameObject selectedPiece; Now inside Update method we will give reference to touched/clicked object and while there is a reference available to an game object(selectedPiece;) we will move that object to mouse position. When the reference is remove, object won't move therefore dropped. void Update(){ RaycastHit2D hit = Physics2D.Raycast(Camera.main.ScreenToWorldPoint(Input.mousePosition), Vector2.zero); if (Input.GetMouseButtonDown(0)){ if(hit.transform != null)             {                 if (hit.transform.CompareTag("PIECE"))                 {     ...
Post a Comment
Read more