[PHP-DB] Retricting Access to Menu Items
Good morning everyone. I'm building a very simple content management site that tracks tasks. The options available are: 1. Add Task 2. Edit Task 3. View Task 4. Print Task I need to restrict some users to only View and Print and I'm trying to find a way to tell the page not to load the menu options (the text) for those not having access to the Add and Edit functions. IOW, they would only see View and Print. I have three basic users: 1. System Admin 2. Subject Matter Expert (SME) 3. Viewers Obviously the System Admin and SME will have full access so it's the Viewers that are to have access to only View and Print. I have a users table but haven't set it up for the distinction. What I was thinking was creating a field labeled users_group and assign a numeric value for each user using the numbering system above. I have my page load the menu options: a href=home.php class=navlinkHome/abr / a href=view_tasks.php class=navlinkView Tasks/abr / a href=edit_task.php class=navlinkEdit Task/abr / a href=add_task.php class=navlinkAdd Task/abr / into here... BODY table width=90% border=1 cellspacing=10 cellpadding=0 align=center trtd colspan=2h1 id=mainheadICAO Tasks #8212; WAFS/h1/td/tr tr td align= center valign=top nowrap=nowrap width=10% Menubr / ?php include ('./includes/menu.html'); ? --The menu above inserted here. /td td valign=top class=content How can I tell the system not to load the last two lines unless they are a System Admin or SME? I read a chapter on Cookies/Sessions...but it wasn't that helpful for this case. Can I setcookie('user_group', '3') and use that somehow??? Am I in the ballpark with this solution? Thanks. Jeff
Re: [PHP-DB] Retricting Access to Menu Items
I've done this kind of thing with a number of web apps. What I usually do is create a user table in MySQL with a user-name, password and access level, which has an integer value. When a user logs in successfully, a session is created (see session_start() in php documentation), the access level is pulled from the user table and saved as a session variable. Then it is a simple matter of using bits of code like... if ($_SESSION['access_level'] 7){ echo some stuff; } In your example, you will also want to check the user's access level on each restricted page - it is not enough to hide menu options. Users could simply type the URL in. I hope that's clear. Good luck, Jeffrey Jeff Broomall wrote: Good morning everyone. I'm building a very simple content management site that tracks tasks. The options available are: 1. Add Task 2. Edit Task 3. View Task 4. Print Task I need to restrict some users to only View and Print and I'm trying to find a way to tell the page not to load the menu options (the text) for those not having access to the Add and Edit functions. IOW, they would only see View and Print. I have three basic users: 1. System Admin 2. Subject Matter Expert (SME) 3. Viewers Obviously the System Admin and SME will have full access so it's the Viewers that are to have access to only View and Print. I have a users table but haven't set it up for the distinction. What I was thinking was creating a field labeled users_group and assign a numeric value for each user using the numbering system above. I have my page load the menu options: a href=home.php class=navlinkHome/abr / a href=view_tasks.php class=navlinkView Tasks/abr / a href=edit_task.php class=navlinkEdit Task/abr / a href=add_task.php class=navlinkAdd Task/abr / into here... BODY table width=90% border=1 cellspacing=10 cellpadding=0 align=center trtd colspan=2h1 id=mainheadICAO Tasks #8212; WAFS/h1/td/tr tr td align= center valign=top nowrap=nowrap width=10% Menubr / ?php include ('./includes/menu.html'); ? --The menu above inserted here. /td td valign=top class=content How can I tell the system not to load the last two lines unless they are a System Admin or SME? I read a chapter on Cookies/Sessions...but it wasn't that helpful for this case. Can I setcookie('user_group', '3') and use that somehow??? Am I in the ballpark with this solution? Thanks. Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] X Tiger 10.4.5 + phpBB2 + MySQL 5 + Can't Connect Issue!
Hi, Im getting the following: Warning: mysql_connect(): Can't connect to local MySQL server through socket...etc. NOTES: 1.) MySQL 5 is running fine. 2.) Im able to connect to it via Navicat. 3.) I run Lasso on the same host, I know that I can pull and post data to and from MySQL. So its NOT mysql. Its PHP. I ran across a few postings from Apple and others that had SIMILAR problems, however those solutions are for MySQL 4 not MySQL 5. Seems to be bit of confusion about how to solve this problem. I tried what apple suggested...and that FAILED: http://docs.info.apple.com/article.html?artnum=301457 So now Im asking you good people, who actually BUILT the damn...ahem wrote the software. Im at whits end and I need to get this up and running. All I did was update from 10.4.4 to 10.4.5 and now PHP will not talk to MySQL at all. Ok...so what's the solution folks ? Anyone ? Buehler ? Buehler Thanks ahead of time M i l e s. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] X Tiger 10.4.5 + phpBB2 + MySQL 5 + Can't Connect Issue!
Is there really a .sock file where you're telling php there is? MySQL can put the socket file anywhere you want depending on it's configuration. /etc/my.cnf should specify this. -Micah On Monday 06 March 2006 9:08 am, m i l e s wrote: Hi, Im getting the following: Warning: mysql_connect(): Can't connect to local MySQL server through socket...etc. NOTES: 1.) MySQL 5 is running fine. 2.) Im able to connect to it via Navicat. 3.) I run Lasso on the same host, I know that I can pull and post data to and from MySQL. So its NOT mysql. Its PHP. I ran across a few postings from Apple and others that had SIMILAR problems, however those solutions are for MySQL 4 not MySQL 5. Seems to be bit of confusion about how to solve this problem. I tried what apple suggested...and that FAILED: http://docs.info.apple.com/article.html?artnum=301457 So now Im asking you good people, who actually BUILT the damn...ahem wrote the software. Im at whits end and I need to get this up and running. All I did was update from 10.4.4 to 10.4.5 and now PHP will not talk to MySQL at all. Ok...so what's the solution folks ? Anyone ? Buehler ? Buehler Thanks ahead of time M i l e s. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] X Tiger 10.4.5 + phpBB2 + MySQL 5 + Can't Connect Issue! - SOLVED!
Hi, Figured it out: Apple wiped out the location of the socket. they wanted '/var/mysql/mysql.sock' it should be: '/tmp/mysql.sock' Problem solved. M i l e s. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problems with PDO mysql
Hello, I have made this little example for explain my problem : ? $pdo = new PDO('mysql:host=192.168.69.20;dbname=Released', 'Web', 'Master99'); $data = '/enabled=boolean:true;/description=string:-bévènements'; $pdo-query(Update Test set data =' . $data . ';); ? If i execute this scripts from php cli the result will be : /enabled=boolean:true;/description=string:évènements If i execute this scripts from apache server the result will be : /enabled=boolean?;/description=string:évènements Its seem that is the é and è character that make this strange change because if i remove this character the result will be : /enabled=boolean:true;/description=string:vnements I dont found were the charset is converted or where is the problems . For information php cli and apache module are build with the same options. I need help please. I hope i ask my question in the good mailing list. See You Soon. Nicolas.
[PHP-DB] PHP4 with MYSQL5
Hello everyone. I'm trying to use my php4 conecting to a mysql5 server, and then executing some command lines to create a stored procedure but it's not working. When a tried to execute delimiter |, my php gets de follow error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delimiter |' at line 1 If I connect to server as local and try to execute the above command, it works fine. Could anyone help me about this? I'll be pleased by any tips. Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with a login page.
Hi there everyone, just wondered if you could help me with this login scipt. I've tried to customise a script that I found on a website, but it dosn't seem to be working. Here is the scipt that isn't working. ?php // database connect script. require 'includes/connection.php'; require 'includes/check_login.php'; if($logged_in == 1) { die('You are already logged in, '.$_SESSION['username'].'.'); } ? html head titleLogin/title /head body ?php if (isset($_POST['submit'])) { // if form has been submitted /* check they filled in what they were supposed to and authenticate */ if(!$_POST['username'] | !$_POST['password']) { die('You did not fill in a required field.'); } // authenticate. if (!get_magic_quotes_gpc()) { $_POST['username'] = addslashes($_POST['username']); } $check = mysql_query(SELECT username, password FROM users WHERE username = '.$_POST['username'].'); // check passwords match $_POST['password'] = stripslashes($_POST['password']); $info['password'] = stripslashes($info['password']); $_POST['password'] = $_POST['password']; if ($_POST['password'] != $info['password']) { die('Incorrect password, please try again.'); } // if we get here username and password are correct, //register session variables and set last login time. $date = date('m d, Y'); $update_login = mysql_query(UPDATE users SET last_login = '$date' WHERE username = '.$_POST['username'].'); $_POST['username'] = stripslashes($_POST['username']); $_SESSION['username'] = $_POST['username']; $_SESSION['password'] = $_POST['password']; $mysql_disconnect(); ? h1Logged in/h1 pWelcome back ?php echo $_SESSION['username']; ?, you are logged in./p ?php } else {// if form hasn't been submitted ? h1Login/h1 form action=?php echo $_SERVER['PHP_SELF']? method=post table align=center border=1 cellspacing=0 cellpadding=3 trtdUsername:/tdtd input type=text name=username maxlength=40 /td/tr trtdPassword:/tdtd input type=password name=password maxlength=50 /td/tr trtd colspan=2 align=right input type=submit name=submit value=Login /td/tr /table /form ?php } ? /body /html I will also include the .php file incase the text above dosn't read well. Basically, the page always returns 'Incorrect Password, please try again', and I can't work out why. I've tried with two different accounts, and neither are working. (I am 100% sure that I am entering usernames/passwords correctly). Thanks for any help with this, I can't for the life of me figure this out. Regards, Alex. ?php // database connect script. require 'includes/connection.php'; require 'includes/check_login.php'; if($logged_in == 1) { die('You are already logged in, '.$_SESSION['username'].'.'); } ? html head titleLogin/title /head body ?php if (isset($_POST['submit'])) { // if form has been submitted /* check they filled in what they were supposed to and authenticate */ if(!$_POST['username'] | !$_POST['password']) { die('You did not fill in a required field.'); } // authenticate. if (!get_magic_quotes_gpc()) { $_POST['username'] = addslashes($_POST['username']); } $check = mysql_query(SELECT username, password FROM users WHERE username = '.$_POST['username'].'); // check passwords match $_POST['password'] = stripslashes($_POST['password']); $info['password'] = stripslashes($info['password']); $_POST['password'] = $_POST['password']; if ($_POST['password'] != $info['password']) { die('Incorrect password, please try again.'); } // if we get here username and password are correct, //register session variables and set last login time. $date = date('m d, Y'); $update_login = mysql_query(UPDATE users SET last_login = '$date' WHERE username = '.$_POST['username'].'); $_POST['username'] = stripslashes($_POST['username']); $_SESSION['username'] = $_POST['username']; $_SESSION['password'] = $_POST['password']; $mysql_disconnect(); ? h1Logged in/h1 pWelcome back ?php echo $_SESSION['username']; ?, you are logged in./p ?php } else {// if form hasn't been submitted ? h1Login/h1 form action=?php echo $_SERVER['PHP_SELF']? method=post table align=center border=1 cellspacing=0 cellpadding=3 trtdUsername:/tdtd input type=text name=username maxlength=40 /td/tr trtdPassword:/tdtd input type=password name=password maxlength=50 /td/tr trtd colspan=2 align=right input type=submit name=submit value=Login /td/tr /table /form ?php } ? /body /html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problem with a login page.
snip... // check passwords match $_POST['password'] = stripslashes($_POST['password']); $info['password'] = stripslashes($info['password']); $_POST['password'] = $_POST['password']; if ($_POST['password'] != $info['password']) { die('Incorrect password, please try again.'); } snip... Alex, Sticking for the moment with the error message you get, I can't see anyplace where an array named $info with a key of password is declared or assigned this value. Are you sure that this variable exists? David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: PHP4 with MYSQL5
I receive aa answer by e-mail in order this telling me that i must upgrade my php4 to php5. It means that a php4 server don't works fine with mysql5 server? João Cândido de Souza Neto wrote: Hello everyone. I'm trying to use my php4 conecting to a mysql5 server, and then executing some command lines to create a stored procedure but it's not working. When a tried to execute delimiter |, my php gets de follow error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delimiter |' at line 1 If I connect to server as local and try to execute the above command, it works fine. Could anyone help me about this? I'll be pleased by any tips. Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] RE: [PHP] Re: PHP4 with MYSQL5
[snip] I receive aa answer by e-mail in order this telling me that i must upgrade my php4 to php5. It means that a php4 server don't works fine with mysql5 server? [/snip] http://www.php.net/mysqli is designed to work with versions of MySQL 4.1.n and above. It requires PHP5 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: PHP4 with MYSQL5
it does, you need the updated mysql library that comes with the php 5 files (libmysql.dll for windows) bastien From: João Cândido de Souza Neto [EMAIL PROTECTED] To: php-db@lists.php.net,php-general@lists.php.net Subject: [PHP-DB] Re: PHP4 with MYSQL5 Date: Mon, 06 Mar 2006 18:38:56 -0300 I receive aa answer by e-mail in order this telling me that i must upgrade my php4 to php5. It means that a php4 server don't works fine with mysql5 server? João Cândido de Souza Neto wrote: Hello everyone. I'm trying to use my php4 conecting to a mysql5 server, and then executing some command lines to create a stored procedure but it's not working. When a tried to execute delimiter |, my php gets de follow error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delimiter |' at line 1 If I connect to server as local and try to execute the above command, it works fine. Could anyone help me about this? I'll be pleased by any tips. Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Retricting Access to Menu Items
if you pull the user data into a session, then its a simple if them check if ($_SESSION['user']['user_access']1) //1 = basic user { echo 'a href=edit_task.php class=navlinkEdit Task/abr /'; echo 'a href=add_task.php class=navlinkAdd Task/abr /'; } bastien From: Jeff Broomall [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Retricting Access to Menu Items Date: Mon, 6 Mar 2006 07:27:03 -0500 Good morning everyone. I'm building a very simple content management site that tracks tasks. The options available are: 1. Add Task 2. Edit Task 3. View Task 4. Print Task I need to restrict some users to only View and Print and I'm trying to find a way to tell the page not to load the menu options (the text) for those not having access to the Add and Edit functions. IOW, they would only see View and Print. I have three basic users: 1. System Admin 2. Subject Matter Expert (SME) 3. Viewers Obviously the System Admin and SME will have full access so it's the Viewers that are to have access to only View and Print. I have a users table but haven't set it up for the distinction. What I was thinking was creating a field labeled users_group and assign a numeric value for each user using the numbering system above. I have my page load the menu options: a href=home.php class=navlinkHome/abr / a href=view_tasks.php class=navlinkView Tasks/abr / a href=edit_task.php class=navlinkEdit Task/abr / a href=add_task.php class=navlinkAdd Task/abr / into here... BODY table width=90% border=1 cellspacing=10 cellpadding=0 align=center trtd colspan=2h1 id=mainheadICAO Tasks WAFS/h1/td/tr tr td align= center valign=top nowrap=nowrap width=10% Menubr / ?php include ('./includes/menu.html'); ? --The menu above inserted here. /td td valign=top class=content How can I tell the system not to load the last two lines unless they are a System Admin or SME? I read a chapter on Cookies/Sessions...but it wasn't that helpful for this case. Can I setcookie('user_group', '3') and use that somehow??? Am I in the ballpark with this solution? Thanks. Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Very Tricky PHP Array.
Hi there, I have one arrray: $field_vals There are three values in the array, however two are multi-dimension array. i.e: $field_vals[base] - Array ( [0] - 1 [1] - 2 ) $field_vals[make] - Array ( [0] - 5 [1] - 7 [2] - 8 ) $field_vals[qty] - 1 I have a MySQL with a table (part) for the data to be stored in: part_id (key), base_id, make_id, qty I need to build a series of MySQL queries to INSERT the data into the table. ie. INSERT INTO part(cols...) VALUES(1,5,1); INSERT INTO part(cols...) VALUES(1,7,1); INSERT INTO part(cols...) VALUES(1,8,1); INSERT INTO part(cols...) VALUES(2,5,1); INSERT INTO part(cols...) VALUES(2,7,1); From the example array above, (2x3x1) 6 INSERT queries would be required. I would want this to be processed in the site form processor function. Basically, all my HTML forms have: $field[table_column] - which stores the field value or values in the case above. $name[table_column] - which stores the field name, this is always a single value since it is a hidden field. The [table_column] corresponds to the exact column in the database. I also three additional values: $table - Mandatory, stores the table name. $key - Mandatory, stores the primary key column for the table. $link - Optional, however used if a entry is required to be added into another table that is related to the key in the primary table. On submission, I use the $table value to list out all the columns that exist in the database table. Then I use a for() loop to go through each table column, which allows me to process both $field[table_column] and $field[table_column]. For me to be able to do a foreach() to achieve the list of queries I require to be executed in the database, I will most likely have to change the way I use the for loop, or will I? I am not exactly sure. My form processor code is quite long, however, I will place it at the bottom for reference. What I could do is keep my first for() loop which outputs the submitted data on a confirmation page and create a separate section of the function altogether, which generates the queries I require. At the moment I generate a part of the MySQL queries inside the for loop, however, doesn't work quite as well when you have an array, rather then a single variable. First of all, is it possible to do, if you do not want to static code to generate the queries? This is how I would do it, if I used static code: ---CODE--- $db = mysql_connect(); $qty = $field_vals['qty']; foreach ($field_vals['base'] as $base) { foreach ($field_vals['make'] as $make) { $inserts .= ($base, $make, $qty),; } } $sql = INSERT INTO part(base, make, qty) VALUES . substr($inserts, 0, -1); if (mysql_query($sql, $db)) echo done.; else echo error.; -/-CODE-/- I am not asking for people to completely rewrite my code, just some tips or hints on how to achieve this would be greatly appreciated. Here is my current form processor function for reference, if you need any additional information, please let me know. ---CODE--- ?php function formprocess($table,$key,$fname,$fval,$stage,$lnktblcol=0) { // setup db connection $db = new sql; // Switch through each stage switch ($stage) { case Submit: // set inital error variable $error = false; // lookup main table columns $columns = $db-show_columns($table); $count = count($columns); // include validator configuration file include('inc/validator.config.php'); // begin loop through each column for ($i=0;$i$count;$i++) { // set variables $column = $columns[$i]; $option = ; // check that column exists in HMTL form if ($fname[$column] || $fval[$column]) { // begin row and set column value $content .= trtd width='100' valign='top'.$fname[$column].:/tdtd width='175'b; $value = $fval[$column]; // validate column value if (!is_array($value)) { $fldmsg = validate($value,$db_col[$column]); } else { $fldmsg = OK; } // if not table key if ($column != $key) { // set column field and table2 for drop down values $selcolumn = ereg_replace($table._,,$column); $table2 = ereg_replace(_id,,$selcolumn); // if drop down value if (ereg(_id,$column) !ereg(base_id,$column)) { // grab table columns for drop down value $columns2 = $db-show_columns($table2); $lnkcolumn = ereg_replace($table2._,,$columns2[2]); // grab link column data if (ereg(_id,$lnkcolumn)) { $table3 = ereg_replace(_id,,$lnkcolumn); if (!is_array($value))
Re: [PHP-DB] Retricting Access to Menu Items
Now that you mention it!! I tried to use sessions but without success, i did: session_start(); session_register(var); but after log in as a different user, it keeps taking the data of the previous user. If I close the browser window and reload the page and log in, then it takes de current user Maybe I'm not killing the previous session! session_unset(); Do I need to propagate the Session ID on every page that use session_start()?? Can I use session_id();? Best Regards, Miguel Guirao - Mensaje original - De: Jeffrey [EMAIL PROTECTED] Fecha: Lunes, Marzo 6, 2006 7:37 ombr Asunto: Re: [PHP-DB] Retricting Access to Menu Items I've done this kind of thing with a number of web apps. What I usually do is create a user table in MySQL with a user-name, password and access level, which has an integer value. When a user logs in successfully, a session is created (see session_start() in php documentation), the access level is pulled from the user table and saved as a session variable. Then it is a simple matter of using bits of code like... if ($_SESSION['access_level'] 7){ echo some stuff; } In your example, you will also want to check the user's access level on each restricted page - it is not enough to hide menu options. Users could simply type the URL in. I hope that's clear. Good luck, Jeffrey Jeff Broomall wrote: Good morning everyone. I'm building a very simple content management site that tracks tasks. The options available are: 1. Add Task 2. Edit Task 3. View Task 4. Print Task I need to restrict some users to only View and Print and I'm trying to find a way to tell the page not to load the menu options (the text) for those not having access to the Add and Edit functions. IOW, they would only see View and Print. I have three basic users: 1. System Admin 2. Subject Matter Expert (SME) 3. Viewers Obviously the System Admin and SME will have full access so it's the Viewers that are to have access to only View and Print. I have a users table but haven't set it up for the distinction. What I was thinking was creating a field labeled users_group and assign a numeric value for each user using the numbering system above. I have my page load the menu options: Homebr / View Tasksbr / Edit Taskbr / Add Taskbr / into here... BODY table width=90% border=1 cellspacing=10 cellpadding=0 align=center trtd colspan=2h1 id=mainheadICAO Tasks #8212; WAFS/h1/td/tr tr td align= center valign=top nowrap=nowrap width=10% Menubr / ?php include ('./includes/menu.html'); ? --The menu above inserted here. /td td valign=top class=content How can I tell the system not to load the last two lines unless they are a System Admin or SME? I read a chapter on Cookies/Sessions...but it wasn't that helpful for this case. Can I setcookie('user_group', '3') and use that somehow??? Am I in the ballpark with this solution? Thanks. Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Este mensaje es exclusivamente para el uso de la persona o entidad a quien esta dirigido; contiene informacion estrictamente confidencial y legalmente protegida, cuya divulgacion es sancionada por la ley. Si el lector de este mensaje no es a quien esta dirigido, ni se trata del empleado o agente responsable de esta informacion, se le notifica por medio del presente, que su reproduccion y distribucion, esta estrictamente prohibida. Si Usted recibio este comunicado por error, favor de notificarlo inmediatamente al remitente y destruir el mensaje. Todas las opiniones contenidas en este mail son propias del autor del mensaje y no necesariamente coinciden con las de Radiomovil Dipsa, S.A. de C.V. o alguna de sus empresas controladas, controladoras, afiliadas y subsidiarias. Este mensaje intencionalmente no contiene acentos. This message is for the sole use of the person or entity to whom it is being sent. Therefore, it contains strictly confidential and legally protected material whose disclosure is subject to penalty by law. If the person reading this message is not the one to whom it is being sent and/or is not an employee or the responsible agent for this information, this person is herein notified that any unauthorized dissemination, distribution or copying of the materials included in this facsimile is strictly prohibited. If you received this document by mistake please notify immediately to the subscriber and destroy the message. Any opinions contained in this e-mail are those of the author of the message and do not necessarily coincide with those of Radiomovil Dipsa, S.A. de C.V. or any of its control, controlled, affiliates and subsidiaries companies. No part of this message or attachments may be used or reproduced in any manner
[PHP-DB] Help needed creating a social network
Anyone have some pointers at a HowTo on creating a social network? Basically I need to show people in your immediate network, and also friends of your friends, etc... Like the whole 'six degrees of separation' thing. Ala: myspace, friendster, etc. ad nauseum. I prefer mySQL and PHP, but I could port from most any code. I guess I'm mostly interested in the theory of this an how do I set up the tables properly and what is the magic incantation (JOIN) to get this chain of people. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Help needed creating a social network
CREATE TABLE `users` (userID int(11) not null auto_increment, primary key(userID), name tinytext not null, email tinytext not null); CREATE TABLE `links` (userID int(11), key (userID), friendID int(11), key(friendID)); ?php $friends = mysql_query(select users.name, users.userID from users left join links on links.friendID = users.userID where links.userID = {$_GET['userID']}); echo h1You have friends!!/h1; while ($f = mysql_fetch_assoc($friends)) { echo a href='socialnetwork.php?userID={$f['userID']}'{$f['name']}/abr\n; } publish(); profit($greatly); do (!$use) { coldfusion('Cause it sucks'); } ? (har har) On Monday 06 March 2006 9:47 pm, Daevid Vincent wrote: Anyone have some pointers at a HowTo on creating a social network? Basically I need to show people in your immediate network, and also friends of your friends, etc... Like the whole 'six degrees of separation' thing. Ala: myspace, friendster, etc. ad nauseum. I prefer mySQL and PHP, but I could port from most any code. I guess I'm mostly interested in the theory of this an how do I set up the tables properly and what is the magic incantation (JOIN) to get this chain of people. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php