Mistral 🤖

I would also suggest scrapping the whole idea of passing your variables through the url. Rather, maintain what areas the users have access to in your database. Have one "display" or "control" page that queries your database based on user's info. Have your query select relevant info and display a single page based on the user's level etc... In short, passing variables through the url should never ever ever be used unless it is completely harmless...like for pagination.

the keyword you are looking for is "pagination"

LoL I have dabbled in flash quite a bit, myself.

hrmm..okay, so you already have a database, and you are wanting to phrase a query to pull specific information based on your criteria? I mean, I could help you on some php code to sort through it all if you do a query for everything first, but that's not really efficient. I think you'll probably find the sql forum more useful so I'm going to go ahead and move your thread over there. One of the resident database experts should be able to help you out there.

Okay I'm not quite sure I'm understanding this 100% but it seems to me that what you are saying is that for each row of your table, you want it to look like this, right? Group1FirstNameLastNameBusinessNameGroup2 BobSmithBobSmithCrayolaCrayola JohnDoeJohnDoeBubbleGumBubbleGum BobSmithBobSmithBubbleGumBubbleGum If that is the case, first off, I don't really see why you would need the Group2 column, as it is virtually identical to the businessname column...2nd, Group1 would be made simply by concatonating your Firstname and Lastname variables. I don't really know how you have anything else setup, but it seems you would do that in the information entering process, in the part of your script that creates the new entry; just make a new temp var $group1 = $firstname . $lastname; etc... if that's not what you're saying then..uh, please elaborate further.

yes. But if there is a file in that directory with the same name, it will overwrite it.

If I do anything officially official I usually cross all my t's and dot all my i's, but I have hundreds of little script projects/messing arounds/hobbies that I don't really bother with "formal" things on.

Think your quote pretty much says it all... it's not necessary but it's more efficient.

can you show an example using example data?

Best option is to obfuscate your script using an encryption program like from zend or sourceguardian etc...just google "encrypting php" or w/e.

The reason why some people tend to mix the two together is for security reasons. People like to hijack/fake session info, so coders like to store that info in the db and then verify the info (like the session id) against what's in the database at the time. Also, they are "mixed" so-to-speak, because many things you do, use both of them. For instance, You would use the db to hold information about someone, like their name, address, password, etc.. and you would have the user login to your site and you would use a session to hold that information from page to page to keep them "logged in." Sessions are most commonly used for signifying whether someone is "logged in" or "logged out" (though there are many many other uses for it). If you know a thing or two about computers, think of a database as the computer's rom or harddrive, and think of sessions as the ram. If you're just looking to do something simple, non-data sensitive, forget the whole database thing, as it is overkill. Based on your original post, all you need is something as simple as this: page1.php <?php session_start(); $_SESSION['somevariable'] = "blah"; echo "<a href = 'page2.php'>go to next page</a>"; ?> page2.php <?php session_start(); echo $_SESSION['somevariable']; ?>

Mr. Wizard4U, can you please be so kind as to give us an update as to what you have tried to do, as far as fixing your code (other than shoving it at us and asking for a magic wand to be waved)? Because at this point in time, based on your most recent comment, I would suggest seeking a freelancer (please go to freelance forum). We aren't here to do your work for you.

Same way as you insert something into any other data field, except that the values you insert can only be "yes" or "no". Are you asking how to insert data into your table? Please make use of the search field or google, as that is a very common, very basic question.

You could make a loop....? I think that's what you're wanting to do...right? I'm seeing several queries in this code, so are you trying to somehow condense all that code into one query, or are you wanting to repeat that entire block of code over and over again? Need more info please.

well, to be honest, I'm not 100% certain of your querying style there...I mean, there's many ways to do the same thing, but that's not how I would do it, so I'm unfamiliar with the inner workings of for instance mysql_fetch_object etc.. however... Right off the bat though I would say your actual query string is only going to return a password. I guess that's what you're shooting for, but then you have: $row=mysql_fetch_object($st); $em=$row->email_address;// email is stored to a variable $em isn't going to be assigned anything, because you only queried for a password, based on the name/email. The only info that $st is going to hold is the password. Here's how I personally would code getting the password: <?php // connect to database $conn = mysql_connect('localhost', 'db_username', 'db_password') or die(mysql_error()); $db = mysql_select_db('db_name',$conn) or die(mysql_error()); //dummy vars $name = "John"; $email = "[email protected]"; $query = "select password from tablename where name = '$name' and email = '$email'"; $rs = mysql_query($query, $conn) or die(mysql_error()); if ($info = mysql_fetch_array($rs)) { $pass = $info['password']; // here is the password } else { echo "no password found."; } ?> But that's assuming you just want a straight forward query based on the user putting in his name and email, and then he gets his password retrieved.

first off, try putting an echo $first_name . '<br>'; echo $email_address; above your $query = .... to see if your variables are holding what they're supposed to be holding. If they aren't...

You have to use nested for() or foreach() loops. example: for ($x = 0; $x < 10; $x++) { for ($y = 0; $y < 10; $y++) { echo $blah[$x][$y] . "<br>"; } // end y } // end x

moved to misc.

the problem is your in_array arguments are reversed. It's in_array(needle, haystack)

Hey art, Using an array to pass multiple values from a form is a very common question that not only comes up a lot, but you will also find it inside people's code snippets in practically every other thread...because like 99% of forms have multiple values to be passed, and it's just more logical to use an array instead of individual variables. I pointed you in the right direction with my other post. This post is me suggesting you use the search function for a very common coding practice. Good luck and happy coding

I made a separate post because I know you're reading: How about trying a little } after that return, and before your next function. That might possibly be it, because without that, it's like, trying to use your variable in two different ways.

umm, well I can't really be more specific than that without pouring over your entire code (which I'm not about to do sorry lol) I mean, I'm not necessarily seeing a problem with the code that you provided, so you're probably gonna have to backtrack and see what argument you're trying to pass to your functions. You just have to go through your code and make sure you didn't do anything like declare your variable somewhere else that's under the same jurisdiction as in this function (like a global variable) etc... p.s.- using $string in more than one function doesn't necessarily mean anything. They are both local variables that are trashed when the function breaks...but it might mean something if you have, as mentioned, a global version of it somewhere.

You need to update the database (run the query) for each checkbox value that's posted. Most people do this by passing the checkbox data in an array instead of an individual variable for each one, and then either loop through the array (putting the query inside the loop) or rephrasing the query (it really depends on the data etc.. as to what's best).

I think the problem has to do with you declaring a variable as one type (by virtue of assigning something to it, of course), and then trying to use it as a different type. I think.

I like the interactive quizzes/tutorials idea 448191 suggested. Also, I'd like to see the freelance forum removed from the boards, and put onto the main site somehow.