<?php require_once 'crud/preheader1.php'; include_once 'crud/ajaxCRUD1.class.php'; //just so i can leverage echo_msg_box(); //////tblDem1 est la table dans laquelle on va stocker les swicthes cores///////////// //////tblDemo2 est la table dans laquelle on va stocker les switches acces /////////// qr("CREATE TABLE tblDemo(pkID INT PRIMARY KEY AUTO_INCREMENT,fldField1 VARCHAR(45),fldField2 VARCHAR(45),fldCertainFields VARCHAR(40),fldLongField TEXT, fldCheckbox TINYINT);"); $report_msg[] = "TABLE <b>cmdmonitor</b> CREATED\n"; qr("CREATE TABLE tblDemo2(pkID INT PRIMARY KEY AUTO_INCREMENT,Hostname VARCHAR(45),Username VARCHAR(45),Password TEXT);"); $report_msg[] = "TABLE <b>tblDemo2</b> CREATED\n"; if ($success) { $report_msg[] = "<b>Example rows entered into demo tables.</b>\n"; } echo_msg_box();
function uploadFile($row_id, $file_field, $upload_folder) { @($fileName = $_FILES[$file_field]['name']); @($tmpName = $_FILES[$file_field]['tmp_name']); @($fileSize = $_FILES[$file_field]['size']); @($fileType = $_FILES[$file_field]['type']); $new_filename = make_filename_safe($fileName); if ($this->filename_append_field != "") { if ($_REQUEST[$this->filename_append_field] != '') { $new_filename = $_REQUEST[$this->filename_append_field] . "_" . $new_filename; } else { if ($this->filename_append_field == $this->db_table_pk) { $new_filename = $row_id . "_" . $new_filename; } else { @($db_value_to_append = q1("SELECT {$this->filename_append_field} FROM {$this->db_table} WHERE {$this->db_table_pk} = {$row_id}")); if ($db_value_to_append != "") { $new_filename = $db_value_to_append . "_" . $new_filename; } } } } $destination = $upload_folder . $new_filename; $success = move_uploaded_file($tmpName, $destination); if ($success) { $update_success = qr("UPDATE {$this->db_table} SET {$file_field} = \"{$new_filename}\" WHERE {$this->db_table_pk} = {$row_id}"); if ($this->onFileUploadExecuteCallBackFunction != '') { $file_info_array = array(); $file_info_array[id] = $row_id; $file_info_array[field] = $file_field; $file_info_array[fileName] = $new_filename; $file_info_array[fileSize] = $fileSize; $file_info_array[fldType] = $fldType; call_user_func($this->onFileUploadExecuteCallBackFunction, $file_info_array); } } if ($update_success) { return true; //$report_msg[] = "File Uploaded."; } else { return false; //$error_msg[] = "There was an error uploading your file (or none was selected)."; } }
function uploadFile($row_id, $file_field, $upload_folder, $allowedExts = "") { global $report_msg, $error_msg; @($fileName = $_FILES[$file_field]['name']); @($tmpName = $_FILES[$file_field]['tmp_name']); @($fileSize = $_FILES[$file_field]['size']); @($fileType = $_FILES[$file_field]['type']); if (is_array($allowedExts)) { $fileExt = strtolower(pathinfo($fileName, PATHINFO_EXTENSION)); //gets file ext (lowercase) if (!in_array($fileExt, $allowedExts)) { $error_msg[] = "Upload failed. Selected file was extention <b>.{$fileExt}</b> but this is not an permitted file extension."; return false; } } $new_filename = make_filename_safe($fileName); if ($this->filename_append_field != "") { if ($_REQUEST[$this->filename_append_field] != '') { $new_filename = $_REQUEST[$this->filename_append_field] . "_" . $new_filename; } else { if ($this->filename_append_field == $this->db_table_pk) { $new_filename = $row_id . "_" . $new_filename; } else { @($db_value_to_append = q1("SELECT {$this->filename_append_field} FROM {$this->db_table} WHERE {$this->db_table_pk} = {$row_id}")); if ($db_value_to_append != "") { $new_filename = $db_value_to_append . "_" . $new_filename; } } } } $destination = $upload_folder . $new_filename; $success = move_uploaded_file($tmpName, $destination); if ($success) { $update_success = qr("UPDATE {$this->db_table} SET {$file_field} = \"{$new_filename}\" WHERE {$this->db_table_pk} = {$row_id}"); if ($this->onFileUploadExecuteCallBackFunction != '') { $file_info_array = array(); $file_info_array[id] = $row_id; $file_info_array[field] = $file_field; $file_info_array[fileName] = $new_filename; $file_info_array[fileSize] = $fileSize; $file_info_array[fldType] = $fldType; call_user_func($this->onFileUploadExecuteCallBackFunction, $file_info_array); } if ($update_success) { return true; } } else { $error_msg[] = "There was an error uploading your file. Check permissions of the destination directory (make sure is set to 777)."; } return false; }
function onAddCallBackFunction($array) { global $idsAdded, $report_msg, $error_msg; $newID = $array['pkAttendeeID']; $fkEventID = $array['fkEventID']; $firstName = $array['fldFirstName']; $lastName = $array['fldLastName']; $countMatchingRows = q1("SELECT COUNT(*) FROM tblEventAttendee WHERE fldFirstName = \"{$firstName}\" AND fldLastName = \"{$lastName}\" AND fkEventID = {$fkEventID}"); if ($countMatchingRows > 1) { $success = qr("DELETE FROM tblEventAttendee WHERE pkAttendeeID = {$newID}"); if ($success) { $error_msg[] = "Ignore that last message...it seems you have added yourself TWICE! You idiot! The system automatically deleted your second entry."; return; } else { $error_msg[] = "Error deleting the second database entry."; return; } } $idsAdded[] = $newID; //array push //set cookie 10 years in the future setcookie("ajaxCRUDEventID_{$newID}", "cookieset", time() + 10 * 365 * 24 * 60 * 60); //print_r($_COOKIE); }
function private_and_public_qr($bill) { global $pdf; $p = $bill->p; $y = $bill->y + 0.6; $priv_y = $y + 0.3; $line_height = 0.08; $pdf->SetFont($font, '', 5); quick_text($bill, 'Private Key (Used to transfer coins)', $priv_y - 0.05, 'L'); qr($bill, $bill->priv, $priv_y, 'L', 0.6, 1.125); $size = 0.8; $y = $bill->y + 0.65; $nudge = 1.2; $link = 'http://blockexplorer.com/q/addressbalance/' . $bill->pub; $size = 0.6; quick_text($bill, 'Check Balance at this QR link', $y - $line_height * 2, 'R'); quick_text($bill, 'with a smartphone barcode scanner', $y - $line_height, 'R'); qr($bill, $link, $y, 'R', 0.6, 0.6); $y = $bill->y + 1.5; quick_text($bill, "Fund this bill at this public address", $y - $line_height * 2, 'R'); quick_text($bill, $bill->pub, $y - $line_height, 'R'); qr($bill, $bill->pub, $y, 'R', $size, $size, 0); }
<?php require_once '../preheader.php'; $success = q1("CREATE TABLE tblDemo(pkID INT PRIMARY KEY AUTO_INCREMENT,fldField1 VARCHAR(45),fldField2 VARCHAR(45),fldCertainFields VARCHAR(40),fldLongField TEXT);"); if ($success) { echo "TABLE <b>tblDemo</b> CREATED <br /><br />\n"; } $success = q1("CREATE TABLE tblDemo2(pkID INT PRIMARY KEY AUTO_INCREMENT,fldField1 VARCHAR(45),fldField2 VARCHAR(45),fldCertainFields VARCHAR(40),fldLongField TEXT);"); if ($success) { echo "TABLE <b>tblDemo2</b> CREATED <br /><br />\n"; } $success = qr("INSERT INTO tblDemo (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Testing\", \"Testing2\", \"CRUD\", \"First ajaxCRUD Test\")"); $success = qr("INSERT INTO tblDemo2 (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Testing\", \"Testing2\", \"CRUD\", \"Second ajaxCRUD Test\")"); if ($success) { echo "Example rows entered into <b>tblDemo</b> and <b>tblDemo2</b><br /><br />\n"; } echo "<p><a href='example.php'>Try out the demo</a></p>\n"; echo "<p><a href='example.php'>Try out a demo with two ajaxCRUD tables.</a></p>\n";
//populate tblDemo and tblDemo2 $success = qr("INSERT INTO tblDemo (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Adam\", \"Smith\", \"CRUD\", \"First ajaxCRUD Test. A founding father.\")"); $success = qr("INSERT INTO tblDemo (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Justin\", \"Beiber\", \"CRUD\", \"Second ajaxCRUD Test. A man who should be deported. \")"); $success = qr("INSERT INTO tblDemo (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Sean\", \"Dempsey\", \"CRUD\", \"Third ajaxCRUD Test. A man without a cause.\")"); $success = qr("INSERT INTO tblDemo (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Justin\", \"Rigby\", \"Allowable Value1\", \"Fourth ajaxCRUD Test. A man with a plan. \")"); $success = qr("INSERT INTO tblDemo (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Glenn\", \"Beck\", \"Allowable Value2\", \"Fifth ajaxCRUD Test. Brilliant, crazy, eccentric, or just plain mad? \")"); $success = qr("INSERT INTO tblDemo (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Ron\", \"Paul\", \"Allowable Value2\", \"Sixth ajaxCRUD Test. Should have been president. \")"); $success = qr("INSERT INTO tblDemo (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Ayn\", \"Rand\", \"Allowable Value2\", \"Seventh ajaxCRUD Test.\")"); $success = qr("INSERT INTO tblDemo (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Conan\", \"O'Brien\", \"Dropdown Value\", \"Eighth ajaxCRUD Test. A great man of power and excellence. \")"); $success = qr("INSERT INTO tblDemo2 (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Jack\", \"Black\", \"Blue\", \"First ajaxCRUD Test. A comedian/actor. OR is it actor/comedian? \")"); $success = qr("INSERT INTO tblDemo2 (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Ryan Dempsey\", \"Twiddle\", \"Blue\", \"Third ajaxCRUD Test. A great band in rural VT. Check 'em out\")"); $success = qr("INSERT INTO tblDemo2 (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Jefferson\", \"Airplane\", \"Red\", \"Fourth ajaxCRUD Test. He is more airplane than man. \")"); $success = qr("INSERT INTO tblDemo2 (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Correct this\", \"Splling Mistake\", \"Green\", \"Fifth ajaxCRUD Test. See if you can spot the mistake! \")"); $success = qr("INSERT INTO tblDemo2 (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Chuck\", \"Mangione\", \"Periwinkle\", \"Sixth ajaxCRUD Test. A soulful trumpet, indeed. \")"); $success = qr("INSERT INTO tblDemo2 (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Chuck\", \"Woolery\", \"Periwinkle\", \"Seventh ajaxCRUD Test. Wollery is a large and powerful man.\")"); $success = qr("INSERT INTO tblDemo2 (fldField1, fldField2, fldCertainFields, fldLongField) VALUES (\"Emma\", \"Watson\", \"Blue\", \"Eighth ajaxCRUD Test. Too hot for words.\")"); //populate tblFriend $success = qr("INSERT INTO `tblFriend` (`pkFriendID`, `fldName`, `fldAddress`, `fldCity`, `fldState`, `fldZip`, `fldPhone`, `fldEmail`, `fldBestFriend`, `fldDateMet`, `fldFriendRating`, `fldOwes`, `fldPicture`, `fkMarriedTo`) VALUES(1, 'Sean Dempsey', '13 Back River Road', 'Dover', 'NH', '03820', '(603) 978-8841', '*****@*****.**', 'N', '2011-10-27', '5', 122.01, '', 1),(2, 'Justin Rigby', '22 Farmington Rd', 'Rochester', 'VT', '05401', '(802) 661-4051', '*****@*****.**', '', '2011-10-19', '1', 22.00, '', 2),(3, 'Ryan Dempsey', '', '', 'VT', '', '', '*****@*****.**', '', '2011-10-20', '', 0.00, '',3);"); //populate tblLadies $success = qr("INSERT INTO tblLadies (fldName, fldSort) VALUES ('Jackie Benson', 1)"); $success = qr("INSERT INTO tblLadies (fldName, fldSort) VALUES ('Sharon Nelson', 2)"); $success = qr("INSERT INTO tblLadies (fldName, fldSort) VALUES ('Kirsten Dunst', 3)"); $success = qr("INSERT INTO tblLadies (fldName, fldSort) VALUES ('Emma Watson', 4)"); $success = qr("INSERT INTO tblLadies (fldName, fldSort) VALUES ('Shirley Temple', 5)"); if ($success) { $report_msg[] = "<b>Example rows entered into demo tables.</b>\n"; } echo_msg_box(); echo "<p><a href='example.php'>Try out a basic demo</a></p>\n"; echo "<p><a href='example2.php'>Try out a demo with two ajaxCRUD tables.</a></p>\n"; echo "<p><a href='example3.php'>Try out a demo with validation, masking, file upload, pk/fk relationship, and csv export enabled.</a></p>\n";