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
error with blank page
Re: error with blank page
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
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.