API tools faq
paste
Advertisement
Guest User

NIH RAY SCRIPT LENGKAP NYA

a guest
Nov 23rd, 2017
82
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.75 KB | None | 0 0
raw download clone embed print report
  1. <?php require_once('../Connections/smapunggur_db.php'); ?>
  2.  
  3. <?php
  4. if (!isset($_SESSION)) {
  5. session_start();
  6. }
  7. $MM_authorizedUsers = "";
  8. $MM_donotCheckaccess = "true";
  9.  
  10. // *** Restrict Access To Page: Grant or deny access to this page
  11. function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
  12. // For security, start by assuming the visitor is NOT authorized.
  13. $isValid = False;
  14.  
  15. // When a visitor has logged into this site, the Session variable MM_Username set equal to their username.
  16. // Therefore, we know that a user is NOT logged in if that Session variable is blank.
  17. if (!empty($UserName)) {
  18. // Besides being logged in, you may restrict access to only certain users based on an ID established when they login.
  19. // Parse the strings into arrays.
  20. $arrUsers = Explode(",", $strUsers);
  21. $arrGroups = Explode(",", $strGroups);
  22. if (in_array($UserName, $arrUsers)) {
  23. $isValid = true;
  24. }
  25. // Or, you may restrict access to only certain users based on their username.
  26. if (in_array($UserGroup, $arrGroups)) {
  27. $isValid = true;
  28. }
  29. if (($strUsers == "") && true) {
  30. $isValid = true;
  31. }
  32. }
  33. return $isValid;
  34. }
  35.  
  36. $MM_restrictGoTo = "http://localhost/smapunggur/index.php";
  37. if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
  38. $MM_qsChar = "?";
  39. $MM_referrer = $_SERVER['PHP_SELF'];
  40. if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
  41. if (isset($_SERVER['QUERY_STRING']) && strlen($_SERVER['QUERY_STRING']) > 0)
  42. $MM_referrer .= "?" . $_SERVER['QUERY_STRING'];
  43. $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
  44. header("Location: ". $MM_restrictGoTo);
  45. exit;
  46. }
  47. ?>
  48. <?php
  49. if (!function_exists("GetSQLValueString")) {
  50. function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
  51. {
  52. if (PHP_VERSION < 6) {
  53. $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  54. }
  55.  
  56. $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
  57.  
  58. switch ($theType) {
  59. case "text":
  60. $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  61. break;
  62. case "long":
  63. case "int":
  64. $theValue = ($theValue != "") ? intval($theValue) : "NULL";
  65. break;
  66. case "double":
  67. $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
  68. break;
  69. case "date":
  70. $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  71. break;
  72. case "defined":
  73. $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
  74. break;
  75. }
  76. return $theValue;
  77. }
  78. }
  79.  
  80.  
  81. $colname_test = "-1";
  82. if (isset($_SESSION['MM_Username'])) {
  83. $colname_test = $_SESSION['MM_Username'];
  84. }
  85.  
  86. ob_start();
  87. mysql_select_db($database_smapunggur_db, $smapunggur_db);
  88. $query_panggilan = sprintf("SELECT * FROM smapunggur_siswa WHERE username = %s", GetSQLValueString($colname_test, "text"));
  89. $panggilan = mysql_query($query_panggilan, $smapunggur_db) or die(mysql_error());
  90. $row_panggilan = mysql_fetch_assoc($panggilan);
  91. $totalRows_panggilan = mysql_num_rows($panggilan);
  92.  
  93. mysql_select_db($database_smapunggur_db, $smapunggur_db);
  94. $query_cetak = sprintf("SELECT * FROM smapunggur_siswa WHERE username = %s", GetSQLValueString($colname_test, "text"));
  95. $cetak = mysql_query($query_cetak, $smapunggur_db) or die(mysql_error());
  96. $row_cetak = mysql_fetch_assoc($cetak);
  97. $totalRows_cetak = mysql_num_rows($cetak);
  98.  
  99. mysql_select_db($database_smapunggur_db, $smapunggur_db);
  100. $query_nilai = sprintf("SELECT * FROM smapunggur_siswa,smapunggur_nilai,smapunggur_tes WHERE smapunggur_siswa.username=smapunggur_nilai.username AND smapunggur_siswa.username=smapunggur_tes.username AND smapunggur_siswa.username = %s", GetSQLValueString($colname_test, "text"));
  101. $nilai = mysql_query($query_nilai, $smapunggur_db) or die(mysql_error());
  102. $row_nilai = mysql_fetch_assoc($nilai);
  103. $totalRows_nilai = mysql_num_rows($nilai);
  104.  
  105. mysql_select_db($database_smapunggur_db, $smapunggur_db);
  106. $query_waktu = sprintf("SELECT * FROM smapunggur_waktutest");
  107. $waktu = mysql_query($query_waktu, $smapunggur_db) or die(mysql_error());
  108. $row_waktu = mysql_fetch_assoc($waktu);
  109.  
  110. mysql_select_db($database_smapunggur_db, $smapunggur_db);
  111. $query_admin = sprintf("SELECT * FROM smapunggur_admin");
  112. $admin = mysql_query($query_admin, $smapunggur_db) or die(mysql_error());
  113. $row_admin = mysql_fetch_assoc($admin);
  114.  
  115. ?>
  116. <?php
  117. ob_start();
  118. ?>
  119. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  120. <html xmlns="http://www.w3.org/1999/xhtml">
  121. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  122. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  123. <title>Nama Siswa</title>
  124. <link href="print.css" rel="stylesheet" type="text/css" media="all" />
  125. </head>
  126.  
  127. <body>
  128. <img src="pututlogobekasi.png" width="700" height="100" />
  129. <div class="formulir-header">
  130. <strong>FORMULIR PENDAFTARAN PESERTA DIDIK BARU KAB.BEKASI</strong><br />
  131. Nomor : <?php echo $row_panggilan['id_siswa']; ?>/SMA/PSB/2017
  132. </div>
  133.  
  134. <table width="800" border="0" cellpadding="5" cellspacing="5" >
  135. <tr>
  136. <td width="23"><strong>1</strong></td>
  137. <td width="200">Nama Calon Siswa</td>
  138. <td width="18">:</td>
  139. <td style="text-transform:capitalize" width="541"><?php echo $row_panggilan['nama_lengkap']; ?></td>
  140. </tr>
  141. <tr>
  142. <td>&nbsp;</td>
  143. <td>Jenis Kelamin</td>
  144. <td>:</td>
  145. <td><?php
  146. $jk = $row_panggilan['jenis_kelamin'];
  147. if ($jk == 0 ) { echo "Laki-Laki"; }
  148. else if ($jk == 1) { echo "Wanita"; }
  149. ?></td>
  150. </tr>
  151. <tr>
  152. <td>&nbsp;</td>
  153. <td><span class="field-label">Tempat dan Tanggal Lahir</span></td>
  154. <td>:</td>
  155. <td><?php echo $row_panggilan['tempat_lahir']; ?>,<?php echo $row_panggilan['tanggal_lahir']; ?></td>
  156. </tr>
  157. <tr>
  158. <td>&nbsp;</td>
  159. <td><span class="field-label">Nama Orang Tua / Wali</span></td>
  160. <td>:</td>
  161. <td><?php echo $row_panggilan['nama_ortu']; ?></td>
  162. </tr>
  163. <tr>
  164. <td>&nbsp;</td>
  165. <td><span class="field-label">Alamat Siswa</span></td>
  166. <td>:</td>
  167. <td><?php echo $row_panggilan['alamat_siswa']; ?></td>
  168. </tr>
  169. <tr>
  170. <td>&nbsp;</td>
  171. <td><span class="field-label">Nama Asal Sekolah</span></td>
  172. <td>:</td>
  173. <td><?php echo $row_panggilan['sekolah_asal']; ?></td>
  174. </tr>
  175. </table>
  176. <table width="1332" border="0" cellpadding="5" cellspacing="5">
  177. <tr>
  178. <td width="22"><strong>2</strong></td>
  179. <td colspan="2"><strong>NILAI UJIAN AKHIR NASIONAL </strong></td>
  180. <td width="55" bgcolor="#FFFFFF">&nbsp;</td>
  181. <td width="10"><strong>3</strong></td>
  182. <td width="954"><strong>TES YANG AKAN DIIKUTI</strong></td>
  183. </tr>
  184. <tr>
  185. <td>&nbsp;</td>
  186. <td width="180" bgcolor="#A8EADB">Matematika</td>
  187. <td width="16" bgcolor="#A8EADB"><?php echo $row_nilai['nilai_mtk']; ?></td>
  188. <td bgcolor="#FFFFFF">&nbsp;</td>
  189. <td>&nbsp;</td>
  190. <td>TES AKADEMIS : <?php
  191. $tes = $row_nilai['tes_akademis'];
  192. if ($tes == 1 ) { echo "Ya"; }
  193. else if ($tes == 0) { echo "Tidak"; }
  194. ?></td>
  195. </tr>
  196. <tr>
  197. <td>&nbsp;</td>
  198. <td bgcolor="#EEE">Bahasa Inggris</td>
  199. <td bgcolor="#EEE"><?php echo $row_nilai['nilai_bing']; ?></td>
  200. <td bgcolor="#FFFFFF">&nbsp;</td>
  201. <td>&nbsp;</td>
  202. <td>TES AKADEMIS DAN BAKAT : <?php
  203. $tes = $row_nilai['tes_akademis_bakat'];
  204. if ($tes == 1 ) { echo "Ya"; }
  205. else if ($tes == 0) { echo "Tidak"; }
  206. ?></td>
  207. </tr>
  208. <tr>
  209. <td>&nbsp;</td>
  210. <td bgcolor="#A8EADB">Bahasa Indonesia</td>
  211. <td bgcolor="#A8EADB"><?php echo $row_nilai['nilai_bindo']; ?></td>
  212. <td bgcolor="#FFFFFF">&nbsp;</td>
  213. <td>&nbsp;</td>
  214. <td>TES BAKAT YANG DIIKUTI : <?php
  215. $tes = $row_nilai['tes_bakat'];
  216. if ($tes == 1 ) { echo "Basket"; }
  217. else if ($tes == 2) { echo "Volli"; }
  218. else if ( $tes ==3) { echo "Atletik "; }
  219. else if ($tes == 4) { echo "Sepak Bola"; }
  220. else { echo" Tidak Ikut Apapun"; };
  221. ?></td>
  222. </tr>
  223. <tr>
  224. <td>&nbsp;</td>
  225. <td bgcolor="#EEE">Ilmu Pengetahuan Alam</td>
  226. <td bgcolor="#EEE"><?php echo $row_nilai['nilai_ipa']; ?></td>
  227. <td bgcolor="#FFFFFF">&nbsp;</td>
  228. <td>&nbsp;</td>
  229. <td>&nbsp;</td>
  230. </tr>
  231. <tr>
  232. <td>&nbsp;</td>
  233. <td bgcolor="#A8EADB">Ilmu Pengetahuan Sosial</td>
  234. <td bgcolor="#A8EADB"><?php echo $row_nilai['nilai_ips']; ?></td>
  235. <td bgcolor="#FFFFFF">&nbsp;</td>
  236. <td>&nbsp;</td>
  237. <td>&nbsp;</td>
  238. </tr>
  239. </table>
  240. <table width="551" border="0">
  241. <tr>
  242. <td width="29"><strong>4</strong></td>
  243. <td colspan="3"><strong>PELAKSANAAN TEST </strong></td>
  244. <td width="12"><strong>5</strong></td>
  245. <td width="121"><strong><?php
  246. $Ruangan = $row_panggilan['id_siswa'];
  247. if ( $Ruangan <= 25 ) {
  248. echo "Ruangan : 1";
  249. }
  250. else if ( $Ruangan <= 50 ) {
  251. echo "Ruangan : 2";
  252. }
  253. else if ( $Ruangan <= 75 ) {
  254. echo "Ruangan : 3";
  255. }
  256. else if ( $Ruangan <= 100 ) {
  257. echo "Ruangan : 4";
  258. }
  259. else if ( $Ruangan <= 125 ) {
  260. echo "Ruangan : 5";
  261. }
  262. else if ( $Ruangan <= 150 ) {
  263. echo "Ruangan : 6";
  264. }
  265. else if ( $Ruangan <= 175 ) {
  266. echo "Ruangan : 7";
  267. }
  268. else if ( $Ruangan <= 200 ) {
  269. echo "Ruangan : 8";
  270. }
  271. else if ( $Ruangan <= 225 ) {
  272. echo "Ruangan : 9";
  273. }
  274. else if ( $Ruangan <= 250 ) {
  275. echo "Ruangan : 10";
  276. }
  277. else if ( $Ruangan <= 275 ) {
  278. echo "Ruangan : 11";
  279. }
  280. else if ( $Ruangan <= 300 ) {
  281. echo "Ruangan : 12";
  282. }
  283. else if ( $Ruangan <= 325 ) {
  284. echo "Ruangan : 13";
  285. }
  286. else if ( $Ruangan <= 350 ) {
  287. echo "Ruangan : 14";
  288. }
  289. else if ( $Ruangan <= 375 ) {
  290. echo "Ruangan : 15";
  291. }
  292. else if ( $Ruangan <= 400 ) {
  293. echo "Ruangan : 16";
  294. }
  295. else if ( $Ruangan <= 425 ) {
  296. echo "Ruangan :17";
  297. }
  298. else { echo "gak punya Ruangan" ; }
  299. ?></strong></td>
  300. <td width="71">&nbsp;</td>
  301. </tr>
  302. <tr>
  303. <td>&nbsp;</td>
  304. <td width="252">
  305. <?php do { ?>
  306. <?php echo $row_waktu['nama_test']; ?> : <?php echo $row_waktu['waktu_test']; ?><?php echo $row_waktu['keterangan']; ?> <br />
  307. <?php } while ($row_waktu = mysql_fetch_assoc($waktu)); ?>
  308. </td>
  309. <td>
  310.  
  311.  
  312.  
  313. </td>
  314. <td>
  315.  
  316.  
  317.  
  318. </td>
  319.  
  320. <td>&nbsp;</td>
  321. <td>&nbsp;<strong></strong></td>
  322. <td>&nbsp;</td>
  323. </tr>
  324. <tr>
  325. <td>&nbsp;</td>
  326. <td>&nbsp;</td>
  327. <td>&nbsp;</td>
  328. <td>&nbsp;</td>
  329. <td>&nbsp;</td>
  330. <td style="color:#fff;padding:10px;">&nbsp;</td>
  331. <td style="color:#fff;padding:10px;">&nbsp;</td>
  332. </tr>
  333. <tr>
  334. <td>&nbsp;</td>
  335. <td>
  336. <br>
  337. <br><br>
  338. <br>
  339. <br>
  340.  
  341.  
  342.  
  343.  
  344. Petugas PSB Online
  345.  
  346.  
  347.  
  348.  
  349. <?php echo $row_admin['nama_lengkap']; ?><br />
  350. NIP: <?php echo $row_admin['nip']; ?>
  351. </td>
  352. <td colspan="3" align="right">
  353. <br />
  354. <br />
  355. <br /> <img class="kanan" src="../foto/<?php echo $row_panggilan['foto']; ?>" alt="" width="150" /> //BUAT NAMBAHIN FOTO NIH RAY
  356. </td>
  357. <td> </td>
  358. <td>
  359.  
  360.  
  361.  
  362.  
  363.  
  364.  
  365. <br>
  366. <br>
  367. <br>
  368. <br>
  369. Punggur , <?php echo date('d-M-Y'); ?>
  370.  
  371. Pendaftar,
  372.  
  373.  
  374.  
  375. <br>
  376. <br>
  377. <?php echo $row_panggilan['nama_lengkap']; ?>
  378. &nbsp;</td>
  379. </tr>
  380. </table>
  381. <p>========================================================================================</p>
  382. <p><br />
  383. </p>
  384. </body>
  385. </html>
  386.  
  387. <?php
  388. $filename="tugas-akhir-".$nama = $row_panggilan['username'].".pdf"; //ubah untuk menentukan nama file pdf yang dihasilkan nantinya
  389. //==========================================================================================================
  390. //Copy dan paste langsung script dibawah ini,untuk mengetahui lebih jelas tentang fungsinya silahkan baca-baca tutorial tentang HTML2PDF
  391. //==========================================================================================================
  392. $content = ob_get_clean();
  393. $content = '<page style="font-family: freeserif">'.nl2br($content).'</page>';
  394. require_once(dirname(__FILE__).'../../html2pdf/html2pdf.class.php');
  395. try
  396. {
  397. $html2pdf = new HTML2PDF('P','A4','en', false, 'ISO-8859-15',array(11, 5, 5, 0));
  398. $html2pdf->setDefaultFont('Arial');
  399. $html2pdf->writeHTML($content, isset($_GET['vuehtml']));
  400. $html2pdf->Output($filename);
  401. }
  402. catch(HTML2PDF_exception $e) { echo $e; }
  403. ?> <?php mysql_free_result($cetak);
  404.  
  405. mysql_free_result($panggilan);
  406. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!