Educational and Technical contents for everyone who have interest in tech field.
Best tool for web developer (insert whole data in single click in database)
INSERTING DATA IN DATABASE TABLE BECOMES TOO DIFFICULT WHEN WE HAVE LARGE AMOUNT OF DATA . TO KEEP AWAY THIS PROBLEM THERE IS VERY GOOD SOLUTION
GO TO THIS LINKCLICK HERE TO VISIT
GO TO THIS WEBSITE SIMPLY IMPORT WHOLE EXCEL DATA SHEET AND COPY ALL THE QUERIES AND PASTE IT TO CMD MYSQL CONSOLE OR DIRECT PHP MYADMIN QUERY BOX YOU TABLE WILL BE CREATED SIMPLY RENAME IT ACCORDING TO YOUR NEED.
SQL: A Realtional Database Language
Sql is the query langugae used with relational databases.Sql is not a DBMS itselflkbut ut us a medum of communication with DBMS.SQL is muvh easiet to understand and lwatn as compared to other language.SQL was initially called SEQUEL was later names as SQL during 1970's. Sql is a set based , declarative set based declarative query language and not imperative language such as c or BASIC. Declarative means that user only need to state" what " needs to be done and not how to be done.DBMS determines tand performs internally the steps needed to accomplis the job. It is also known to be non-procedural language.
Features of Sql
⦁ sql statements are not case senstive(but data is case sensitive)
⦁ sql can be written one or more lines
⦁ clauses are usually placed on separate lines
⦁ Keywords cannot be split across lines
⦁ Tabs and spaces are allowed to enhance readability
⦁ Each SQL statement (not line) wnds with a semicolon(;)
⦁ sql is declarative and non-procedural language.
⦁ Sql statement start with verbs(actions) .Example create command.
⦁ Identifier always start with alphabet ⦁ single line comment are prefixed by - symbol and multiline comments are enclosed between /* and */
MOST USED PHP FUNCTIONS FOR DEVELOPEMENT
USING STRTOTIME() AND DATE() FUNCTION IN PHP
FETCHING DATE YEAR AND TIME SEPARATELY FROM USER INPUT
- WE HAVE STORED DATE IN A VARIABLE NAME $date FROM INPUT BY POST METHOD
- IN SECOND LINE $time IS USED TO STORED CONVERTED DATA WHICH IS CONVERTED INTO STRING BY USING strtotime() FUNCTION THIS FUNCTION CONVERTS DAY, MONTH, YEAR IN TO STRING AND THEN FROM STRING WE CAN FETCH DAY MONTH AND YEAR SEPARATELY
- HERE AN ANOTHER FUNCTION IS USED WHICH IS DATE("SPECIFIER","VARIABLE") IT EXTRACT DATE MONTHS AND YEAR SEPARATELY
- THEN WE STORE MONTH AND YEAR BY USING DATA FUNCTION , HERE 'M' 'Y' DENOTES SHORT FORM OF MONTHS AND YEAR
- STORE THE DATA IN VARIABLE AND THEN PERFORM THE DESIRED OPERATIONS
WHAT IS CLOUD COMPUTING
Cloud computing is a web based service where we are interact with internet to get online data.
now days servers online storage, hosting, google photos all the things are part of cloud computing .
cloud computing is a type of medium by which we can get our data online by which other people get information about our
product.
In simple words now days we are hearing about servers because servers provide us online facility about connectivity with other
and with our data also so cloud computing is an interaction with internet, it may be your online storage like google photos or Gdrive.
EXAMPLE: The data inside out smartphone and hard disk it is not accessible online you can access it offline only but do you think how
can you give the data inside your Hard disk and smartphone to a friend who lives so far away, To solve this problem you will go for
online storage , first you will upload your file then you friend can access the file by your given link. So this is possible because
you have a centralized storage with online feature which can be accessed by any one so this is possible because of cloud computing.
list of css properties
STEPS TO REMOVE OLD WINDOWS FILES
CSS PROPERTIES LIST TO USE AND LEARN
CREATING BEAUTIFUL WEBSITE USING HTML AND CSS
web page out put screen of given below source code, This is output screen. |
<!DOCTYPE html>