error with blank page

Discussions related to customizing hooks. Hooks are documented at http://bigprof.com/appgini/help/advanced-topics/hooks/
Post Reply
Mahmud
Posts: 12
Joined: 2017-03-12 08:53

error with blank page

Post by Mahmud » 2020-06-12 16:42

function G_R_N_USER_DATA_14_after_insert($data, $memberInfo, &$args){

$id = $data['id'];
$DATE = $data['DATE'];
$PROJECT_NAME = $data['PROJECT_NAME'];
$PRODUCT_NAME = $data['PRODUCT_NAME'];
$SUPPLIER = $data['SUPPLIER'];
$UNIT = $data['UNIT'];
$NOTE = $data['NOTE'];
$QUANTITY = $data['QUANTITY'];
$ATTACHMENT = $data['ATTACHMENT'];

mysql_connect("localhost", "hasan_cons", "admin04227") or die(mysql_error());
mysql_select_db("hasan_cons") or die(mysql_error());

mysql_query( "INSERT INTO G_R_N (DATE, PROJECT_NAME, PRODUCT_NAME, SUPPLIER, UNIT, NOTE, QUANTITY, ATTACHMENT) VALUES ('$DATE', '$PROJECT_NAME', '$PRODUCT_NAME', '$SUPPLIER', '$UNIT', '$NOTE', '$QUANTITY', '$ATTACHMENT')") or die(mysql_error());

mysql_query( "INSERT INTO INVENTORY_1 (DATE, PROJECT_NAME, PRODUCT_NAME, SUPPLIER, UNIT, NOTE, QUANTITY, ATTACHMENT) VALUES ('$DATE', '$PROJECT_NAME', '$PRODUCT_NAME', '$SUPPLIER', '$UNIT', '$NOTE', '$QUANTITY', '$ATTACHMENT')") or die(mysql_error());


windows xampp server is ok but centos7 php v7 error please help me

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: error with blank page

Post by pbottcher » 2020-06-14 08:26

Hi,

not sure if you use the mysql_connect explicitly because you have a need to do so.

If not you should rather use the built-in function sql and sqlvalue. This way you do not need to the database first.


you may try

Code: Select all

function G_R_N_USER_DATA_14_after_insert($data, $memberInfo, &$args){

$id = $data['id'];
$DATE = $data['DATE'];
$PROJECT_NAME = $data['PROJECT_NAME'];
$PRODUCT_NAME = $data['PRODUCT_NAME'];
$SUPPLIER = $data['SUPPLIER'];
$UNIT = $data['UNIT'];
$NOTE = $data['NOTE'];
$QUANTITY = $data['QUANTITY'];
$ATTACHMENT = $data['ATTACHMENT'];

sqlvalue( "INSERT INTO G_R_N (DATE, PROJECT_NAME, PRODUCT_NAME, SUPPLIER, UNIT, NOTE, QUANTITY, ATTACHMENT) VALUES ('$DATE', '$PROJECT_NAME', '$PRODUCT_NAME', '$SUPPLIER', '$UNIT', '$NOTE', '$QUANTITY', '$ATTACHMENT')");

sqlvalue( "INSERT INTO INVENTORY_1 (DATE, PROJECT_NAME, PRODUCT_NAME, SUPPLIER, UNIT, NOTE, QUANTITY, ATTACHMENT) VALUES ('$DATE', '$PROJECT_NAME', '$PRODUCT_NAME', '$SUPPLIER', '$UNIT', '$NOTE', '$QUANTITY', '$ATTACHMENT')");
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

Post Reply