Tuscanbot

Thank you JOSH! Yes I did search in google for question 1 and 5, but I want to double check. once again, thank you!

Hi guys, I am trying to understand these questions regarding function and how or where can i get some knowledge to understand and create the code. questions are: 1. Open the text file “status.txt” as read only using variable $handle to store the file handle. 2. Begin a session. (what does it mean begin session? does it mean start using the if condition?) 3. Return the number of elements in array $days. 4. Convert an array $data with five elements into a string that is delimited by tab. (what does it mean by delimited by tab?) 5. Check if the form text item "status" obtained via get method is empty. Thank you in advance!

Hi guys, I am struggling why I received the error, my apology, I am fairly new using php and mysql Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in line 64 the code is the $countArr = mysqli_fetch_row($countResult2); Warning: Invalid argument supplied for foreach() The code is the foreach($fetchArr2 as $value) Anyone understood why it is like this? if so, could you please kindly explain. thanks, greatly appreciated! below is the code: <?php////////////////////////////////////// session_start(); require_once('sqlconnect.inc.php'); ///////////////////////////////////// $memberHid1 = $_POST['memberHid1']; $new_session = $_POST['memberHid']; //connecting to the database $conn = @mysqli_connect($host, $user, $pswd, $dbnm); if (!$conn) { echo "<p>Database connection failure</p>"; } else { @mysqli_select_db($conn, $dbnm) or die ("Database not available"); } $query = "SELECT member_id FROM team WHERE member_name = '$memberHid1'"; $queryResult = @mysqli_query($conn, $query) or die ("<p>Unable to execute query.</p>". "<p>Error code:" . mysqli_errno($conn) .":" . mysqli_error($conn)); $fetchArr = mysqli_fetch_row($queryResult); $memberHid3 = $fetchArr[0]; $memberHid = $_SESSION['membername'] = $new_session; $query2 = "SELECT member_id FROM team WHERE member_name = '$memberHid'"; $queryResult2 = @mysqli_query($conn,$query2) or die ("<p>Unable to execute query.</p>". "<p>Error code" . mysqli_errno($conn) .":" . mysqli_error($conn)); $fetchArr2 = mysqli_fetch_row($queryResult2); $memberHid4 = $fetchArr2[0]; $query3 = "INSERT INTO myteam VALUES($memberHid4, $memberHid3)"; $queryResult3 = @mysqli_query($conn,$query3) or die ("<p>Unable to execute query.</p>". "<p>Error code" . mysqli_errno($conn) .":" . mysqli_error($conn))."</p>"; echo "<p>$memberHid1"." "." Successfully added</p>"; $queryCount = "SELECT COUNT(*) FROM team"; $countResult = @mysqli_query($conn,$queryCount); $fetchCountArr = mysqli_fetch_row($countResult); for($n=0;$n<$fetchCountArr[0];$n++) { $pst = $n+1; $query4 = "SELECT member_id2 FROM myteam WHERE friend_id1 = '$pst'"; $countResult2 = @mysqli_query($conn,$query4); $countArr = mysqli_fetch_row($countResult2); $a=0; while($countArr) { $a++; $countArr = mysqli_fetch_row($countResult2); //echo "<p>$a</p>"; } $query4 = "UPDATE team SET num_of_members= '$a' WHERE member_id = '$pst'"; $countResult2 = @mysqli_query($conn,$query4); } $querySelect = "SELECT member_id2 FROM myteam WHERE member_id1 = '$memberHid4'"; $querySelectResult = @mysqli_query($conn, $querySelect); $fetchArr = mysqli_fetch_row($querySelectResult); while($fetchArr) { foreach($fetchArr as $value) { //echo $value; $querySelect2 = "SELECT member_name FROM friends where friend_id='$value'"; $querySelectResult2 = @mysqli_query($conn, $querySelectResult2); $fetchArr2 = mysqli_fetch_row($querySelectResult2); foreach($fetchArr2 as $value) { //echo $value; } } $fetchArr = mysqli_fetch_row($querySelectResult); } ; ?>

Thanks Mac_Gyer, how could i not notice that , thanks once again

@mac_gyver is there a way to show all the table name via php? as for the actual table it shouldnt have white space. As far I remember, ive created two tables, one is called 'team' and one is called 'myteam'.

