shared knowledge

Search This Blog

Sample Relationship zigzag php sql

on December 08, 2019

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Sample Relationship zigzag php sql

select * from items where user = (SELECT USER FROM SUPPLIER WHERE REQNO = 'RN-2019120900003')

sql

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

phprunner custom page view

<?php ini_set("display_errors","0"); set_magic_quotes_runtime(0); header("Expires: Thu, 01 Jan 1970 00:00:01 GMT"); header("Pragma: no-cache"); header("Cache-Control: no-cache"); include("include/dbcommon.php"); if(!@$_SESSION["UserID"]) { header("Location: login.php"); return; } ?> <?php $idb = $_REQUEST['idb']; $sql = "SELECT * FROM badge WHERE idb='".$idb."'"; $results = CustomQuery($sql); $data = db_fetch_array($results); $Status = $data['Status']; $Idb = $data['Idb']; $Payment = $data['Payment']; $Amount = $data['Amount']; $DocNumber = $data['DocNumber']; $Name = $data['Person Name']; $Prof = $data['Profession']; $Comp = $data['Comp name']; $Issue = $data['Issuing Date'];

custom query case when sql phprunner

<?php ini_set("display_errors","0"); set_magic_quotes_runtime(0); header("Expires: Thu, 01 Jan 1970 00:00:01 GMT"); header("Pragma: no-cache"); header("Cache-Control: no-cache"); include("include/dbcommon.php"); if(!@$_SESSION["UserID"]) { header("Location: login.php"); return; } ?> <?php $idb = $_REQUEST['idb']; $sql = " SELECT (CASE WHEN Status IS NULL > '' THEN 'Not Review' WHEN Status = 1 THEN 'Printed' WHEN Status = 2 THEN 'Reject' END) AS Status, IF(Status IS NULL, 'N/A', Status) AS Status1, DocNumber FROM badge WHERE idb='".$idb."'"; $results = CustomQuery($sql); $data = db_fetch_array($results); $Status = $data['Status']; $Idb = $data['Idb']; $Payment =

Check off Encrypt password option in User login settings dialog on the Security tab in PHPRunner.

use BeforeLogin event to put your custom login procedure there. I recommend you to try the following. Check off Encrypt password option in User login settings dialog on the Security tab in PHPRunner. Then build the pages and open generated login.php file with a text editor. Find this line there: Quote $strPassword=md5($strPassword); try to replace it with: Quote $strPassword=sha1($strPassword); or with: Quote $strPassword=strtoupper(sha1($strPassword));

Powered by Blogger

Sample Relationship zigzag php sql

Comments

Post a Comment