php - crate data for mysql no longer works with no errors -
for reason create group on site no longer works. puzzle why don't work no more.
i thought code (which may be) , checked database there , connects fine no problems there.
i have error code display error none pops up. send email don't add mysql.
any idea thanks. have main file:
and in done file have following
any appreciate
please apply following code insert records tables
$result=true; // lets assume records inserted tables $sql = "insert groups values(null,'$email', '', '', '$category', '$about', '$name', '$dateofcreation','')"; if ($conn->query($sql)){ echo "</br>new record created in groups successfully"; } else{ $result=false; // couldnt insert groups. echo "</br>error inserting groups table"; } $sql = "insert grouppages values('$groupname', '$pagetext', '$pagename', '$dateofcreation')"; if ($conn->query($sql)){ echo "</br>new record created in grouppages successfully"; } else{ $result=false; // couldnt insert grouppages. echo "</br>error inserting grouppages table"; } $sql = "insert groupboards values('noreply@bumblebeechat.net', '$groupname', '$pagename', '$pagetext', '$dateofcreation')"; if ($conn->query($sql)){ echo "</br>new record created in groupboards successfully"; } else{ $result=false; // couldnt insert groupboards. echo "</br>error inserting groupboards table"; } $sql = "insert groupmembers values('noreply@zunkies.com', '$groupname', '$dateofcreation', 'member')"; if ($conn->query($sql)){ echo "</br>new record created in groupmembers successfully"; } else{ $result=false; // couldnt insert groupmembers. echo "</br>error inserting groupmembers table"; } // lets check if records inserted if($result) echo '</br>new record created successfully'; else echo '</br>error inserting records database';
Comments
Post a Comment