Reply to thread

Message

<blockquote data-quote="brsy" data-source="post: 90615" data-attributes="member: 2912">I found a quick error just by glancing at the code. For one, if you want to redirect a user to a specific page, it's[PHP]header(&quot;Location: me&quot;);// the following is not valid PHP to the extent of my knowledge:Redirect(&quot;me&quot;);[/PHP]&nbsp;Please wait about 5 minutes while I fix everything within the code, and make it more efficient. Do not use the code in the first post, as it will throw errors like a mofo.&nbsp;----------EDIT----------Here is the corrected code, something might be wrong, as I deleted loads of shit that I thought were useless. I am also watching a basketball game, so that increases the chances of this being fucked up. If there is an error, just let me know the error and I'll correct it. Like my post if I helped <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" />[PHP]&lt;?php$fetch_tags = mysql_query(&quot;SELECT tag,id FROM user_tags WHERE user_id = '&quot;.$_SESSION['user']['id'].&quot;' ORDER BY DESC LIMIT 20&quot;) or die(mysql_error());$tags_num = mysql_num_rows($fetch_tags);&nbsp;&nbsp; &nbsp; $randomq[] = &quot;What is your favourite food?&quot;;&nbsp; &nbsp; $randomq[] = &quot;Who is your favourite actor?&quot;;&nbsp; &nbsp; $randomq[] = &quot;What kind of music do you like?&quot;;&nbsp; &nbsp; $randomq[] = &quot;What is your favourite sport?&quot;;&nbsp; &nbsp; $randomq[] = &quot;Who is your favourite actress?&quot;;&nbsp; &nbsp; $randomq[] = &quot;What is your favourite colour?&quot;;&nbsp; &nbsp; $randomq[] = &quot;What is your favourite band?&quot;;&nbsp; &nbsp; $randomq[] = &quot;What is your favourite TV show?&quot;;&nbsp; &nbsp; $randomq[] = &quot;Which football team do you support?&quot;;&nbsp; &nbsp; $randomq[] = &quot;What is your favourite football team?&quot;;&nbsp; &nbsp; $randomq[] = &quot;Your favourite cartoon?&quot;;&nbsp; &nbsp; $randomq[] = &quot;What is your favourite video game?&quot;;&nbsp; &nbsp; $randomq[] = &quot;What's your favourite pastime?&quot;;&nbsp; &nbsp; $randomq[] = &quot;What kind of mood are you in right now?&quot;;&nbsp; &nbsp; $randomq[] = &quot;What is your favourite movie?&quot;;&nbsp; &nbsp; $randomq[] = &quot;What is your favourite time of year?&quot;;&nbsp;$chosen = rand(0,count($randomq)-1);&nbsp;&nbsp; &nbsp; $do = $_GET['do'];&nbsp; &nbsp; if($do != &quot;&quot;) {&nbsp; &nbsp; mysql_query(&quot;DELETE FROM user_tags WHERE id = '&quot;.$do.&quot;'&quot;);&nbsp; &nbsp; header(&quot;Location: me&quot;);&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; if(isset($_POST['newtag'])) {&nbsp; &nbsp; &nbsp; &nbsp; $tag = mysql_real_escape_strings(htmlspecialchars($_POST[newtag]));&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; if(strlen($_SESSION['user']['id']) &lt; 1 || strlen($tag) &lt; 1) {&nbsp; &nbsp; &nbsp; &nbsp; header(&quot;Location: me&quot;);&nbsp; &nbsp; }&nbsp; &nbsp; else {&nbsp; &nbsp; &nbsp; &nbsp; mysql_query(&quot;INSERT INTO user_tags (user_id, tag) VALUES ('&quot; . $_SESSION['user']['id'] . &quot;', '&quot; . $tag . &quot;')&quot;);&nbsp; &nbsp; &nbsp; &nbsp; header(&quot;Location: me&quot;);&nbsp; &nbsp; }&nbsp; &nbsp; ?&gt;[/PHP]</blockquote>

[QUOTE="brsy, post: 90615, member: 2912"] I found a quick error just by glancing at the code. For one, if you want to redirect a user to a specific page, it's [PHP]header("Location: me"); // the following is not valid PHP to the extent of my knowledge: Redirect("me");[/PHP] Please wait about 5 minutes while I fix everything within the code, and make it more efficient. Do not use the code in the first post, as it will throw errors like a mofo. ----------EDIT---------- Here is the corrected code, something might be wrong, as I deleted loads of shit that I thought were useless. I am also watching a basketball game, so that increases the chances of this being fucked up. If there is an error, just let me know the error and I'll correct it. Like my post if I helped :) [PHP]<?php $fetch_tags = mysql_query("SELECT tag,id FROM user_tags WHERE user_id = '".$_SESSION['user']['id']."' ORDER BY DESC LIMIT 20") or die(mysql_error()); $tags_num = mysql_num_rows($fetch_tags); $randomq[] = "What is your favourite food?"; $randomq[] = "Who is your favourite actor?"; $randomq[] = "What kind of music do you like?"; $randomq[] = "What is your favourite sport?"; $randomq[] = "Who is your favourite actress?"; $randomq[] = "What is your favourite colour?"; $randomq[] = "What is your favourite band?"; $randomq[] = "What is your favourite TV show?"; $randomq[] = "Which football team do you support?"; $randomq[] = "What is your favourite football team?"; $randomq[] = "Your favourite cartoon?"; $randomq[] = "What is your favourite video game?"; $randomq[] = "What's your favourite pastime?"; $randomq[] = "What kind of mood are you in right now?"; $randomq[] = "What is your favourite movie?"; $randomq[] = "What is your favourite time of year?"; $chosen = rand(0,count($randomq)-1); $do = $_GET['do']; if($do != "") { mysql_query("DELETE FROM user_tags WHERE id = '".$do."'"); header("Location: me"); } if(isset($_POST['newtag'])) { $tag = mysql_real_escape_strings(htmlspecialchars($_POST[newtag])); } if(strlen($_SESSION['user']['id']) < 1 || strlen($tag) < 1) { header("Location: me"); } else { mysql_query("INSERT INTO user_tags (user_id, tag) VALUES ('" . $_SESSION['user']['id'] . "', '" . $tag . "')"); header("Location: me"); } ?>[/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members