Hi guys, I've encountered strange issue, my memberadd, log in, registration and others works fine however for the memberaddprocess file, it says the table doesn't exist. It says Unable to execute query. Error code1146:Table '******_db.member' doesn't exist This is really weird, does anyone ever encounter this? bellow is my code for memberadd and the one after is the memberaddprocess which it says that it doesn't found the table. <?php session_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/chtml-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en" > <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <meta name="description" content="Web Programming :: Assignment 2" /> <meta name="Keywords" content="Web, programming" /> <title>Member Login</title> </head> <body> <h1>My Member System</h1> </body> </html> <?php require_once('sqlconnect.inc.php'); if(isset($_SESSION['membername'] )) { echo "<p>Add Member Page". "<br />".$_SESSION['membername']."</p>"; $conn = @mysqli_connect($host, $user, $pswd, $dbnm); if (!$conn) { echo "<p>Database connection failure</p>"; } else { @mysqli_select_db($conn, $dbnm) or die ("Database not available"); } $memberHid = $_SESSION['membername']; $query = "SELECT member_name FROM team"; $result = mysqli_query($conn, $query); if(!$result) { echo "<p>Query failed to execute, Error with: ", $query, "</p>"; } $queryFetch = mysqli_fetch_row($result); //echo "<p> $queryResult1</p>"; $m=0; while($queryFetch) { $mQueryFetch[$m] = $queryFetch[0]; $queryFetch = mysqli_fetch_row($result); $m++; } $i=0; $query2 = "SELECT member_id FROM team WHERE member_name='$memberHid'"; $result2 = @mysqli_query($conn, $query2); $queryFetchResult = mysqli_fetch_row($result); $memId = $queryFetchResult[0]; $query3 = "SELECT COUNT(*) FROM myteam WHERE member_id1 = '$memId'"; //query for counting the no of friends $resultSelect = @mysqli_query($conn,$query3) or die ("<p>Query failed to execute.</p>". "<p>Error with:" . mysqli_errno($conn) .":" . mysqli_error($conn))."</p>"; $arCount = mysqli_fetch_row($resultSelect); echo "<p>Number of Current team member is"." ". $arCount[0]." "."</p>"; $querySelect = "SELECT member_id2 FROM myteam WHERE member_id1 = '$memId'"; $resultSelect2 = @mysqli_query($conn, $querySelect); $memArr = mysqli_fetch_row($resultSelect2); if($memArr) { while($memArr) { foreach($memArr as $value) { $querySelect3 = "SELECT member_name FROM team WHERE member_id = '$value'"; $queryResult = @mysqli_query($conn,$querySelect3); $fetchArr = mysqli_fetch_row($queryResult); foreach($fetchArr as $value) { $newDat[$a] = $value; $a++; } } $memArr = mysqli_fetch_row($resultSelect2); } $curLog = array_diff($mQueryFetch, $newDat); //for displaying profile names without the currently logged in user and his old friends profile names $querySelect2 = "SELECT member_name FROM team"; $querySelectResult = @mysqli_query($conn,$querySelect2) or die ("<p>Query Failed to Execute.</p>". "<p>Error with" . mysqli_errno($conn) .":" . mysqli_error($conn))."</p>"; echo "<table width='20%' border='1'>"; echo "<tr><th>Member Name</th>"; echo "<th>Status</th></tr>"; $fetchArray = mysqli_fetch_row($querySelectResult); foreach($diff as $value) { if($value!=$_SESSION['membername']) { echo "<tr><td>{$value}</td>"; $memberHid1 = $value; $memberHid = $_SESSION['membername']; echo "<td>"?> <form action ="memberaddprocess.php" method = "post" > <?php echo'<input type="hidden" name="memberHid1" value="'.htmlspecialchars($memberHid1).'" />';?> <?php echo'<input type="hidden" name="memberHid" value="'.htmlspecialchars($memberHid).'" />';?> <p><input type="submit" name="Addmember" value="AddMember" /></p> </form> <?php "</td></tr>"; } $fetchArray = mysqli_fetch_row($querySelectResult); } echo"</table>"; } else { $n=0; $querySelect2 = "SELECT member_name FROM team"; $querySelectResult = @mysqli_query($conn, $querySelect2) or die ("<p>Query Failed to Execute.</p>". "<p>Error with" . mysqli_errno($conn) .":" . mysqli_error($conn))."</p>"; $fetchArray = mysqli_fetch_row($querySelectResult); while($fetchArray) { if($fetchArray[0] != $_SESSION['membername']) { $name[$n] = $fetchArray[0]; $n++; } $fetchArray = mysqli_fetch_row($querySelectResult); } sort($name); echo "<table width='20%' border='1'>"; echo "<tr><th>Member Name</th>"; echo "<th>Status</th></tr>"; for($n = 0; $n<sizeof($name); $n++) { $memberHid1 = $name[$n]; $memberHid = $_SESSION['membername']; echo "<tr><td>{$memberHid1}</td>"; echo "<td>"?> <form action ="memberaddprocess.php" method = "post" > <?php echo'<input type="hidden" name="memberHid1" value="'.htmlspecialchars($memberHid1).'" />';?> <?php echo'<input type="hidden" name="memberHid" value="'.htmlspecialchars($memberHid).'" />';?> <p><input type="submit" name="Addmember"value="AddMember" /></p> </form> <?php "</td></tr>"; } echo "</table>"; } echo"<p><a href='memberlist.php'>List members</a></p>"; echo"<p><a href='logout.php'>Log out</a></p>"; } else { echo "<p> Connection timeout!</p>"; echo"<p><a href='login.php'>Log in</a></p></div>"; } ?> memberaddprocess code <?php ////////////////////////////////////// session_start(); require_once('sqlconnect.inc.php'); ///////////////////////////////////// $memberHid1 = $_POST['memberHid1']; //profilename of the friend whose corresponding button was clicked $new_session = $_POST['memberHid']; //profilename of the currently logged in user $conn = @mysqli_connect($host, $user, $pswd, $dbnm); if (!$conn) { echo "<p>Database connection failure</p>"; } else { @mysqli_select_db($conn, $dbnm) or die ("Database not available"); } $query = "SELECT member_id FROM team WHERE member_name = '$memberHid1'"; $queryResult = @mysqli_query($conn, $query) or die ("<p>Unable to execute query.</p>". "<p>Error code:" . mysqli_errno($conn) .":" . mysqli_error($conn)); $fetchArr = mysqli_fetch_row($queryResult); $memberHid3 = $fetchArr[0]; $memberHid = $_SESSION['membername'] = $new_session; $query2 = "SELECT member_id FROM member WHERE member_name = '$memberHid'"; $queryResult2 = @mysqli_query($conn,$query2) or die ("<p>Unable to execute query.</p>". "<p>Error code" . mysqli_errno($conn) .":" . mysqli_error($conn)); $fetchArr2 = mysqli_fetch_row($queryResult2); $memberHid4 = $fetchArr2[0]; $query3 = "INSERT INTO myteam VALUES($memberHid4, $memberHid3)"; $queryResult3 = @mysqli_query($conn,$query3) or die ("<p>Unable to execute query.</p>". "<p>Error code" . mysqli_errno($conn) .":" . mysqli_error($conn))."</p>"; echo "<p>$memberHid1"." "." Successfully added</p>"; $queryCount = "SELECT COUNT(*) FROM team"; $countResult = @mysqli_query($conn,$queryCount); $fetchCountArr = mysqli_fetch_row($countResult); for($n=0;$n<$fetchCountArr[0];$n++) { $pst = $n+1; $query4 = "SELECT member_id2 FROM myteam WHERE friend_id1 = '$pst'"; $countResult2 = @mysqli_query($conn,$query4); $countArr = mysqli_fetch_row($countResult2); $a=0; while($countArr) { $a++; $countArr = mysqli_fetch_row($countResult2); //echo "<p>$a</p>"; } $query4 = "UPDATE team SET num_of_members= '$a' WHERE member_id = '$pst'"; $countResult2 = @mysqli_query($conn,$query4); } $querySelect = "SELECT member_id2 FROM myteam WHERE member_id1 = '$memberHid4'"; $querySelectResult = @mysqli_query($conn, $querySelect); $fetchArr = mysqli_fetch_row($querySelectResult); while($fetchArr) { foreach($fetchArr as $value) { //echo $value; $querySelect2 = "SELECT member_name FROM friends where friend_id='$value'"; $querySelectResult2 = @mysqli_query($conn, $querySelectResult2); $fetchArr2 = mysqli_fetch_row($querySelectResult2); foreach($fetchArr2 as $value) { //echo $value; } } $fetchArr = mysqli_fetch_row($querySelectResult); } header("Location:memberadd.php"); echo('<a href="memberlist.php">Updated memberlist</a></p></div>'); //header('Location: friendadd.php'); ?>

