MAKE OPTIONS IN FORM WITH ALREADY SELECTED DATA

 CREAT SELECT OPTION, AND ALSO SHOWING PREVIOUSLY SELECTED OPTION BY USER FROM DATABASE.

<td>

 NEWSPAPER NAME

<select id="newspaper_name" name="newspaper_name" class="form-control" required>

    <?php

    $sql = 'select * from newspapers';

    $result = execute_query($sql);

    while ($row = mysqli_fetch_assoc($result)) {    echo '<option value="'.$row['sno'].'" ';

    if(isset($_GET['id'])){

        if($row1['newspaper_name']==$row['sno']){

            echo ' selected="selected" ';

        }

    }

    echo '>' . $row['newspaper_name'] . '</option>';

    }

    ?>

</select>

 </td>

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

if (isset( $_POST[ 'submit' ] ) ) {

    

    $date = $_POST['date_current'];

    $time = strtotime($date);

    $month = date("m",$time);

    $year = date("Y",$time);

    if($month>=1 && $month<=3){

        $year = $year-1;

    }

 

HERE FIRST WE HAVE TO UNDERSTAND THIS IS SIMPLE LOGIC TO RECEIVE SEPARATE DATE , MONTH , YEAR,  AND TIME ALSO.

SUPPOSE WE HAVE TO GET DATA AS MONTH YEAR AND TIME AS SEPARATELY FOR SOME CALCULATION OR TO STORE IN SOME VARIABLES .  IN SIMPLE YOU HAVE TO GET YEAR FROM USER ENTERED INPUT TAG BECAUSE IF YOU SELECT INPUT TYPE AS DATE THEN YOU WILL GET DATA MONTH AND DAY TOGETHER BUT FOR SOME REASON YOU NEED MONTH AND YEAR ONLY TO PERFORM CALCULATION 

 

IN THIS LOGIC WE ARE RECEIVING DATE FROM FORM WHERE WE HAVE CREATED A INPUT TAG OF DATE TYPE FOR USER TO ENTER THE DATE, WHEN THE SUBMIT BUTTON IS PRESSED THEN

• 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  
  

 

HOW GET 4000 WATCH TIME IN YOUTUBE FOR MONETIZATION

TRICK FOR 4000 WATCH TIME ON YOUTUBE

• • first make 20 or more videos and stream atleast 2 hours
    
  • then simply upload it,
  • get any other device like smartphone or laptop or pc which have good internet connection then simply start your stream on other device
  • decrese its speed from setting option
  • then left it for a time 
  • repeate this process for few days and hours you will get enough watch time by this trick
  • but dont apply this trick to complete the whole watch time
  • apply this trick only to complete 60% or some more

  • otherwise there is a risk that youtub will decrease your watch time

 

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.

ccc(course on computer concept syllabus) कोर्स के बारे में पूरी जानकारी

ccc (course on computer concept )  latest syllabus 2021 download by nielit

CCC कोर्स के बारे में पूरी जानकारी |

• CCC COURSE KI FEES

•  CCC KE LIYE APPLY KARE
  

click here to apply for ccc by nielit  👉👉👉👉      apply for ccc  

FEE  FOR CCC

 examination fee for CCC is Rs. 500.00 + GST and for BCC is Rs. 450.00 + GST (as applicable on the date of submission of exam form) 

s. No.	Chapter Name	Course Outline	Duration Hours		Learning Outcomes
			Theo	Lab
1	Chapter-I Introduction to Computer	1.0 Introduction 1.1 Objectives 1.2 Computer and Latest IT gadgets 1.2.1 Evolution of Computers & its applications 1.2.2 IT gadgets and their applications 1.3 Basics of Hardware and Software 1.3.1 Hardware	3	3	After completion of this chapter, the candidate will be able to • identify computers, IT gadgets and explain their evolution and

Duration:

80 Hours - (Theory: 32 hrs + Practical: 48 hrs )

This course can also be offered as 10 days full time intensive course.

Eligibility:

No minimum qualification is required for applying and appearing for the examination in Course on Computer Concepts [CCC].

Job Role :

Computer Operator, Data Entry Operator and Social Media Operator

Detailed Syllabus and Learning Outcome:

 

		1.3.1.1 Central Processing Unit 1.3.1.2 Input devices 1.3.1.3 Output devices 1.3.1.4 Computer Memory & storage 1.3.2 Software 1.3.2.1 Application Software 1.3.2.2 Systems Software 1.3.2.3 Utility Software 1.3.2.4 Open source and Proprietary Software 1.3.2.5 Mobile Apps 1.4 Summary 1.5 Model Questions and Answers				applications. • Get familiar with various input, output and hardware components of a computer along with storage devices. Get familiar with various types of softwares, utilities used for computer and mobile apps.
2	Chapter-2 Introduction to Operating System	2.0 Introduction 2.1 Objectives 2.2 Operating System        2.2.1     Basics of Operating system        2.2.2      Operating Systems for Desktop and Laptop        2.2.3     Operating Systems for Mobile Phone and Tablets 2.3 User Interface for Desktop and Laptop 2.3.1 Task Bar       2.3.2   Icons & shortcuts 2.3.3 Running an Application 2.4 Operating System Simple Setting 2.4.1 Using Mouse and Changing its Properties 2.4.2 Changing System Date and Time 2.4.3 Changing Display Properties 2.4.4 To Add or Remove Program and Features 2.4.5 Adding, Removing & Sharing Printers   2.5   File and Folder Management 2.6 Types of file Extensions 2.7 Summary   2.8   Model Questions and Answers		3	4	After learning this chapter, candidate will be Well acquainted with Operating System and its applications for both desktop and mobile devices. able to identify various desktop screen components and modify various properties, date, time etc. • able to add and remove new program and features, manage files and folders. Well versed with printing and know various types of file extensions.
3.	Chapter-3 WORD PROCESSING	3.0 3.1 3.2 3.3	Introduction Objective Word Processing Basics 3.2.1 Opening Word Processing Package 3.2.2 Title Bar, Menu Bar, Toolbars & Sidebar 3.2.3 Creating a New Document Opening and Closing Documents 3.3.1 Opening Documents 3.3.2 Save and Save As 3.3.3 Closing Document 3.3.4 Using The Help 3.3.5   Page Setup 3.3.6    Print Preview 3.3.7   Printing of Documents 3.3.8      PDF file and Saving a Document as PDF file	4	8	After completion of this chapter, candidate will have        In                 depth Knowledge of Word Processing, their usage, details of word processing screen. Opening, saving and printing a document including pdf files. Document creation, formattin of text,

 

		3.4 3.5 3.6 3.7 3.8 3.9 3.10	Text Creation and manipulation   3.4. I   Document Creation   3.4.2    Editing Text   3.4.3    Text Selection     3.4.4       Cut, Copy and Paste     3.4.5        Font, Color, Style and Size selection   3.4.6    Alignment of Text     3.4.7      Undo & Redo   3.4.8   AutoCorrect, Spelling & Grammar   3.4.9    Find and Replace Formatting the Text 3.5.1 Paragraph Indentation 3.5.2 Bullets and Numbering 3.5.3 Change case 3.5.4 Header & Footer Table Manipulation 3.6.1     Insert & Draw Table 3.6.2     Changing cell width and height 3.6.3     Alignment of Text in cell   3.6.4          Delete / Insertion of Row, Column and Merging & Splitting of Cells 3.6.5   Border and Shading Mail Merge Shortcut Keys Summary Model Questions and Answers			paragraph and whole document. Inserting Header and Footer on the document Finding text on a word document and correcting spellings. • Able to insert and manipulate tables, enhance table using borders and shading features. Can prepare copies of a document labels etc for sending various recipients using Mail Merge.
4.	Chapter-4 SPREAD SHEET	4.0 4.1 4.2 4.3 4.4 4.5 4.6	Introduction Objectives Elements of Spread Sheet 4.2.1 Creating of Spread Sheet 4.2.2 Concept of Cell Address [Row and Column] and selecting a Cell 4.2.3 Entering Data [text, number, date] in Cells 4.2.4 Page Setup 4.2.5 Printing of Sheet 4.2.6 Saving Spreadsheet Opening and Closing Manipulation of Cells & Sheet 4.3.1 Modifying / Editing Cell Content 4.3.2 Formatting Cell (Font, Alignment, Style ) 4.3.3     Cut, Copy, Paste & Paste Special 4.3.4     Changing Cell Height and Width 4.3.5      Inserting and Deleting Rows, Column 4.3.6 AutoFill 4.3.7 Sorting & Filtering 4.3.8 Freezing panes Formulas, Functions and Charts 4.4.1 Using Formulas for Numbers (Addition, Subtraction, Multiplication & Division) 4.4.2 AutoSum 4.4.3 Functions (Sum, Count, MAX, MIN, AVERAGE) 4.4.4 Charts (Bar, Pie, Line) Summary Model Questions and Answers	4	8	After completion of this chapter, candidate will have good handson practice on Basic Knowledge of Spreadsheet Processing,     their usage, details of Spreadsheet screen. Opening, saving and printing a Spreadsheet. Spreadsheet creation, inserting and editing data in cells, sorting and filtering of data. Inserting and deleting rows [columns. Applying basic formulas and functions. Prepare chart to represent     the information in a

 

						pictorial form.
5.	Chapter-5 Presentation	5.0 5.1 5.2 5.3 5.4 5.5 5.6 5.7	Introduction Objectives Creation of Presentation 5.2.1 Creating a Presentation Using a Template 5.2.2 Creating a Blank Presentation 5.2.3 Inserting & Editing Text on Slides 5.2.4 Inserting and Deleting Slides in a Presentation 5.2.5 Saving a Presentation Manipulating Slides 5.3.1 Inserting Table 5.3.2 Adding ClipArt Pictures 5.3.3 Inserting Other Objects 5.3.4 Resizing and Scaling an Object 5.3.5 Creating & using Master Slide Presentation of Slides 5.4.1 Choosing a Set Up for Presentation 5.4.2 Running a Slide Show 5.4.3 Transition and Slide Timings 5.4.4 Automating a Slide Show Providing Aesthetics to Slides & Printing 5.5.1 Enhancing Text Presentation 5.5.2 Working with Color and Line Style 5.5.3 Adding Movie and Sound 5.5.4 Adding Headers, Footers and Notes 5.5.5 Printing Slides and Handouts Summary Model Questions and Answers	4	8	After completion of this chapter, candidate will have good handson practice on Basic Knowledge of PowerPoint presentations. Opening/saving a presentation and printing of slides and handouts. Manipulate slides to enhance the look of the slides as well as  whole presentation by inserting a picture, objects, multimedia formatting etc. Running a slide show with various transitions.
6.	Chapter-6 INTRODUCTI ON TO INTERNET AND WWW	6.0 6.1 6.2 6.3 6.4 Chrome, 6.5	Introduction Obj ectives Basic of Computer Networks 6.2.1 Local Area Network (LAN) 6.2.2 Wide Area Network (WAN) 6.2.3 Network Topology Internet    6.3.1     Concept of Internet & WWW    6.3.2      Applications of Internet 6.3.3 Website Address and URL 6.3.4 Introduction to IP Address    6.3.5     ISP and Role of ISP 6.3.6 Internet Protocol 6.3.7 Modes of Connecting Internet (Hotspot, WiFi, LAN Cable, Broadband, USB Tethering) 6.3.8    Identifying and uses of IP/MAC/IMEI of various devices Popular Web Browsers (Internet Explorer/ Edge, Mozilla Firefox, Opera etc.) Exploring the Internet 6.5.1 Surfing the web 6.5.2 Popular Search Engines 6.5.3 Searching on Internet 6.5.4 Downloading Web Pages 6.5.5 Printin Web Pa es	3	4	After completion of this chapter, candidate will be able to: Gather knowledge of various types of networks   and topologies. Get an overview of Internet, its applications and various browsers available to access the internet. Connect to Internet using various modes       of connections/device s available. Get knowledge of device identification         on local network as well as on Internet for both Desktop

 

		6.6 6.7	Summary Model Questions and Answers			and           Mobile Devices.        Can             search Information on the Internet on various topics. Download and print web pa es.
7.	Chapter-7 E-mail, Social Networking and eGovernance Services	7.0 7.1 7.2 7.3 7.4 7.5 7.6 7.7 7.8 7.9	Introduction Objectives Structure of E-mail Using E-mails 7.3.1 Opening Email account      7.3.2     Mailbox: Inbox and Outbox 7.3.3 Creating and Sending a new E-mail      7.3.4     Replying to an E-mail message 7.3.5 Forwarding an E-mail message 7.3.6 Searching emails 7.3.7 Attaching files with email      7.3.8     Email Signature Social Networking & e-Commerce 7.4.1 Facebook, Twitter, Linkedln, Instagram 7.4.2 Instant Messaging (WhatsApp, Facebook Messenger, Telegram) 7.4.3 Introduction to Blogs 7.4.4 Basics of E-commerce 7.4.5 Netiquettes Overview of e-Governance Services like Railway Reservation, Passport, eHospital [ORS] Accessing e-Governance Services on Mobile Using "UMANG APP" Digital Locker Summary Model Questions and Answers	3	6	After completion of this chapter, candidate will be able to: Create an email account, compose an email, reply an email and send the email along with attachments. Get familiar with Social Networking, Instant Messaging and Blogs. Get familiar with eGovernance Services, Commerce and Mobile Apps.
8.	Chapter-8 DIGITAL FINANCIAL TOOLS AND APPLICATION s	8.0 8.1 8.2 8.3 8.4 8.5 8.6	Introduction Objectives Digital Financial Tools 8.2.1. Understanding OTP [One Time Password]and QR [Quick Response] Code 8.2.2 UPI [Unified Payment Interface] 8.2.3 AEPS [Aadhaar Enabled Payment System] 8.2.4 USSD[Unstructured Supplementary Service Data] 8.2.5 Card [Credit/ Debit] 8.2.6 eWallet 8.2.7 Pos [Point of Sale] Internet Banking 8.3.1 National Electronic Fund Transfer (NEFT) 8.3.2 Real Time Gross Settlement (RTGS) 8.3.3 Immediate Payment Service (IMPS) Online Bill Payment Summary Model Questions and Answers	4	4	After completion of this chapter, candidate will be able to: Know the Digital Financial Tools. Get Knowledge of Internet Banking Modes. • Get familiar with e- Governance Services, eCommerce and Mobile Apps. Use the Digital Locker and will be able to store documents in Digital Locker.
9.	Chapter-9 Overview of Futureskills & Cyber Security	9.0 9.1 9.2 9.3 9.4	Introduction to Futureskills Introduction to 9.1.1 Internet of Things (IOT) 9.1.2 Big Data Analytics 9.1.3 Cloud Computing 9.1.4 Virtual Reality 9.1.5 Artificial Intelligence 9.1.6 Social & Mobile 9.1.7 Blockchain Technology 9.1.8 3D Printing/ Additive Manufacturing 9.1.9 Robotics Process Automation Cyber Security 9.2.1 Need of Cyber Security 9.2.2 Securing PC 9.2.3 Securing Smart Phone Summary Model Questions and Answers	4	3	After completion of this chapter, candidate will be familiar with the :  Latest trends and technologies in upcoming fields in IECT. Will be able to understand need of Cyber Security and will be able to secure their PC and Mobile devices by using basic security features.
Total Hours = 80				32	48