Reply to thread

Message

<blockquote data-quote="Detox" data-source="post: 426544" data-attributes="member: 596"><p>Hello Dev,</p><p>I have attempted to create a report tool and kinda works like I wanted but not fully working!</p><p>So when I go to report page, it will not throw off error that I'm requesting it to do. It will insert blank stuff into the database. But I need it to where you must fill out the forum and to agree to the terms.</p><p></p><p>[PHP]&lt;?php </p><p></p><p>if(isset($_POST['report_submit']))</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $report_id = mysql_real_escape_string($_POST['report_id']);</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $report_type = mysql_real_escape_string($_POST['report_type']);</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $report_info = mysql_real_escape_string($_POST['report_info']);</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $report_more = mysql_real_escape_string($_POST['report_more']);</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $report_staff = mysql_real_escape_string($_POST['report_staff']);</p><p></p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if((($report_type == &quot;Complaint against a member of staff&quot;) ||($report_type == &quot;Request a furni to be added or fixed&quot;) || ($report_type == &quot;Comment/Suggestion&quot;) || !empty($_POST['report_agree'])))</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysql_query(&quot;INSERT INTO `staff_report` (id,complaint,staff,explanation, moreinfo) VALUES ('&quot;.$report_id.&quot;','&quot;.$report_type.&quot;', '&quot;.$report_staff.&quot;' ,'&quot;.$report_info.&quot;', '&quot;.$report_more.&quot;')&quot;);</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;container&quot;&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;content&quot; style=&quot;position: relative&quot; class=&quot;clearfix&quot;&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;alert alert-info&quot; style=&quot;margin-bottom: 10px;width:570px;height:3%;&quot;&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;strong&gt;&lt;center&gt;We have successfully received your report!&lt;/strong&gt;&lt;/center&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;';</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; </p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;rounded rounded-red&quot;&gt;</p><p></p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Please Complete the forum!</p><p></p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;';</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; </p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; </p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </p><p>&lt;form method=&quot;post&quot; class=&quot;form&quot; name =&quot;report_submit&quot;&gt;</p><p>&lt;div class=&quot;form-group&quot;&gt;</p><p>&lt;label for=&quot;disabledTextInput&quot;&gt;&lt;b&gt;Please choose one of the following&lt;/b&gt;&lt;/label&gt;</p><p>&lt;div class=&quot;col-sm-10&quot;&gt;</p><p>&lt;select name=&quot;report_type&quot; class=&quot;form-control&quot;&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value=&quot;Complaint against a member of staff&quot;&gt;Complaint against a member of staff&lt;/option&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value=&quot;Request a furni to be added or fixed&quot;&gt;Request a furni to be added or fixed&lt;/option&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value=&quot;Comment/Suggestion&quot;&gt;Comment/Suggestion&lt;/option&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/select&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br/&gt;</p><p>&lt;div class=&quot;form-group&quot;&gt;</p><p>&lt;label for=&quot;disabledTextInput&quot;&gt;&lt;b&gt;Please choose a member of staff (If you are reporting/complimenting a staff member)&lt;/b&gt;&lt;/label&gt;</p><p>&lt;div class=&quot;col-sm-10&quot;&gt;</p><p>&lt;div class=&quot;col-sm-10&quot;&gt;</p><p>&lt;select name=&quot;report_staff&quot; class=&quot;form-control&quot;&gt;</p><p>&lt;option value=&quot;N/A&quot;&gt;N/A&lt;/option&gt;</p><p>&nbsp; &nbsp; &lt;option disabled&gt;-------------------------&lt;/option&gt;</p><p>&lt;?php</p><p>$getStaff = mysql_query(&quot;SELECT username FROM users WHERE rank &gt;= '3'&quot;);</p><p>&nbsp;while($staffUser = mysql_fetch_array($getStaff)){</p><p>&nbsp; &nbsp; echo'</p><p>&nbsp; &nbsp; &lt;option value=&quot;'. $staffUser['username'] .'&quot;&gt;'.$staffUser['username'].'&lt;/option&gt;';</p><p>}</p><p>?&gt;</p><p>&lt;/select&gt;</p><p>&lt;/div&gt;</p><p>&lt;/div&gt;</p><p>&lt;/div&gt;</p><p>&lt;br/&gt;</p><p>&lt;div class=&quot;form-group&quot;&gt;</p><p>&lt;label for=&quot;exampleInputEmail1&quot;&gt;&lt;b&gt;Please explain what you are reporting/suggesting or what is wrong with the furni you are asking to be fixed&lt;/b&gt;&lt;/label&gt;</p><p>&lt;div class=&quot;col-sm-10&quot;&gt;</p><p>&lt;textarea class=&quot;form-control&quot; rows=&quot;5&quot; name=&quot;report_info&quot; maxlength=&quot;255&quot; style=&quot;width:350px;height:75px;resize:none&quot;&gt;&lt;/textarea&gt;</p><p>&lt;/div&gt;</p><p>&lt;/div&gt;</p><p>&lt;br/&gt;</p><p>&lt;div class=&quot;form-group&quot;&gt;</p><p>&lt;label for=&quot;exampleInputEmail1&quot;&gt;&lt;b&gt;Would you like to add anything?&lt;/b&gt;&lt;br&gt;&lt;i&gt;Proof? Pictures of the furni, anything else you think is important?! Leave it here!&lt;/i&gt;&lt;/label&gt;</p><p>&lt;div class=&quot;col-sm-10&quot;&gt;</p><p>&lt;textarea class=&quot;form-control&quot; rows=&quot;3&quot; name=&quot;report_more&quot; maxlength=&quot;255&quot; class=&quot;ss-q-short&quot; style=&quot;width:350px;height:75px;resize:none&quot;&gt;&lt;/textarea&gt;</p><p>&lt;/div&gt;</p><p>&lt;/div&gt;</p><p>&lt;br/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; </p><p>&lt;div class=&quot;checkbox&quot;&gt;</p><p>&lt;label&gt;&lt;input name=&quot;report_agree&quot; value=&quot;0&quot; type=&quot;checkbox&quot;&gt;I am aware that if my report is spam, my account could be banned.&lt;/label&gt;</p><p>&lt;/div&gt;</p><p>&lt;br&gt;</p><p>&lt;input type=&quot;submit&quot; value=&quot;Submit&quot; name=&quot;report_submit&quot; class=&quot;submit&quot; style=&quot;float left&quot;&gt;</p><p>&lt;/form&gt;[/PHP]</p></blockquote><p></p>

