PHP Classes

File: v3mysql/index.php

Recommend this page to a friend!
  Classes of Yorch Ponce   V3ctor WareHouse   v3mysql/index.php   Download  
File: v3mysql/index.php
Role: Auxiliary script
Content type: text/plain
Description: Auxiliary script
Class: V3ctor WareHouse
Store and retrieve objects in MongoDB and MySQL
Author: By
Last change:
Date: 5 years ago
Size: 10,430 bytes
 

Contents

Class file image Download
<?php ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content="V3ctor Warehouse for MySQL"> <meta name="author" content="YoRcH"> <title>V3ctor Warehouse</title> <link href="data:image/x-icon;base64,AAABAAEAEBAAAAEAIABoBAAAFgAAACgAAAAQAAAAIAAAAAEAIAAAAAAAAAQAABILAAASCwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGwAAALkAAAD4AAAAzQAAADIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAALgAAAD/AAAA/wAAAP8AAADgAAAABQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAD1AAAA/wAAAP8AAAD/AAAA/wAAACUAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAABUAAAA9wAAAP8AAAD/AAAA/wAAAO4AAAAKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADAAAAC/AAAA1AAAAGgAAADgAAAA/wAAAO8AAABQAAAAAAAAAAAAAAAEAAAAYgAAAI8AAABRAAAAFQAAAJgAAADqAAAAbgAAAAUAAAAAAAAABgAAACYAAAALAAAAAAAAAAAAAAAAAAAAogAAAP8AAAD/AAAA/wAAAPMAAACWAAAAFAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFwAAAP0AAAD/AAAA/wAAAP8AAADtAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABcAAAD9AAAA/wAAAP8AAAD/AAAA8AAAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAowAAAP8AAAD/AAAA/wAAAOwAAAC3AAAAKgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAABjAAAAkAAAAFIAAAAIAAAAdgAAAOwAAACQAAAAEgAAAAAAAAAFAAAAJQAAAAoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAZAAAAngAAAOgAAAB9AAAA4AAAAP8AAADvAAAAUAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA1AAAA8wAAAP8AAAD/AAAA/wAAAO4AAAAKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAPUAAAD/AAAA/wAAAP8AAAD/AAAAJQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAC4AAAA/wAAAP8AAAD/AAAA4AAAAAYAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHAAAALoAAAD5AAAAzgAAADMAAAAA/8EAAP/AAAD/gAAA/wAAAP4BAACAIwAAAP8AAAH/AAAB/wAAAP8AAIAjAAD+AQAA/4AAAP+AAAD/wAAA/8EAAA==" rel="icon" type="image/x-icon"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script> <link href="https://cdnjs.cloudflare.com/ajax/libs/flat-ui/2.3.0/css/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet"> <link href="https://cdnjs.cloudflare.com/ajax/libs/flat-ui/2.3.0/css/flat-ui.min.css" rel="stylesheet"> <script src="https://cdnjs.cloudflare.com/ajax/libs/flat-ui/2.3.0/js/flat-ui.min.js"></script> <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.8.1/css/all.css" integrity="sha384-50oBUHEmvpQ+1lW4y57PTFmhCaXp0ML5d60M1M7uH2+nqUivzIebhndOJK28anvf" crossorigin="anonymous"> <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries --> <!--[if lt IE 9]> <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script> <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script> <![endif]--> <style type="text/css"> body { padding-top: 20px; padding-bottom: 20px; } .jumbotron { background-color: #ffffff; } .modal { text-align: center; padding: 0!important; } .modal:before { content: ''; display: inline-block; height: 100%; vertical-align: middle; margin-right: -4px; } .modal-dialog { display: inline-block; text-align: left; vertical-align: middle; } .modal.fade .modal-dialog { -webkit-transform: scale(0.1); -moz-transform: scale(0.1); -ms-transform: scale(0.1); transform: scale(0.1); top: 300px; opacity: 0; -webkit-transition: all 0.3s; -moz-transition: all 0.3s; transition: all 0.3s; } .modal.fade.in .modal-dialog { -webkit-transform: scale(1); -moz-transform: scale(1); -ms-transform: scale(1); transform: scale(1); -webkit-transform: translate3d(0, -300px, 0); transform: translate3d(0, -300px, 0); opacity: 1; } </style> <script type="text/javascript"> jProp = {}; reloadPage = false; function showMsg(msg, type) { if (type == 1) { $("#btnMsg").removeClass("btn-danger"); $("#btnMsg").addClass("btn-primary"); } else { $("#btnMsg").removeClass("btn-primary"); $("#btnMsg").addClass("btn-danger"); } $("#txtMsg").html(msg); $("#winMsg").modal({ backdrop: 'static', keyboard: false }); } function showProp() { $("#txtPropName").val(""); $("#winProp").modal({ backdrop: 'static', keyboard: false }); } function delProp(propName) { jTemp = {}; for(var p in jProp) { if (p != propName) { jTemp[p] = jProp[p]; } } jProp = jTemp; showGrid(); } function showGrid() { var html = ""; for(var p in jProp) { html = html + "<tr><td>" + p + "</td>"; html = html + "<td>" + jProp[p] + "</td>"; html = html + '<td><button class="btn btn-sm btn-danger" onclick=delProp("' + p + '")> <b>Remove</b></button></td></tr>'; } $("#grdProp").html(html); } function createEntity() { var entName = $("#txtEntity").val(); if (entName == "") { showMsg("You must type entity name", 2); return false; } if (jsonLen() == 0) { showMsg("You must add properties", 2); return false; } var url = 'create.php?entity=' + entName; $.post(url, JSON.stringify(jProp), function(response, status){ if (status == "success"){ reloadPage = true; showMsg(response["msg"], 1); } }).error(function(error){ console.log(error); }); } function jsonLen() { var t = 0; for(var p in jProp) { t++; } return t; } // Init Jquery $(document).ready( function() { $("#btnAdd").click(function() { showProp(); }); $("#btnProp").click(function() { var propName = $("#txtPropName").val(); if (propName == "") { showMsg("You must type property name", 2); return false; } if (jProp[propName]) { showMsg("Property name already exists", 2); return false; } else { jProp[propName] = $("#cmbPropType").val(); showGrid(); $("#winProp").modal("hide"); $("#btnCreate").prop("disabled", false); } }); $("#btnCreate").click(function() { createEntity(); }); $("#btnMsg").click(function() { if(reloadPage) window.location.reload(); }); }); </script> </head> <body> <div class="container"> <center> <h3>V3ctor WareHouse for MySQL</h3> <h4>SDKs</h4> <a href="https://github.com/yorch81/v3sdk_java" target="_blank"><i class="fab fa-java fa-3x"></i></a>&nbsp;&nbsp;&nbsp; <a href="https://github.com/yorch81/v3sdk_js" target="_blank"><i class="fab fa-js fa-3x"></i></a>&nbsp;&nbsp;&nbsp; <a href="https://github.com/yorch81/v3sdk_android" target="_blank"><i class="fab fa-android fa-3x"></i></a>&nbsp;&nbsp;&nbsp; <a href="https://github.com/yorch81/v3sdk" target="_blank"><i class="fab fa-php fa-3x"></i></a>&nbsp;&nbsp;&nbsp; <a href="https://github.com/yorch81/v3sdk_net" target="_blank"><i class="fab fa-microsoft fa-3x"></i></a> <br> </center> <div class="container"> <p>V3ctor URL = <b>http://yorch.tk/v3ctorwh/api/</b></p> <p>V3ctor KEY = <b>qjnVYHaFmDAcvc5r2JoYta2EJ9yhPi</b></p> <h5>Entity</h5> <div class="form-inline"> <div class='input-group'> <span class="input-group-addon">v3_</span> <input id="txtEntity" type="text " class="form-control" placeholder="Entity name" name="txtEntity" value=""> </div> </div> <br> <button id="btnAdd" class="btn btn-primary">Add property</button> <br> <h5>Properties</h5> <div class="container"> <table class="table"> <thead> <tr> <th>Property</th> <th>Type</th> <th>Actions</th> </tr> </thead> <tbody id="grdProp"> </tbody> </table> </div> <br> <button id="btnCreate" class="btn btn-primary" disabled="true">Add entity</button> </div> </div> <div class="modal fade" id="winProp" role="dialog" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-body"> <label for="txtPropName">Property name:</label> <input type="text" name="propName" class="form-control" id="txtPropName" placeholder="Property name" required> <br> <label for="cmbPropType">Property type:</label> <select id='cmbPropType' class='form-control' name='propType'> <option vale="TEXT">TEXT</option> <option vale="INTEGER">INTEGER</option> <option vale="DECIMAL">DECIMAL</option> <option vale="DATETIME">DATETIME</option> </select> <br> <center> <button class="btn btn-danger" data-dismiss="modal"> <b>Cancel</b></button> <button id="btnProp" class="btn btn-primary"> <b>Add</b></button> </center> </div> </div> </div> </div> <div class="modal fade" id="winMsg" role="dialog" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-body"> <p id="txtMsg">Alert Message</p> <br/> <center> <button id="btnMsg" class="btn btn-primary" data-dismiss="modal"> <b>Ok</b></button> </center> </div> </div> </div> </div> </body> </html>