InsertUpdateDeleteQueries/Data management system.ppt

Ppt for coding course and programming subjects in connection with data manipulation such as delete, modify, insert, update, and review. This also discussed about the use of database in managing information system of a particular group of data.

1. 1
Insert, Update and Delete
Queries

2. 2
Return to you Address Book database.
Insert a record.

3. 3
Recall that this action provides the SQL, better yet
it will provided the PHP that writes the SQL.

4. 4
Copy the code and put it somewhere
for safe keeping

5. 5
Saved PHP-SQL code in Notepad

6. 6
Mark a record and click the pencil icon to
update that record.

7. 7
Change some fields and click Go.

8. 8
Rats. I didn’t see any SQL Update
query to copy.

9. 9
Mark a record and click on the Delete
button

10. 10
Copy the SQL for the DELETE, then decide
whether you want to delete this record or not.

11. 11
Saved DELETE query

12. 12
Start two PHP files, place a form and a table with one row
and two columns on the first page.

13. 13
Add a list/menu and a submit button in column 1
and a radio group in column 2.

14. 14
Corresponding code.

15. 15
Add PHP code for putting names into
list/menu.

16. 16
Result so far.

17. 17
Add a second form and second table with 1
row (to start) and 3 columns

18. 18
Corresponding code

19. 19
After the row (</tr>) but before end of table (</table>), start
PHP code block. Make array of database filed names.

20. 20
Write a foreach loop that iterates over the FieldArray
making a table row corresponding to each

21. 21
Result so far.

22. 22
Add SQL query before foreach loop,
edit middle column code.

23. 23
Result so far

24. 24
Add non-breaking space (&nbsp;) to middle
column

25. 25
After non-breaking space was added to
middle column

26. 26
Add if so no Old data is showing for
“Insert” choice

27. 27
Problem
•The radio buttons do not hold onto the
information about what choice was clicked
before.

28. 28
The top form’s action is the same page, so it can refer to its
own $_POST array. I add some php script in the radio button
tags to check the appropriate radio button.

29. 29
Add if structure that “remembers” which
item from the list was selected
The extra word selectedin the option tag will
indicate which of the option should be showing.

30. 30
Added some code so that textboxes are read only
and gray when Delete is the chosen action

31. 31
Remembers selected person, remembers
selected action, grays out textboxes when
delete is selected action.

32. 32
Add submit button to bottom form.

33. 33
Show old data in textbox (as starting
point) when Update is selected action.

34. 34
Result showing old data in textbox (as
starting point) when Update is selected.

35. 35
Insert Hidden Fields (to hold info from top form on bottom
form so it can be passed to handler of bottom form)

36. 36
Result of hidden fields added

37. 37
PHP code to get values from top form
onto bottom form

38. 38
Handler code to determine action requested
on calling page

39. 39