shared knowledge

Search This Blog

concat left sql

on November 04, 2019

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

concat(LEFT(Name,10),'.....') AS Name,

phprunner 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

concat left sql

Comments

Post a Comment