Hi guys, I am trying to create registration form and record the registration to the database, however, I have problem with the part for the 'member name' validation. I try to register myself properly and there shouldn't be an error however it say "Member name must contain only letters, space and hypen". It shouldn't as i put the member name properly, maybe I did something wrong with the validation and especially the regex? My apology for my bad English. <?phpsession_start(); require_once('sqlconnect.inc.php'); session_start(); if (isset($_POST["Register"])) { $email = $_POST['email']; $memberName = $_POST['membername']; $passw = $_POST['password']; $conPassw = $_POST['conpassword']; if($email=='') { echo "<p>Please enter the Email address</p>"; echo "<a href=\"signup.php\">Back to Registration Page!</a>"; exit(); } if($memberName=='') { echo "<p>Please enter the Member Name</p>"; echo "<a href=\"signup.php\">Back to Registration Page!</a>"; exit(); } if($passw=='') { echo "<p>Please enter Password</p>"; echo "<a href=\"signup.php\">Back to Registration Page!</a>"; exit(); } if($conPassw=='') { echo "<p>Please enter Confirm Password</p>"; echo "<a href=\"signup.php\">Back to Registration Page!</a>"; exit(); } else { if (!filter_var($email, FILTER_VALIDATE_EMAIL)) { echo "Invalid email address"; } else{ $_SESSION['name'] = $_POST['membername']; $pattern1 = '/^[a-z-]+$/'; if (preg_match($pattern1, $memberName)) { echo "<p>Member name must contain only letters, space and hypen</p>"; } else{ $pattern2 = '^[a-zA-Z0-9]+$'; if (preg_match($pattern2, $passw)) { echo "<p>Password must only contain numbers and letters!</p>"; } else{ if($passw<>$conPassw) { echo "<p>Passwords does not match!</p>"; $passw=""; $conPassw=""; } else{ $conn = @mysqli_connect($host, $user, $pswd, $dbnm); if (!$conn) die ("<p>Couldn't connect to the server!<p>"); $SelectDatabase = @mysqli_select_db($conn,"s7259476_db") or die("<p>The database is not available.</p>"); $insertDatabase = "INSERT INTO team VALUES('NULL','$email','$password','$memberName',CURDATE(),0)"; $queryResult = @mysqli_query($conn, $insertDatabase) or die ("<p>Email already exists.Please enter another email id</p>"); echo"<p>Data entered into friends table successfully</p>"; echo "<p>Welcome"." ".$_SESSION['name']."</p>"; } } } } } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/chtml-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en" > <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <meta name="description" content="Web Programming :: Assignment 2" /> <meta name="Keywords" content="Web, programming" /> <title>Register Page</title> </head> <body> <form id='register' action='signup.php' method='POST'> <fieldset > <legend><h1>My Team System Registration Page</h1></legend> <?php $email = isset($_POST['email']) ? filter_var($_POST['email'], FILTER_SANITIZE_STRING) : ''; ?> <?php $memberName = isset($_POST['membername']) ? filter_var($_POST['membername'], FILTER_SANITIZE_STRING) : ''; ?> <div class="elements"> <label for='email' >Email:</label> <input type='text' name='email' id='email' maxlength="50" value="<?php echo $email; ?>" /> </div> <br /> <div class="elements"> <label for='membername' >Member Name:</label> <input type='text' name='membername' id='membername' maxlength="50" value="<?php echo $memberName; ?>" /> </div> <br /> <div class="elements"> <label for='password' >Password:</label> <input type='password' name='password' id='password' maxlength="50" /> </div> <br /> <div class="elements"> <label for='conpassword' >Confirm Password:</label> <input type='password' name='conpassword' id='conpassword' maxlength="50" /> </div> <br /> <div class="submit"> <input type='submit' name='Register' value='Register' /> <input type='reset' name='Submit' value='Clear' /> <br /> <div class="elements"> <a href="index.php">Home</a> </fieldset> </form> </body> </html>