[QUOTE="Detox, post: 426544, member: 596"] Hello Dev, I have attempted to create a report tool and kinda works like I wanted but not fully working! So when I go to report page, it will not throw off error that I'm requesting it to do. It will insert blank stuff into the database. But I need it to where you must fill out the forum and to agree to the terms. [PHP]<?php if(isset($_POST['report_submit'])) { $report_id = mysql_real_escape_string($_POST['report_id']); $report_type = mysql_real_escape_string($_POST['report_type']); $report_info = mysql_real_escape_string($_POST['report_info']); $report_more = mysql_real_escape_string($_POST['report_more']); $report_staff = mysql_real_escape_string($_POST['report_staff']); if((($report_type == "Complaint against a member of staff") ||($report_type == "Request a furni to be added or fixed") || ($report_type == "Comment/Suggestion") || !empty($_POST['report_agree']))) { mysql_query("INSERT INTO `staff_report` (id,complaint,staff,explanation, moreinfo) VALUES ('".$report_id."','".$report_type."', '".$report_staff."' ,'".$report_info."', '".$report_more."')"); echo ' <div id="container"> <div id="content" style="position: relative" class="clearfix"> <div class="alert alert-info" style="margin-bottom: 10px;width:570px;height:3%;"> <strong><center>We have successfully received your report!</strong></center></div></div></div>'; } else { echo ' <div class="rounded rounded-red"> Please Complete the forum! </div>'; } } ?> <form method="post" class="form" name ="report_submit"> <div class="form-group"> <label for="disabledTextInput"><b>Please choose one of the following</b></label> <div class="col-sm-10"> <select name="report_type" class="form-control"> <option value="Complaint against a member of staff">Complaint against a member of staff</option> <option value="Request a furni to be added or fixed">Request a furni to be added or fixed</option> <option value="Comment/Suggestion">Comment/Suggestion</option> </select> </div> </div> <br/> <div class="form-group"> <label for="disabledTextInput"><b>Please choose a member of staff (If you are reporting/complimenting a staff member)</b></label> <div class="col-sm-10"> <div class="col-sm-10"> <select name="report_staff" class="form-control"> <option value="N/A">N/A</option> <option disabled>-------------------------</option> <?php $getStaff = mysql_query("SELECT username FROM users WHERE rank >= '3'"); while($staffUser = mysql_fetch_array($getStaff)){ echo' <option value="'. $staffUser['username'] .'">'.$staffUser['username'].'</option>'; } ?> </select> </div> </div> </div> <br/> <div class="form-group"> <label for="exampleInputEmail1"><b>Please explain what you are reporting/suggesting or what is wrong with the furni you are asking to be fixed</b></label> <div class="col-sm-10"> <textarea class="form-control" rows="5" name="report_info" maxlength="255" style="width:350px;height:75px;resize:none"></textarea> </div> </div> <br/> <div class="form-group"> <label for="exampleInputEmail1"><b>Would you like to add anything?</b><br><i>Proof? Pictures of the furni, anything else you think is important?! Leave it here!</i></label> <div class="col-sm-10"> <textarea class="form-control" rows="3" name="report_more" maxlength="255" class="ss-q-short" style="width:350px;height:75px;resize:none"></textarea> </div> </div> <br/> <div class="checkbox"> <label><input name="report_agree" value="0" type="checkbox">I am aware that if my report is spam, my account could be banned.</label> </div> <br> <input type="submit" value="Submit" name="report_submit" class="submit" style="float left"> </form>[/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members