PHP CRUD OPERATION (CREATE,READ,UPDATE,DELETE) USING MYSQLI OBJECT ABOUT THE GOLDEN TEMPLE - CHAPTER 1 HISTORY OF AMRITSAR CITY

 PHP CRUD OPERATION (CREATE,READ,UPDATE,DELETE) USING MYSQLI OBJECT ABOUT THE GOLDEN TEMPLE - CHAPTER 1 HISTORY OF AMRITSAR CITY

STEP 1 : First I have created the table `Golden temple` by using four fields `user_id`, `chapter_no`, `chapter_name` and `image` and clicked on Save.


STEP 2 : First I have created a contents login page where once I provide the Chapter No. and Chapter Name and click on Login it will show me the popup login successfully and my display page will appear.





STEP 3 : Once I click on New Contents link in my login page then it will redirect me to `New Contents Form` i.e. to the form page to enter a new content i.e. new chapter and once I enter a new content i.e. new chapter it will prompt me "Data Inserted".




STEP 4 : Once the display page appears after login I will be able to see three buttons in `Action` first one is `Description`, second one is `Edit` and third one is `Delete`.


STEP 5: Once I click on the first button `Description`, I will be able to see the full history of chapter no 1 `History Of Amritsar City`.





STEP 6: Once I click on the second button `Edit`, it will redirect me to `Contents Update Form` where I can make changes in any field like Chapter No. or Chapter Name or Image, but here I have make changes on Chapter Name and click on Update. Once I click on Update, it will prompt me as `Data Updated` and after that once I go back to Display Page I will be able to see the Updated Display Page.





STEP 7: Once I click on the third button `Delete`, it will prompt me `Data Deleted...` and once I click on OK the data will be deleted and if I go back the data will not be deleted and it will reflect in my display page.





STEP 8: Once I click on Logout option in display page it will prompt me `Logout Successfully...` and once I click on OK it will redirect me to login page for further login.



























  
























Comments

Post a Comment

Popular posts from this blog

Programmings Based On Array And String Functions To Merge The 2 Arrays, Then After Merge Convert Into String And Then Find Out The 1st And Last Word From The Reverse String

Image
  Programmings Based On Array And String Functions To Merge The 2 Arrays, Then After Merge Convert Into String And Then Find Out The 1st And Last Word From The Reverse String Q1. Take 2 arrays then margin the arrays. After margin convert into string then reverse the string and find out 1st and last word from the reverse string. Ans: Coding => <?php $arr1 =[ "Dhoni" , "Rohit" , "Kohli" , "Rahul" ]; $arr2 =[ "Bumrah" , "Shami" , "Siraj" , "Chahal" ]; $arrmer = array_merge ( $arr1 , $arr2 ); print_r ( $arrmer ); echo "<br>" ; $str = implode ( " " , $arrmer ); print_r ( $str ); echo "<br>" ; $strrev = strrev ( $str ); print_r ( $strrev ); echo "<br>" ; $arr = explode ( " " , $strrev ); print_r ( $arr ); echo "<br>" ; $firstword = array_shift ( $arr ); $lastword = array_pop ( $arr ); print_r ( $firstword ); echo "...
Read more

PHP WEB DEVELOPMENT INTERVIEW QUESTIONS ASKED IN APOLLO HOSPITAL ALONG WITH MY OWN CONCEPTS AND MY OWN EXPLANATION ANSWERS(PART - 1) REST OF THE QUESTIONS AND ANSWERS WILL BE PREPARED BY ME IN MY NEXT BLOG

Image
 PHP WEB DEVELOPMENT INTERVIEW QUESTIONS ASKED IN APOLLO HOSPITAL  ALONG WITH MY OWN CONCEPTS AND MY OWN EXPLANATION ANSWERS (PART - 1) REST OF THE QUESTIONS AND ANSWERS WILL BE PREPARED BY ME IN MY NEXT BLOG  So, guy's today I am going to explore about some of the PHP Web development Questions used to be asked in Apollo Hospital, and the answers will be genuine with my own making explanations with the concepts which I have. So guy's you must be thinking that Apllo Hospital also work for IT Field? That's why I must say yes. Apollo hospital also work for IT Field. You must be curious about knowing that in which field Apollo Hospital work in IT Field? Don't worry, I am going to let you know that in which portion Apollo Hospital work in IT Field? Apollo Hospital work in IT field like ASKAPOLLO ONLINE i.e. the ONLINE APPOINTMENT SYSTEM which has features like online scheduling of the patient, books health appointment in minutes, 24/7 online appointment scheduling as well as...
Read more

Mini Project On Multi User CRUD Operations(Create, Read, Update & Delete) Of Donar Details Of Indian Nationals Who Donate To Ramkrishna Math, Belur Math Using PDO (PHP Data Objects) With Proper Explanation Of Each And Every Individual Line Of The Code Of connection.php Page, form.php Page, formaction.php Page, admin_display.php Page, client_display.php Page, edit.php Page, editaction.php Page And delet.php Page (Here You Will Find The Image Of Sayang Sri Ramkrishna Dev, Sayang Sri Ma Sarada Devi & Sayang Sri Swami Vivekananda) In My CRUD Operation

Image
Mini Project On Multi User CRUD Operations(Create, Read, Update & Delete) Of Donar Details Of Indian Nationals Who Donate To Ramkrishna Math, Belur Math Using PDO (PHP Data Objects) With Proper Explanation Of Each And Every Individual Line Of The Code Of connection.php Page, form.php Page, formaction.php Page, admin_display.php Page, client_display.php Page, edit.php Page, editaction.php Page And delete.php Page (Here You Will Find The Image Of Sayang Sri Ramkrishna Dev, Sayang Sri Ma Sarada Devi & Sayang Sri Swami Vivekananda) In My CRUD Operation  So,firstly I am going to explain about the connection page (connection.php).Let's begin. In connection.php page first I have taken ($servername="localhost";) where $servername is the name of the server with which we are actually wanting to connect. Now coming to ($username="root";) where $username is the name of the user which and I already know that server has definitely a user, and that user exists in which...
Read more