/web/generatedCode/simple-example/opencms/CMS_HISTORY_RESOURCES/deleteCMS_HISTORY_RESOURCES.php

https://github.com/juddy/GIP · PHP · 91 lines · 86 code · 4 blank · 1 comment · 0 complexity · a7a1cf318b8240e766700b521fe7cb2f MD5 · raw file 

    

  1. <?php
    2. 

  2. include_once("../common/dbConnection.php");
    3. 

  3. include_once("../common/header.php");
    4. 

  4. ?>
    5. 

  5. <?php
    6. 

  6. 	// Retreiving Form Elements from Form
    7. 

  7. 	$thisRESOURCE_ID = addslashes($_REQUEST['thisRESOURCE_IDField']);
    8. 

  8. 	$thisRESOURCE_TYPE = addslashes($_REQUEST['thisRESOURCE_TYPEField']);
    9. 

  9. 	$thisRESOURCE_FLAGS = addslashes($_REQUEST['thisRESOURCE_FLAGSField']);
    10. 

  10. 	$thisRESOURCE_STATE = addslashes($_REQUEST['thisRESOURCE_STATEField']);
    11. 

  11. 	$thisRESOURCE_SIZE = addslashes($_REQUEST['thisRESOURCE_SIZEField']);
    12. 

  12. 	$thisDATE_CONTENT = addslashes($_REQUEST['thisDATE_CONTENTField']);
    13. 

  13. 	$thisSIBLING_COUNT = addslashes($_REQUEST['thisSIBLING_COUNTField']);
    14. 

  14. 	$thisDATE_CREATED = addslashes($_REQUEST['thisDATE_CREATEDField']);
    15. 

  15. 	$thisDATE_LASTMODIFIED = addslashes($_REQUEST['thisDATE_LASTMODIFIEDField']);
    16. 

  16. 	$thisUSER_CREATED = addslashes($_REQUEST['thisUSER_CREATEDField']);
    17. 

  17. 	$thisUSER_LASTMODIFIED = addslashes($_REQUEST['thisUSER_LASTMODIFIEDField']);
    18. 

  18. 	$thisPROJECT_LASTMODIFIED = addslashes($_REQUEST['thisPROJECT_LASTMODIFIEDField']);
    19. 

  19. 	$thisPUBLISH_TAG = addslashes($_REQUEST['thisPUBLISH_TAGField']);
    20. 

  20. 	$thisRESOURCE_VERSION = addslashes($_REQUEST['thisRESOURCE_VERSIONField']);
    21. 

  21. 

  22. ?>
    23. 

  23. <?
    24. 

  24. $sql = "DELETE FROM CMS_HISTORY_RESOURCES WHERE RESOURCE_ID = '$thisRESOURCE_ID'";
    25. 

  25. $result = MYSQL_QUERY($sql);
    26. 

  26. 

  27. ?>
    28. 

  28. Record  has been deleted from database. Here is the deleted record :-<br><br>
    29. 

  29. 

  30. <table>
    31. 

  31. <tr height="30">
    32. 

  32. 	<td align="right"><b>RESOURCE_ID : </b></td>
    33. 

  33. 	<td><? echo $thisRESOURCE_ID; ?></td>
    34. 

  34. </tr>
    35. 

  35. <tr height="30">
    36. 

  36. 	<td align="right"><b>RESOURCE_TYPE : </b></td>
    37. 

  37. 	<td><? echo $thisRESOURCE_TYPE; ?></td>
    38. 

  38. </tr>
    39. 

  39. <tr height="30">
    40. 

  40. 	<td align="right"><b>RESOURCE_FLAGS : </b></td>
    41. 

  41. 	<td><? echo $thisRESOURCE_FLAGS; ?></td>
    42. 

  42. </tr>
    43. 

  43. <tr height="30">
    44. 

  44. 	<td align="right"><b>RESOURCE_STATE : </b></td>
    45. 

  45. 	<td><? echo $thisRESOURCE_STATE; ?></td>
    46. 

  46. </tr>
    47. 

  47. <tr height="30">
    48. 

  48. 	<td align="right"><b>RESOURCE_SIZE : </b></td>
    49. 

  49. 	<td><? echo $thisRESOURCE_SIZE; ?></td>
    50. 

  50. </tr>
    51. 

  51. <tr height="30">
    52. 

  52. 	<td align="right"><b>DATE_CONTENT : </b></td>
    53. 

  53. 	<td><? echo $thisDATE_CONTENT; ?></td>
    54. 

  54. </tr>
    55. 

  55. <tr height="30">
    56. 

  56. 	<td align="right"><b>SIBLING_COUNT : </b></td>
    57. 

  57. 	<td><? echo $thisSIBLING_COUNT; ?></td>
    58. 

  58. </tr>
    59. 

  59. <tr height="30">
    60. 

  60. 	<td align="right"><b>DATE_CREATED : </b></td>
    61. 

  61. 	<td><? echo $thisDATE_CREATED; ?></td>
    62. 

  62. </tr>
    63. 

  63. <tr height="30">
    64. 

  64. 	<td align="right"><b>DATE_LASTMODIFIED : </b></td>
    65. 

  65. 	<td><? echo $thisDATE_LASTMODIFIED; ?></td>
    66. 

  66. </tr>
    67. 

  67. <tr height="30">
    68. 

  68. 	<td align="right"><b>USER_CREATED : </b></td>
    69. 

  69. 	<td><? echo $thisUSER_CREATED; ?></td>
    70. 

  70. </tr>
    71. 

  71. <tr height="30">
    72. 

  72. 	<td align="right"><b>USER_LASTMODIFIED : </b></td>
    73. 

  73. 	<td><? echo $thisUSER_LASTMODIFIED; ?></td>
    74. 

  74. </tr>
    75. 

  75. <tr height="30">
    76. 

  76. 	<td align="right"><b>PROJECT_LASTMODIFIED : </b></td>
    77. 

  77. 	<td><? echo $thisPROJECT_LASTMODIFIED; ?></td>
    78. 

  78. </tr>
    79. 

  79. <tr height="30">
    80. 

  80. 	<td align="right"><b>PUBLISH_TAG : </b></td>
    81. 

  81. 	<td><? echo $thisPUBLISH_TAG; ?></td>
    82. 

  82. </tr>
    83. 

  83. <tr height="30">
    84. 

  84. 	<td align="right"><b>RESOURCE_VERSION : </b></td>
    85. 

  85. 	<td><? echo $thisRESOURCE_VERSION; ?></td>
    86. 

  86. </tr>
    87. 

  87. </table>
    88. 

  88. 

  89. <?php
    90. 

  90. include_once("../common/footer.php");
    91. 

  91. ?>
    92.