• Register

Recent posts tagged mysql-database

19 2 2 min.
Here we study about the difference between primary key and foreign key in SQL.Primary Key:A primary key is used to ensure data in the specific column is unique.It uniquely identifies a record in the relational database table.Only one primary key...
posted Jun 11 Jeevani 278 points
8 0 2 min.
There might be a circumstance when you need a precise of a table and CREATE TABLE ... SELECT doesn't exactly measure up for your motivations on the grounds that the duplicate should incorporate the equivalent records, default esteems, etc. Y...
posted May 24 amna 112,545 points
0 1 2 min.
DefinitionSQL injection is a web hacking technique that allows a hacker to manipulate the queries that an application makes to its database.In this case whole database of a website will be compromised.All username,passwords,other user&...
posted May 1 sanchi 100 points
0 0 2 min.
Today,we will discuss how to create new user name and password .Moreover, we will also talk about the permissions which we give to user to complete their task.Before dicussing this, we should know some basic points about MYSQL which are:All commands ...
posted Apr 30 sanchi 100 points
0 0 2 min.
Today we know about functions in SQL. SQL is the language of the database. We have also read functions in programming. Any programming language such as Java.  C++,C#.. In the end, we give you some results. In SQL Server, the function is used on ...
posted Feb 5 Tania 632 points
0 0 2 min.
PHP is an open-source programming language; it has built-in functions to communicate with the database and retrieve data. Mysqli_num_rows () function is used to check the number of rows in the query. This function is used after placing a query to che...
posted Oct 26, 2020 abdullah_yasir 7,510 points
0 0 2 min.
MySQL and MySQLi are types of database extensions use for php.Php is used to develop web-based applications and websites. MySQL and MySQLi are used to communicate or to make an interface with MySQL database and to perform some actions.Comparison of M...
posted Oct 24, 2020 abdullah_yasir 7,510 points
0 0 1 min.
Solution:To Sove this problem you have to follow below steps:Applying prepared statements and parameterized queries:These are SQL statements that are transmitted to and parsed by the database server aloof from any parameters. in case you follow this ...
posted Jun 28, 2020 Tushar Shuvro 31,696 points
15 0 1 min.
Solution:STEP 1: Using a comma seprated store it to an array and save the filesCode:<label for="aoi">Area of Interest:</label> <select id="sel_aoi" name="aoi[]" multiple="multiple"> <option value="hr-executi...
posted May 19, 2020 Tushar Shuvro 31,696 points
0 0 2 min.
Solution:STEP 1: register.phpCode:<?php include('process.php') ?> <html> <head> <title>Register</title> <link rel="stylesheet" href="style.css"> </head> <body> <form method="post" action="regis...
posted May 19, 2020 Tushar Shuvro 31,696 points
0 0 2 min.
Solution:STEP 1: MySQL Object OrientedCode:<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "myDB"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection...
posted May 16, 2020 Tushar Shuvro 31,696 points
0 0 2 min.
Solution: This method has the efficiency to fill data in a drop-down list from the MySQL database.STEP 1: First of all, create a landing page and name it “index.php”. Then insert the following code in the page you have built. Code:&l...
posted Apr 28, 2020 Tushar Shuvro 31,696 points
To see more, click for the full list of questions or popular tags.