Gotharious
-
Posts
159 -
Joined
-
Last visited
Everything posted by Gotharious
-
Ok, stupid question but happens often Do you change your mysql connection configuration when you use them in a live environment? cause I've seen lots of people forget that
-
If [form validated] submit Form1 ELSE submit Form2?
Gotharious replied to jonnewbie12's topic in PHP Coding Help
If I get what you mean, that you want to head the user to another form once the first form is validated you can use header('location:form2.php'); -
what do you mean by "don't think sessions work any longer"? you need to add session_start() at every page you use the sessions in
-
I think you should read this post, he had a different problem, but you can find in his code how to validate if a field was left empty in the form (I think that's what you mean) http://www.phpfreaks.com/forums/index.php?topic=347299.0
-
and I think you should follow Pikachu's advice... this guy is GOOD, he's like solving all my problems
-
Help with Downline, shows parent but not child
Gotharious replied to Gotharious's topic in PHP Coding Help
ok can you elaborate a bit? -
No, you don't need to
-
Help with Downline, shows parent but not child
Gotharious replied to Gotharious's topic in PHP Coding Help
thanks, mate I've posted a different code in my previous reply that doesn't have that kind of nested functions, but it gives me a weird output -
where exactly did you declare $character?
-
what I meant is, after you posted to add_player.php you're using the variables $name $password1 and $password2 which are not defined, you have to set them to the right $_POST[''] so when you use them in your query, it's known that password1 is the password the user entered in the form that has the name "password1"
-
You haven't defined the name and password variables Add this before the query $password1 = $_POST['password1']; $password2 = $_POST['password2']; $name = $_POST['name'];
-
Help with Downline, shows parent but not child
Gotharious replied to Gotharious's topic in PHP Coding Help
Ok, I've tried another thing now, a code posted by someone on the internet, everyone says it's working and seen screenshots of people who used it and it's great. the problem now, is that when I try to view the page, it only gives me "40" as a result, no trees, nothing I'm posting the code below for the php tree2.php <!DOCTYPE html> <html> <head> <title>Tree-view Test</title> <meta http-equiv="Content-Type" content="text/html; charset=utf8"> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script> <script type="text/javascript" src="TreeView.js"></script> <script type="text/javascript"> // Have the TreeView.drawAll method executed as soon as the DOM is ready. $(document).ready(function(){ TreeView.drawAll(); }); </script> </head> <body> <?php // Fetch the TreeView class from the other file. include("class.TreeView.php"); // Open a database connection // TODO: Replace the info here with your real info. $dbLink = new mysqli("localhost", "user", "password", "database"); // Create an instance of the TreeView class. $treeView = new TreeView($dbLink); // Print the tree view // TODO: Insert your real table name here. $treeView->printTree('users'); $dbLink->close(); ?> </body> </html> class.TreeView.php <?php /** * Handles creating and/or printing a Tree-Like HTML output, complete with * all necessary CSS styles. * * Assumes a MySQL database table structure like so: * CREATE TABLE `name` ( * `id` int(11) NOT NULL AUTO_INCREMENT, * `parentID` int(11) DEFAULT NULL, * PRIMARY KEY (`id`) * ); * * Public methods: * createTree - Returns the HTML tree-view. * printTree - Prints the HTML tree-view. * * Private methods * fetchTree - Reads the complete tree structure into an array. * buildHtml - Builds the HTML div hierarchy based. */ class TreeView { private $bgColor = ""; //"background-color: rgba(0, 100, 0, 0.10); "; private $dbLink; private $tblName; /** * Default constructor * @param mysqli $dbLink A open MySQL (mysqli) connection. * @throws Exception */ public function __construct(mysqli $dbLink) { if($dbLink != null && $dbLink->connect_errno == 0) { $this->dbLink = $dbLink; // This number is added the the container DIV ID, so that we can // tell the DIVs a part if there are more than one view created. if(!isset($GLOBALS['TreeView_DivID'])) { $GLOBALS['TreeView_DivID'] = 0; } } else { throw new Exception("The mysqli object provided is invalid."); } } /** * Creates a descending tree-like view of the tree-structure in the given * database table and returns it as a string. * @param <type> $tblName The name of the database table to use. * @return <string> The string output. * @throws Exception */ public function createTree($tblName) { if(!isset($tblName) || empty($tblName)) { throw new Exception("Failed to create the tree. Table or database information is invalid"); } else { // Set up variables $this->tblName = $tblName; $treeData = array(); $output = ""; // Create the output $this->fetchTree($treeData); // Set up the CSS styles, and create the container DIV. $divID = "TreeView_ContainerDiv_" . $GLOBALS['TreeView_DivID']; $output = <<<HTML <style type="text/css"> div#{$divID} { margin: 0; padding: 0; text-align: center; } div#{$divID} div { margin: 0; padding: 0 10px; float: left; {$this->bgColor}} div#{$divID} p { margin: 0; padding: 0; margin-bottom: 10px; } </style> <div id="{$divID}"> HTML; // Add the DIV hierachy. $this->buildHtml($treeData, $output); // Add the JavaScript call to start drawing the lines $rootID = array_keys($treeData); $rootID = $rootID[0]; $output .= <<<HTML <script type="text/javascript"> TreeView.addTree('Tree{$GLOBALS['TreeView_DivID']}_{$rootID}'); </script> HTML; // Increment the DIV ID number $GLOBALS['TreeView_DivID']++; return $output; } } /** * Prints a descending tree-like view of the tree-structure in the given * database table. * @param <type> $tblName The name of the database table to use. * @throws Exception */ public function printTree($tblName) { echo $this->createTree($tblName); } /** * A recursive function that fetches a tree-structure from a database into an array. * @global <mysqli> $dbLink A open MySQLI connection. * @param <number> $parentID The ID the current recursion uses as a root. */ private function fetchTree(&$parentArray, $parentID=null) { global $dbLink; // Create the query if($parentID == null) { $parentID = 0; } $sql = "SELECT `id` FROM `{$this->tblName}` WHERE `recruiteris`= ". intval($parentID); // Execute the query and go through the results. $result = $dbLink->query($sql); if($result) { while($row = $result->fetch_assoc()) { // Create a child array for the current ID $currentID = $row['id']; $parentArray[$currentID] = array(); // Print all children of the current ID $this->fetchTree($parentArray[$currentID], $currentID); } $result->close(); } else { die("Failed to execute query! ($level / $parentID)"); } } /** * Builds a HTML <div> hierarchy from the tree-view data. * Each parent is encased in a <div> with all their child nodes, and each * of the children are also encased in a <div> with their children. * @param <array> $data The tree-view data from the fetchTree method. * @param <string> $output The <div> hierachy. */ private function buildHtml($data, &$output) { // Add the DIV hierarchy. foreach($data as $_id => $_children) { $output .= "<div id=\"Tree{$GLOBALS['TreeView_DivID']}_{$_id}\"><p>{$_id}</p>"; $this->buildHtml($_children, $output); $output .= "</div>"; } } } ?> TreeView.js /** * Handles drawing lines between the tree structures generated by PHP. */ var TreeView = { /** Constants (sort of) **/ LINE_MARGIN : 10, // px BORDER_STYLE : "solid 1px #555555", /** A list of root elements to draw when the window is loaded. */ trees : [], /** * Adds a tree to the list of trees to be drawn. * @param rootID The ID of the root element of the tree. */ addTree : function(rootID) { this.trees.push(rootID); }, /** * Loops through all the trees and executes the drawing function for each of them. */ drawAll : function() { for(var x = 0; x < this.trees.length; x++) { var root = $("#" + this.trees[x]); if(root.length > 0) { this.drawTree(root); } } }, /** * Recursively draws all lines between all root-child elements in the given tree. * @param root The root element of the tree to be drawn. */ drawTree : function(root) { root = $(root); if(root.length > 0) { var children = root.children('div'); for(var i = 0; i < children.length; i++) { this.drawLine(root, children[i]); this.drawTree(children[i]); } } }, /** * Draws a line between the two passed elements. * Uses an absolutely positioned <div> element with the borders as the lines. * @param elem1 The first element * @param elem2 The second element */ drawLine : function(elem1, elem2) { // Use the <p> element as the base. Otherwise the height() call on the // <div> will return the entire hight of the tree, including the children. elem1 = $(elem1).find("p").eq(0); elem2 = $(elem2).find("p").eq(0); var e1_pos = $(elem1).position(); var e2_pos = $(elem2).position(); var borders = { top:true, left:true, right:false, bottom:false }; // Move the position to the center of the element e1_pos.left += ($(elem1).width() / 2); e1_pos.top += ($(elem1).height() / 2); e2_pos.left += ($(elem2).width() / 2); e2_pos.top += ($(elem2).height() / 2); // Position if they are horizontally aligned. if(e1_pos.left == e2_pos.left) { borders.top = false; if(e1_pos.top < e2_pos.top) { e1_pos.top += ($(elem1).height() / 2); e2_pos.top -= ($(elem2).height() / 2); } else { e1_pos.top -= ($(elem1).height() / 2); e2_pos.top += ($(elem2).height() / 2); } } // Position if they are verticaly aligned. else if(e1_pos.top == e2_pos.top) { borders.left = false; e1_pos.top += ($(elem1).height() / 2); e2_pos.top += ($(elem2).height() / 2); if(e1_pos.left < e2_pos.left) { e1_pos.left += $(elem1).width(); } else { e2_pos.top += $(elem2).height(); } } // Position if the elements are not aligned. else { if(e1_pos.left < e2_pos.left) { borders.right = true; borders.left = false; } if(e1_pos.top > e2_pos.top) { borders.bottom = true; borders.top = false; } } // Calculate the overlay position and size var over_position = { left:(e1_pos.left < e2_pos.left ? e1_pos.left : e2_pos.left), top:(e1_pos.top < e2_pos.top ? e1_pos.top : e2_pos.top) }; var over_size = { width:Math.abs(e1_pos.left - e2_pos.left), height:Math.abs(e1_pos.top - e2_pos.top) } // Create the overlay div var raw_overlay = document.createElement('div'); var overlay = $(raw_overlay); // Add the borders, and create a margin for the lines so they are not // drawn "into" the numbers. if(borders.top) { overlay.css('border-top', this.BORDER_STYLE); over_size.height -= this.LINE_MARGIN; } if(borders.bottom) { overlay.css('border-bottom', this.BORDER_STYLE); over_position.top += this.LINE_MARGIN; over_size.height -= this.LINE_MARGIN; } if(borders.left) { overlay.css('border-left', this.BORDER_STYLE); over_size.width -= this.LINE_MARGIN; } if(borders.right) { overlay.css('border-right', this.BORDER_STYLE); over_position.left += this.LINE_MARGIN; over_size.width -= this.LINE_MARGIN; } overlay.css('position', 'absolute'); overlay.css('top', over_position.top); overlay.css('left', over_position.left); overlay.css('width', over_size.width); overlay.css('height', over_size.height); document.body.appendChild(overlay.get(0)); } } Now my recruiter ID in the database is recruiteris and the user ID is id -
Help with Downline, shows parent but not child
Gotharious replied to Gotharious's topic in PHP Coding Help
I don't think I get what you mean by "form a query string......." would you kindly give an example? about nesting, it was suggested by thrope that I use nested sets and that's all the info I found about it online that suits what I'm trying to do tho -
Help with Downline, shows parent but not child
Gotharious replied to Gotharious's topic in PHP Coding Help
Ok, I've tried a different code, but there is a problem now it gives me a warning Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/waw-eg.com/admin/tree2.php on line 58 the code is <?php include("config.php"); //my database connection is set in my config, otherwise, just create your own db connect $defaultmcode = 'yourdefaultidhere'; if($_GET['topmcode']){ $topmcode = trim($_GET['topmcode']); }else{ $topmcode = $defaultmcode; } $topmcode = ltrim($topmcode); $topmcode = rtrim($topmcode); $topmcode = strtoupper($topmcode); //my memberid are alphanumerics and all caps so I had to conver all to upper case, else, comment the above strtoupper call //get Downline of a Member, this function is needed so that you can simply call left or right of the memberid you are looking for function GetDownline($member_id,$direction) { $getdownlinesql = @mysql_fetch_assoc(@mysql_query('select id,recruiteris,position from `users` where recruiteris="'.$member_id.'" and position="'.$direction.'"')); $getdownline = $getdownlinesql['id']; return $getdownline; } //get the child of the member, this section will look for left or right of a member, once found, it will call GetNextDownlines() function to assign new memberid variables for left or right function GetChildDownline($member_id) { $getchilddownlinesql = @mysql_query('select id,recruiteris,position from `users` where recruiteris="'.$member_id.'" ORDER BY position'); while($childdownline = mysql_fetch_array($getchilddownlinesql)){ $childdownlinecode = $childdownline['id']; $direction = $childdownline['position']; if($direction=='Left'){ if($childdownlinecode){ //this is where you play with your html layout echo $childdownlinecode.'<br>'; GetNextDownlines($childdownlinecode,'Left'); } } if($direction=='Right'){ if($childdownlinecode){ //this is where you play with your html layout echo $childdownlinecode.'<br>'; GetNextDownlines($childdownlinecode,'Right'); } } } } //recursive function to call the functions and start all over again, this is where you can get the newly assigned memberid, call the GetChildDownline() that gets the left or right, then recycle all codes function GetNextDownlines($member_id,$direction) { if($direction=='Left'){ $topleft = GetDownline($member_id,'Left'); if($topleft){ //this is where you play with your html layout echo $topleft.'<br>'; } $getleftdownlinesql = @mysql_query('select id,recruiteris,position from `users` where recruiteris="'.$topleft.'" ORDER BY position'); while($getleftdownline = mysql_fetch_array($getleftdownlinesql)){ $leftdownline = $getleftdownline['id']; $leftdirection = $getleftdownline['position']; if($leftdirection=='Left'){ if($leftdownline){ //this is where you play with your html layout echo $leftdownline.'<br>'; GetChildDownline($leftdownline); } } if($leftdirection=='Right'){ if($leftdownline){ //this is where you play with your html layout echo $leftdownline.'<br>'; GetChildDownline($leftdownline); } } } } if($direction=='Right'){ $topright = GetDownline($member_id,'Right'); if($topright){ echo $topright.'<br>'; } $getrightdownlinesql = @mysql_query('select id,recruiteris,position from `users` where recruiteris="'.$topright.'" ORDER BY position'); while($getrightdownline = @mysql_fetch_array($getrightdownlinesql)){ $rightdownline = $getrightdownline['id']; $rightdirection = $getrightdownline['position']; if($rightdirection=='Left'){ if($rightdownline){ //this is where you play with your html layout echo $rightdownline.'<br>'; GetChildDownline($rightdownline); } } if($rightdirection=='Right'){ if($rightdownline){ //this is where you play with your html layout echo $rightdownline.'<br>'; GetChildDownline($rightdownline); } } } } } ?> <html> <head> <title>Winner And Winner</title> <meta http-equiv=Content-Type content="text/html; charset=utf-8"> <meta http-equiv=content-language content=en> <link href="styles.css" type=text/css rel=stylesheet> </head> <body> <table cellpadding="0" cellspacing="0" width="100%" border="0" class="noborder"> <tr> <td> <?php echo $topmcode.'<br>'; GetNextDownlines($topmcode,'Left'); GetNextDownlines($topmcode,'Right'); ?> </td> </tr> </table> </body> </html> -
Ok, here is the whole code for the downline, but the problem is that it doesn't show members below that one I mean if b follows a, and c follows b and I opened the page of A, it will only show A's info, and not bring B and C in the downline <?php if($_REQUEST["i"]){ GenerateTree($_REQUEST["i"]); } else{ GenerateTree($_GET['id']); } function GenerateTree($memberid){ $l1="<img src='icon.gif' width='33' height='45' alt='No Record' longdesc='#' />";$l2="<img src='icon.gif' width='33' height='45' alt='No Record' longdesc='#' />"; $query = "SELECT * FROM users where recruiteris='".$memberid."' order by type"; //echo $query; $result = mysql_query($query); //var_dump($result); while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { if($row["type"]=="Company"){$l1=getDownline($row["id"]);} if($row["type"]=="client"){$l2=getDownline($row["id"]);} } mysql_free_result($result); echo "<table border='0' class='mainTable' cellspacing='0' cellpadding='3' style='width:100%'>\n"; echo "<tr><td colspan='3' style='text-align:center;'>Login ID: ".$memberid.getInfo($memberid)."<br />"."</td></tr>"; echo "<tr><td colspan='3'>".getDownline($memberid)."</td></tr>"; echo "<tr><td style='width:33%;'>".$l1."</td><td style='width:33%;'>".$l2."</td>"; echo "</table>\n"; } function getDownline($memberid){ $query = "SELECT * FROM users where recruiteris='".$memberid."' order by type"; //echo $query; $result = mysql_query($query); //var_dump($result); $final = "<table border='0' style='width:100%;' class='internalTable' cellspacing='0' cellpadding='2'>\n"; $final .= "<tr>"; $nothing=true; $x=0; $pre; while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { $x++; $_SESSION['s']=0; if($row["type"]=="Company" && $x==1){$final .= "<td style='width:33%; background-color:#FFFFEC;' title='".getToolTip($row["login_id"])."'><a href='gen.php?i=".$row["login_id"]."'>".$row["login_id"]."</a><br />".$row["m_name"]."<br />Position: ".$row["form_type"]."<br />Downline - ".getCount($row["login_id"]).$_SESSION['s']."</td>";} if($row["type"]=="client" && $x==2){$final .= "<td style='width:33%; background-color:#E1F0FF;' title='".getToolTip($row["login_id"])."'><a href='gen.php?i=".$row["login_id"]."'>".$row["login_id"]."</a><br />".$row["m_name"]."<br />Position: ".$row["form_type"]."<br />Downline - ".getCount($row["login_id"]).$_SESSION['s']."</td>";} if($row["type"]=="client" && $x==1){$final .= "<td style='width:33%'><img src='icon.gif' width='33' height='45' alt='No Record' longdesc='#' /></td><td style='width:33%; background-color:#E1F0FF' title='".getToolTip($row["login_id"])."'><a href='gen.php?i=".$row["login_id"]."'>".$row["login_id"]."</a><br />".$row["m_name"]."<br />Position: ".$row["form_type"]."<br />Downline - ".getCount($row["login_id"]).$_SESSION['s']."</td>";} $pre = $row["type"]; $nothing=false; } if($nothing){$final .= "<td style='width:33%'><img src='icon.gif' width='33' height='45' alt='No Record' longdesc='#' /></td><td style='width:34%'><img src='icon.gif' width='33' height='45' alt='No Record' longdesc='#' /></td>"; } if($x==1 && $pre=="Company"){$final .= "<td style='width:33%'><img src='icon.gif' width='33' height='45' alt='No Record' longdesc='#' /></td>";} mysql_free_result($result); $final .= "</tr>"; $final .= "</table>\n"; return $final; } function getToolTip($id){ $query = "SELECT * FROM users where id ='".$id."'"; $result = mysql_query($query); $res; while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { $res = "fade=[off] cssheader=[toolHeader] cssbody=[toolBody] header=[Detail For ID () - ".$id."] body=[".$row["m_name"]."<br />Address:<br />".$row["address"]."]"; } mysql_free_result($result); return $res; } function getInfo($id){ $query = "SELECT * FROM users where id='".$id."'"; $result = mysql_query($query); $res; while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { $res = "<br />Name: ".$row["fname"]."<br />National ID: ".$row["nid"]."<br />"; } mysql_free_result($result); return $res; } function getCount($id){ $query = "SELECT * FROM users where recruiteris='".$id."'"; $result = mysql_query($query); $count = mysql_num_rows($result); $_SESSION['s'] = $_SESSION['s']+$count; while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { getCount($row["id"]); } mysql_free_result($result); //echo $count."<br />"; return ""; } // Closing connection mysql_close($link); ?>
-
I've tried, mate I thought it was working, but I clearly had no idea what I was doing, and didn't give me different results than I'm having now, so I thought about taking the cave man approach I'm not that experienced tho
-
That's the whole code of post.php <?php <?php $con = mysql_connect("localhost","username","password"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("database", $con); $fetch_check=mysql_query("SELECT email, nid FROM users WHERE email = '$email' OR nid = 'nid'"); $count=mysql_num_rows($fetch_check); If($count>0); { echo 'Email or National ID already exist'; } else { $sql="INSERT INTO users (id,fname, mname, lname, mobile, tel, address, job, company, nid, recruiteris, email, password, type) VALUES ('','$_POST[fname]','$_POST[mname]','$_POST[lname]','$_POST[mobile]','$_POST[tel]','$_POST[address]','$_POST[job]','$_POST[company]','$_POST[nid]','$_POST[recruiteris]','$_POST[email]','$_POST[password]','$_POST[type]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record added"; echo "<br />"; echo "<a href='http://waw-eg.com/admin/register.html'>Add More Client? Click Here</a><br/>"; echo "<a href='http://waw-eg.com/admin/Users.php'>View Users Click Here</a>"; mysql_close($con) } ?> ?>
-
I've tried that it was <?php $fetch_check=mysql_query("SELECT email, nid FROM users WHERE email = '$email' OR nid = 'nid'"); $count=mysql_num_rows($fetch_check); If($count>0); { echo 'Email or National ID already exist'; } else { //Insert query here } ?> but after that, it neither gave me an error or registered the user no matter if any existed or not
-
Automatically posting Twitter tweets using php
Gotharious replied to stubarny's topic in Third Party Scripts
Ok, If you're planning to post into twitter using php, I think this is a simple code to help you with it <?php $username = 'myUserName'; $password = 'myPassword'; $status = urlencode(stripslashes(urldecode('This is a new Tweet!'))); if ($status) { $tweetUrl = 'http://www.twitter.com/statuses/update.xml'; $curl = curl_init(); curl_setopt($curl, CURLOPT_URL, "$tweetUrl"); curl_setopt($curl, CURLOPT_CONNECTTIMEOUT, 2); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); curl_setopt($curl, CURLOPT_POST, 1); curl_setopt($curl, CURLOPT_POSTFIELDS, "status=$status"); curl_setopt($curl, CURLOPT_USERPWD, "$username:$password"); $result = curl_exec($curl); $resultArray = curl_getinfo($curl); if ($resultArray['http_code'] == 200) echo 'Tweet Posted'; else echo 'Could not post Tweet to Twitter right now. Try again later.'; curl_close($curl); } ?> -
Have you considered trying building your own CMS using a framework like CakePHP? Used it before building a cms, it was perfect
-
Hello, I want to check when adding a new user, that if there are 2 records that has the same recruiter id, it's should give an error, if less, than it makes him complete the registration Also check if the National ID number is not assigned to another user, so if there is a record that has it, it should give and error, if it's unavailable, it should let him complete the registration here is my code register.html <html> <form action="post.php" method="post"> <table> <tr><td>First Name: <input type="text" name="fname" /></td></tr> <tr><td>Middle Name: <input type="text" name="mname" /></td></tr> <tr><td>Last Name: <input type="text" name="lname" /></td></tr> <tr><td>Mobile: <input type="text" name="mobile" /></td></tr> <tr><td>Telephone: <input type="text" name="tel" /></td></tr> <tr><td>Address: <input type="text" name="address" /></td></tr> <tr><td>Job Title: <input type="text" name="job" /></td></tr> <tr><td>Company: <input type="text" name="company" /></td></tr> <tr><td>National ID Number: <input type="text" name="nid" /></td></tr> <tr><td>Recruiter ID: <input type="text" name="recruiteris" /></td></tr> <tr><td>Email: <input type="text" name="email" /></td></tr> <tr><td>Password: <input type="password" name="password" /></td></tr> <tr><td>Type: <input type="text" name="type" /></td></tr> <tr><td><input type="submit" /></td></tr> </table> </form></html> post.php <?php $sql="INSERT INTO users (id,fname, mname, lname, mobile, tel, address, job, company, nid, recruiteris, email, password, type) VALUES ('','$_POST[fname]','$_POST[mname]','$_POST[lname]','$_POST[mobile]','$_POST[tel]','$_POST[address]','$_POST[job]','$_POST[company]','$_POST[nid]','$_POST[recruiteris]','$_POST[email]','$_POST[password]','$_POST[type]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record added"; echo "<br />"; echo "<a href='http://waw-eg.com/admin/register.html'>Add More Client? Click Here</a><br/>"; echo "<a href='http://waw-eg.com/admin/Users.php'>View Users Click Here</a>"; mysql_close($con) ?>
-
I tried making multiple queries on the same table but didn't work, kept giving me Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource what I tried was <?php $result = mysql_query("SELECT * FROM users"); while($row = mysql_fetch_array($result)) { $rid = $row['id']; $sql = mysql_query("select * from users where recruiteris = $rid"); $row2 = mysql_fetch_assoc($sql); $num_rows = mysql_num_rows($sql); $rid2 = $row2['id']; $sql2 = mysql_query("select * from users where recruitis = $rid2"); $num_rows2 = mysql_num_rows($sql2); $total = $new_rows + $new_rows2; $var3 = '10'; $commission = $total * $var3;
-
Thanks, that worked
-
Make a user can only see some information from the database
Gotharious replied to Gotharious's topic in Application Design
Fixed it with a switch statement made each role redirects to a different directory -
Ok, I've done it here is the code I used <?php $results = mysql_query("SELECT * FROM users WHERE email = '$email' AND password = '$password' "); $row = mysql_fetch_assoc($results); $count=mysql_num_rows($results); if($count==1){ // Register $myusername, $mypassword and redirect to file "login_success.php" session_register("email"); session_register("password"); $_SESSION['id'] = $row['id']; $type = $row['type']; switch ($type) { case ($type=='client'): header("location:user.php"); break; case ($type=='Company'): header("location:Users.php"); break; case ($type=='employee'): header("location:employee.php"); break; } } else { echo "Wrong Username or Password, Please click back and try again"; } mysql_close($con); } ?>