search mysql data

klimi

I have created a mysql data and a login script based in my data
Attached is the login php

I would like that when the users enter the web to be able to retrieve their data based on their name.

So I would like a serach php page based on mysql data

I am completely begginer in php and mysql so I would like to have the complete code

Attached is my login page and my data

TobyRT

I've just done something similar to this.

Obviously you're validating their user details againast something in the db (if $user and $password = what is in the db { $loggedin=true }😉

All you need to do is retrieve the other data from the db using the same criteria:

if ($loggedin==true)
{
"select * from db WHERE user=$user AND pass=$pass"
}
echo [stuff i got from the db];

Follow?

Have a look at my thread on md5/login problems

klimi

I have mentioned that I am completely begginer in php
I will explain the mysql database
The central is "intracom"
The table I am using for the login is "users"

I want to retrieve data form table "intracom" where the name in there is equal to username in my login page

So the code that you send me where shall I put it?

Or what else shall I do?

TobyRT

Do you have any authentication in your 'members only' pages to confirm that they're still logged in?

What happens if I type in 'yoursite.com/login_success.php' - will it let me in? if it does, you've got a problem!

You need to have a validation at the top of each page that you want restricted to make sure that the user is still logged in, and if they're not logged in, something to allow them to login.

You already have this:

if($count==1){
// Register $myusername and redirect to file "login_success.php"
session_register("myusername");

It would be useful to see more of our code before we can comment any better

klimi

Thanks a lot i will try it

but i would like to show you sth else
I found a search script and I changed based on mysql table

Mysql table looks like this

Field
Type

id
int(11)

name
varchar(255)

object_intr
varchar(255)

object_descr_intr
varchar(255)

activity_intr
varchar(255)

activity_descr_intr
varchar(255)

activityb_intr
varchar(255)

activityb_descr
varchar(255)

objectb_intr
varchar(255)

objectb_descr
varchar(255)

hourb
varchar(255)

hours
varchar(255)

and I am attaching the script

but it does not working could you tell me why?

TobyRT

If you give us a summary of what it is you're trying to achieve overall, we'll probably be able to help you more 🙂

Your if() statement seems OK - that is to say, you connect and see if there is a result, and if there is, you do something...BUT... you seem to be going about things in a slightly odd manner - why are you doing this: ?

printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n", $myrow["id"],$myrow["name"], $myrow["object_intr"], $myrow["object_descr_intr"], $myrow["activity_intr"], $myrow["activity_descr_intr"],$myrow["activityb_intr"], $myrow["activity_descr_intr"], $myrow["activityb_descr"], $myrow["objectb_intr"], $myrow["objectb_descr"], $myrow["hourb"], $myrow["hours"]);

I'm sure a person such as sxooter or roger ramjet will be able to decipher better than I, but you seem to be adding a lot of stuff in (which may be valid but too advanced for me!), plus you while() loop appears to come in too late...try this as a concept...

if (you have a result)
{
echo <table width=100%> //etc - start y our table if there is a positive result
     while (the result meets the condition)
    {
    echo '<tr><td>'                 //start the cell
    .$myrow['object_intr']       //add the content
    .'</td></tr>';                    //end the cell and repeat these 3 lines for each field you want to import

}                                       //end the while loop which adds the content

echo </table>                       //end the table because there's no more content
}                                           //end the if() statement because it has been satisfied

Another question - what is the role of these two fields (and others like them)?

object_intr
varchar(255)

object_descr_intr
varchar(255)

If it's a matter of an id and a description (or something similar) it might make more sense in the long term to make this relational - have a table for the main details, but relate it to other tables which have a description.

Another thing if you're having trouble is to always errorcheck: whenever you carry out a mysql() function, always use the mysql_error() function with it, so if it goes wrong, it'll say what's wrong with it.

mysql_select_db("intracom",$db);
$result = mysql_query("SELECT * FROM intracom WHERE name='$search'",$db);

would better read as:

mysql_select_db("intracom",$db) or die ("error in query ".mysql_error());
$result = mysql_query("SELECT * FROM intracom WHERE name='$search'",$db) or die ("error in query".mysql_error());

Overall, I'd suggest that you tell us exactly what it is you want to achieve and what code you have in place to do it. Then we can advise you more knowledgeably about the direction you perhaps might want to take. If you don't, we may end up giving you slightly irrelevant information!

best of luck though - php can be tricky at the beginning (I should know, I'm still ther!) but it's worth it in the end!

klimi

These are the fields I want to retrieve the data from:
object_intr
varchar(255)

object_descr_intr
varchar(255)

activity_intr
varchar(255)

activity_descr_intr
varchar(255)

activityb_intr
varchar(255)

activityb_descr
varchar(255)

objectb_intr
varchar(255)

objectb_descr
varchar(255)

hourb
varchar(255)

hours
varchar(255)

and the "name" field will be the user which will enter the search form to retrieve his data

Is this clear?

TobyRT

are both your tables in the same database?

I think it's probably now best for you to try re-writing the script, then coming back with any further errors or problems...