By on

 ADDING FILES TO YOUR GITHUB ACCOUNT & Inspect Element & Export SQL file from XAMPP


sign into your github account


create a new repository

give it a name of your choice

click create repository


ensure you are in the project folder directory

for quick access; copy the folder on the desktop


open git bash terminal

cd desktop

cd folder-name (cd whitepace-academy)


HANDLE few git commands

type:: git init (a git folder is created in your project folder)

type:: git add . (add the period sign)

type:: git config --global user.email "ajalabamise@gmail.com"

type:: git config --global user.name "ajalabamise"

type:: git commit -m "initial commit"  (it shows all your folder files)


CONNECT your local github folder in your github repository

copy and paste the code below from your github repo into your git terminal and press enter key

git remote add origin https://github.com/ajalabamise/my-web-dev-tutorial.git


UPLOAD the files to github repo

git push -u origin master


BROWSER verification

a browser login dialog box pops up, asking you to log into your github account,

sign in and click accept


REFRESH your github repo

All your files are inside your folder


Steps to use inspect element

right click the browser, select inspect

image



HOW to export sql file from XAMPP

METHOD 1 (using GUI)

type localhost/phpmyadmin in the web browser

click the desired database to be exported

click the EXPORT tab

check your download folder


METHOD 2 (using shell - command prompt)

1. launch xampp control panel

2. start apache and mysql

3. click the shell button in xampp control panel

4. create a folder in the local disk (i called mine dump)

5. follow the Syntax or format below ()

mysqldump --databases --user=root --password databaseName > export_into_db.sql

password is empty, it is set to nothing

6. press the enter key, if it ask you for password, press the enter key if you don't set password for XAMPP...if you have password, type it and press enter key

7. check your dump folder to set the exported sql file

example (real sample format to type into the shell)

mysqldump --databases --user=root --password cart_db > C:\dump\cart_db.sql


SNAPSHOT



TO create default username and password for admin

1. create a table users

2. id (int) ai, user_name (varchar 255), password, name

3. click save

4. click the table, click insert

5. since id is auto increment, don't type anything inside it, fill information for user_name, password and name. for example: admin, password, Bamise

Comments

Post a Comment

Popular posts from this blog

Basic Web Page - phase 1

By on
Objective: -learn how to set up browser and editor for coding (to view window on both sides, let first window be active, hold down window key + right or left arrow) -learn the basic structure of html -learn structure of project files -learn tags like h1-h6, p, a, img, ul, ol, hr, br -learn css selectors class (dot), id (hash symbol) NB: At least, one of your project files must have index.html -to go on multiple pages, create the file name for index.html, services.html, about.html, contact.html -paste the same code of index.html into other files, then edit the content you want it to have Basic structure of HTML < !DOCTYPE  html > < html > < head > < title > Page Title < /title > < /head > < body > < h1 > My First Heading < /h1 > < p > My first paragraph. < /p > < /body > < /html >  <html>     <head> <title> Intro to Web Design</title> <!--<link rel="stylesheet" ...
Read more
By on
Image
   DATA STRUCTURE WITH C++ PROGRAMMING USING STACK PREREQUISITES TO IMPLEMENTING STACK IN C++ We will need to understand how to use some of the constructs in C++ that makes up the implementation of stack in C++ against. And this concepts will also help you in developing other codes and to debug or understand the C++ codes in a company's code bank or to interpret a boiler plate code (a ready made code). Some of these constructs or concepts are: 1. sizeof() 2. Function 3. Pointer 4. Function Pointer 5. Arrow operator 6. malloc() 7. typedef 8. struct PHASE 1: sizeof() It is used to determine the size of variables used in a program, it can determine the size of primitive (or predefined) datatype too and for any user-defined datatypes. It is an inbuilt keyword and a compile-time operator. syntax-1 using variable sizeof(variableName); syntax-2 using primitive datatype sizeof(datatype); //code implementation #include<iostream> using namespace std; int main(){ //declare v...
Read more
By on
Image
 CGPA CALCULATOR & BASIC HTML WEB DEV PROJECT Introduction: In this cgpa calculator, user will enter the gp for each semester, then click on the submit button to see the cgpa user can also click the reset button to begin a new input for calculation In this mini project we will be using HTML CSS JAVASCRIPT to develop a cgpa calculator NB:   With a querySelector statement, you can select an element based on a CSS selector. This means you can select elements by ID, class, or any other type of selector. Using the getElementById method, you can only select an element by its ID. Generally, you should opt for the selector that most clearly gets the job done. PHASE 1a:  PROTOTYPE (final product) PHASE 1b:  PROTOTYPE (rought sketch) Let's sketch with our hand how the cgpa calculator will look like PHASE 2: Html (for structuring the webpage content) Shortcut for div and class for css: type dot followed by the name you want e.g .cgpatitle Shortcut for div and id f...
Read more