PHP - Getting A Search Mls To Show In A Created Page Help.

I have created a login page, but i want the users to be directed to another page only if the login details are correct. How would i do this?any help is appreciate. Coding for the PHP is below: thank you.

Code: [Select]

<?php

$username = $_POST["username"];
$password = $_POST["password"];
//This if statement asks if the $username variable is set. If it is it executes the php script. Otherwise it echoes the login form.
if(isset($username)){

if (!($username == " " && $password == " "))

{

$connect = mysql_connect("","","") or die("Couldn't connect!");
mysql_select_db("") or die("Couldn't find db");

$query = mysql_query("SELECT * FROM users WHERE username='$username'");

$row = mysql_fetch_array($query);

$numrows = mysql_num_rows($query);

   $dbusername = $row['username']; 
   $dbpassword = $row['password'];
}
else {
echo ('<div id="username">
   <form action="" method="post"/>
<font color="red"> Please enter a username and password </font>
      <table><tr><td>
      <img src="imgs/Log In/username.png" alt=""/>
      </td><td>
      <input type="text" size="30" name="username" style="background-color:transparent;" />
      </td></tr></table>

      <table><tr><td>
      <img src="imgs/Log In/password.png" alt=""/>
      </td><td>
      <input type="password" name="password" size="30" />
      </td></tr></table>

      <form id="submitb" action="">
      <input type="submit" value="Log in" />
      </form>

      <p class="register">Not yet a member? <a href="Form.html">Register Here</a>, its Free!</p>
</div>');
}
//check to see if they match
if ($username == $dbusername && $password == $dbpassword) {
echo "You Are Now Logged In, Welcome To AdobeTuts!";
}
else
   echo ('<div id="username">
   <form action="" method="post"/>
<div id="new">
<font color="red"> Wrong Username Or Password, Please Try Again </font> </div> 
      <table><tr><td>
      <img src="imgs/Log In/username.png" alt=""/>
      </td><td>
      <input type="text" size="30" name="username" style="background-color:transparent;" />
      </td></tr></table>

      <table><tr><td>
      <img src="imgs/Log In/password.png" alt=""/>
      </td><td>
      <input type="password" name="password" size="30" />
      </td></tr></table>

      <form id="submitb" action="">
      <input type="submit" value="Log in" />
      </form>

      <p class="register">Not yet a member? <a href="Form.html">Register Here</a>, its Free!</p>
</div>');

}

//This next bit echoes the login form unless the $username variable is set.
else {
echo ('<div id="username">
   <form action="" method="post"/>
    
      <table><tr><td>
      <img src="imgs/Log In/username.png" alt=""/>
      </td><td>
      <input type="text" size="30" name="username" style="background-color:transparent;" />
      </td></tr></table>
      
      <table><tr><td>
      <img src="imgs/Log In/password.png" alt=""/>
      </td><td>
      <input type="password" name="password" size="30" />
      </td></tr></table>
      
      <form id="submitb" action="">
      <input type="submit" value="Log in" />
      </form>
      
      <p class="register">Not yet a member? <a href="imgs/Homepage tuts/Form.php">Register Here</a>, its Free!</p>
</div>');
}

?>

<?php
require_once('upper.php');
$error_msg='';
if(!isset($_COOKIE['LoginIdCookie'])){
if(isset($_POST['submit']))
{
require_once('database.php');
$LoginId=mysqli_real_escape_string($dbc,trim($_POST['LoginId']));
$Password=mysqli_real_escape_string($dbc,trim($_POST['Password']));
if((!empty($LoginId)) && (!empty($Password))){
$query="SELECT * FROM registration WHERE LoginId='$LoginId' AND Password=SHA('$Password') AND Flag='A'";
$result=mysqli_query($dbc,$query) or die('Not Connected');
if(mysqli_num_rows($result)==1)
{
$row=mysqli_fetch_array($result);
setcookie('LoginIdCookie',$row['LoginId']);
//$home_url = 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . '/index1.php';
header('Location: index1.php');
}
else{
echo 'Enter right UserName/Password combination or You may not approved yet. ';
echo '<a href="ForgetPassword.php">Can\'t access your account?"</a>';
}}
else{
echo' Fill all fields';
}
}}
?>
<html>
<title>Log In</title>
<body>
<?php
if(empty($_COOKIE['LoginIdCookie']))
{
echo $error_msg;
?>
<form method="post" action="<?php echo $_SERVER['PHP_SELF'] ;?>" >
<div class="LoginValidator">
<fieldset>
<legend>
Log In</legend><table><tr><td>
<label for="username">User Name :</label><br/><br/></td>
<td><input type="text" name="LoginId"><br/><br/></tr>
<td><label for="password">Password :</label></td>
<td><head>
   <div id="divMayus" style="visibility:hidden">Caps Lock is on.</div>
   <SCRIPT language=Javascript>

function capLock(e){
 kc = e.keyCode?e.keyCode:e.which;
 sk = e.shiftKey?e.shiftKey:((kc == 16)?true:false);
 if(((kc >= 65 && kc <= 90) && !sk)||((kc >= 97 && kc <= 122) && sk))
  document.getElementById('divMayus').style.visibility = 'visible';
 else
  document.getElementById('divMayus').style.visibility = 'hidden';
}

</SCRIPT>
   </HEAD>

<input onkeypress='return capLock(event)' type="password" name="Password"><br/></td></tr></table>
<input type="submit" name="submit" value="Login" class="Login_button">
</fieldset>

</div>
</form>

<?php 
}
else{
echo 'You are logged in as '.$_COOKIE['LoginIdCookie'];
}
require_once('lower.php');
mysqli_close($dbc);
?>




HI friends..........
In above code when I enter wrong user name or password, it displays error msg properly but problem is that when i enter right user name and password instead to redirect to index1.php it displays LoginPage again..........
I think cookie is not created as well..........
I can't understand where is problem???????/
please help me....................

Hi again....

I'm working on a project that creates a profile page for the user (i.e. 'username.php') when they register. Because there are two ways to register, through Facebook and through the website itself, there has to be an if statement in this page that it crates as to which ID to use for that user. Because Facebook usernames are not unique, we must identify a user through their OAuth User ID which is a 10 digit number. When a user registers through the website itself, usernames are unique so their profile page can be ID'd by their username.

Here's the code that creates that profile page:
function createProfile($user) {
        $userFile = 'users/'.$result['oauth_uid'].'.php';
        $fh = fopen($userFile, 'w') or die("can't open file");
        $stringData = "<?php\n" . '$pageowner = "' . $result['oauth_uid'] . '";' . "\n" . 'include "profile.php";' . "\n?>";
        fwrite($fh, $stringData);
        fclose($fh);
}

$user is the username passed to the function when it's called.

Currently that is set to create a line of code in the new profile page ('userid'.php) that looks like this:
<?php
$pageowner = "100001745088506";
include "profile.php";
?>

I want to add an IF to that page that follows this structu
if oauth_provider == facebook { $pageowner = "oauth_uid" } else { $pageowner = username }

But I don't know how to write that he
 $stringData = "<?php\n" . '$pageowner = "' . $result['oauth_uid'] . '";' . "\n" . 'include "profile.php";' . "\n?>";

to make it show up in the page it creates. I want that if statement to be written IN the page that is created.

I just don't know the syntax well enough yet to do that. Would somebody help me out or point me in the right direction?

Thanks!

Quesion: Show each movie in the database on its own page, and give the user links in a "page 1, Page 2, Page 3" - type navigation system. Hint: Use LIMIT to control which movie is on which page. I have provided 3 files: 1st: configure DB, 2nd: insert data, 3rd: my code for the question. I would appreciate the help. I am a noob by the way.

First set up everything for DB:

<?php
//connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//create the main database if it doesn't already exist
$query = 'CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query($query, $db) or die(mysql_error($db));

//make sure our recently created database is the active one
mysql_select_db('moviesite', $db) or die(mysql_error($db));

//create the movie table
$query = 'CREATE TABLE movie (
        movie_id        INTEGER UNSIGNED  NOT NULL AUTO_INCREMENT,
        movie_name      VARCHAR(255)      NOT NULL,
        movie_type      TINYINT           NOT NULL DEFAULT 0,
        movie_year      SMALLINT UNSIGNED NOT NULL DEFAULT 0,
        movie_leadactor INTEGER UNSIGNED  NOT NULL DEFAULT 0,
        movie_director  INTEGER UNSIGNED  NOT NULL DEFAULT 0,

        PRIMARY KEY (movie_id),
        KEY movie_type (movie_type, movie_year)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die (mysql_error($db));

//create the movietype table
$query = 'CREATE TABLE movietype (
        movietype_id    TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
        movietype_label VARCHAR(100)     NOT NULL,
        PRIMARY KEY (movietype_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

//create the people table
$query = 'CREATE TABLE people (
        people_id         INTEGER UNSIGNED    NOT NULL AUTO_INCREMENT,
        people_fullname   VARCHAR(255)        NOT NULL,
        people_isactor    TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
        people_isdirector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

        PRIMARY KEY (people_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Movie database successfully created!';
?>



********************************************************************
***********************************************************************

second file to load info into DB:



<?php
// connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//make sure you're using the correct database
mysql_select_db('moviesite', $db) or die(mysql_error($db));

// insert data into the movie table
$query = 'INSERT INTO movie
        (movie_id, movie_name, movie_type, movie_year, movie_leadactor,
        movie_director)
    VALUES
        (1, "Bruce Almighty", 5, 2003, 1, 2),
        (2, "Office Space", 5, 1999, 5, 6),
        (3, "Grand Canyon", 2, 1991, 4, 3)';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the movietype table
$query = 'INSERT INTO movietype
        (movietype_id, movietype_label)
    VALUES
        (1,"Sci Fi"),
        (2, "Drama"),
        (3, "Adventure"),
        (4, "War"),
        (5, "Comedy"),
        (6, "Horror"),
        (7, "Action"),
        (8, "Kids")';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the people table
$query  = 'INSERT INTO people
        (people_id, people_fullname, people_isactor, people_isdirector)
    VALUES
        (1, "Jim Carrey", 1, 0),
        (2, "Tom Shadyac", 0, 1),
        (3, "Lawrence Kasdan", 0, 1),
        (4, "Kevin Kline", 1, 0),
        (5, "Ron Livingston", 1, 0),
        (6, "Mike Judge", 0, 1)';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Data inserted successfully!';
?>



**************************************************************
****************************************************************

MY CODE FOR THE QUESTION:


<?php
$db = mysql_connect('localhost', 'root', '000') or
die ('Unable to connect. Check your connection parameters.');

mysql_select_db('moviesite', $db) or die(mysql_error($db));

//get our starting point for the query from the URL
if (isset($_GET['offset'])) {
   $offset = $_GET['offset'];
} else {
   $offset = 0;
}

//get the movie
$query  = 'SELECT
   movie_name, movie_year
FROM
   movie
ORDER BY
   movie_name
LIMIT ' . $offset . ' , 1';
$result = mysql_query($query, $db) or die(mysql_error($db));
$row = mysql_fetch_assoc($result);
?>
<html>
<head>
<title><?php echo $row['movie_name']; ?></title>
</head>
<body>
<table border = "1">
<tr>
<th>Movie Name</th>
<th>Year</th>
</tr><tr>
<td><?php echo $row['movie_name']; ?></td>
<td><?php echo $row['movie_year']; ?></td>
</tr>
</table>
<p>
<a href="page.php?offset=0">Page 1</a>,
<a href="page.php?offset=1">Page 2</a>,
<a href="page.php?offset=2">Page 3</a>
</p>
</body>
</html>

I want to show a cookie of a referral's username on a sign up page. The link is like this, www.mysite.com/signup?ref=johnsmith.

The cookie doesn't show if I go to that url page. But it does show up once I reload the page.  So I'm wondering if it's possible to show the cookie the first time around, instead of reloading the page?

Here is my code.

// This is in the header
$url_ref_name = (!empty($_GET['ref']) ? $_GET['ref'] : null);

if(!empty($url_ref_name)) {

  $number_of_days = 365;
  $date_of_expiry = time() + 60 * 60 * 24 * $number_of_days;
  setcookie( "ref", $url_ref_name, $date_of_expiry,"/");

} else if(empty($url_ref_name)) {
  if(isset($_COOKIE['ref'])) {
    $user_cookie = $_COOKIE['ref'];
  }
} else {}

// This is for the sign up form
if(isset($_COOKIE['ref'])) {
  $user_cookie = $_COOKIE['ref'];
  ?>
  <fieldset>
    <label>Referred By</label>
    <div id="ref-one"><span><?php if(!empty($user_cookie)){echo $user_cookie;} ?></span></div>
    <input type="hidden" name="ref" value="<?php if(!empty($user_cookie)){echo $user_cookie;} ?>" maxlength="20" placeholder="Referrer's username" readonly onfocus="this.removeAttribute('readonly');" />
  </fieldset>
  <?php
}

 

Ok i am stuck, i created a php script that draws data from a mysql dB into a php page. How can I send the page as the body in email? I do not need to preview the page, but can send it without ever viewing if that helps. When I put my code into a variable it does nothing. Is it caching? Should I load the results into mysql then send?please advise..

Hi All,   I need to get a small function working for a site I need to build for a group of friends.   I was able to get a login page, and a way to add data to the data base.   Now I am stuck on the search and show results fuctionalities.   I have found tens of scripts on the internet, but most of them are outdated, or I cant get them to work, either it sends me back a blank page, does nothing or sends me to an error page   The GOAL User Inputs text in a text box, clicks submit, the data in the text box is looked for in the second collumn of the DB, The information of the collumns 2 to 7 of the DB for the name search are displayed either on the same page or on a new page.   Is there any chance you could hel me with that, taken into account that I dont need the html part of the code, I only need help with the php part...   Thanks in advance to all the people reading this and the ones helping me...

Hi,

I would like to do the following but not sure how.

If the you/user is on index.php of http://www.domain.com/ show one page
If not show another

How would I do this?

Thanks

For a long time, I think I have been using heading tags wrong on websites.    They always show like this on Google.

Websitename
websitename.com/category?name=mystery
Posted by Night Flyer; 7 days ago; 5 views. « first; « prev; 1 of 1; next »; last ». Contact Us; @ 2014 websitename Inc. All Rights Reserved.

As you can see, Google takes all the heading tags on my page and puts them in the description of the search result.  So I have finally come to the conclusion that I should not be using heading tags for those things.  Am I correct on that?

Ok, so I have a bit of code but it's not working as it should, would one of you guys have a look at it and let me know where I'm going wrong?

Basically I need to be able to input several words or terms into the text area, each on a separate line and have the results displayed something like:

hello: 23,000.000
hello world: 19,000,000
world: 278,000,000

I also see that the script is not searching the words / terms inside quotes (EG. "hello world")

TIA

Code: [Select]
<html>
<body>
<?php
function my_fetch($url,$user_agent='Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)')
{
$ch = curl_init();
curl_setopt ($ch, CURLOPT_URL, $url);
curl_setopt ($ch, CURLOPT_USERAGENT, $user_agent);
curl_setopt ($ch, CURLOPT_HEADER, 0);
curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt ($ch, CURLOPT_REFERER, 'http://www.google.com/');
$result = curl_exec ($ch);
curl_close ($ch);
return $result;
}

$s = $_GET['s'];
if (isset($s))
{
echo "<p><i>Search for $s</i></p>";
    $s = urlencode($s);
    $data = my_fetch("http://www.google.com/search?hl=en&q=" . $s . "&btnG=Google+Search");

    $data = strip_tags($data);

    $find = 'Results 1 - 10 of about ';
    $find2 = ' for';

    $data = strstr($data, $find);

    $pos = strpos($data, $find2);


$search_number=substr($data,strlen($find), $pos-strlen($find));

echo "Total Results: $search_number";
}
else
{
?>

<form name="form1" id="form1" method="get" action="">
<div align="left">
<p>  <textarea name="s" type="text" id="s" rows="8" style="width:60%" /></textarea><br />
<input type="submit" name="Submit" value="Results" /></p>
Put "" around the string: <input type="checkbox" checked name="apos" value="true" /><br />
</div>
</form>
<p>
<?php
}
?>
</p>
</body>
</html>

Hi All,

I want to be able to show selected pages of my website as PDF using a 'PDF' button much like this site does:

http://www.westmeon.org.uk/index.php?option=com_content&task=blogsection&id=8&Itemid=35

I presume that I will need to install some sort of software on my server (which runs the latest PHP, MySQL etc.) but after hours of searching online I cannot find a simple way of doing this.

Does anyone have any suggestions or pointers for how I can do this?

FYI my website is written in PHP drawing data from a MySQL database.

Regards,
Neil

Hi

I want to make something like this -

My Sites index.php will be avail avail to user after he has clicked in a link that will come after every 24 Hour in my site. Means when a user first enters the site it will come and clicking in there the site will be avail avail. again after 24 Hour it will come again.

But i am not getting how to do it.

So need help

SaKIB

Hi,

This may be something for JavaScript but I would like to know if and how it's possible to show who is currently active/viewing the page. Users are logged into the system with their own account.

The purpose of this is for a CRM where more than one person may be editing the same record, so undesired overwrites might occur which is what I'd like to avoid with this "other user editing this record" notification.

I have code for a perv. and next links at the bottom of my search page. Which shows the next ten results however when the next link is clicked the page says please fill in all fields (as if the search box was left empty and the search button was clicked... please help me figure this out...


Code: [Select]
<?php


  // Get the search variable from URL

  $var = $_GET['search'];
  $searchtype = $_GET['searchtype'];
  $isbn = "ISBN";
  $school = "School";
  $title = "Title";
  $subject = "Subject";
 
  $trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=10; 

// check for an empty string and display a message.
if ($trimmed == "")
  {
  echo "<p>Please enter a search...</p>";
  exit;
  }

// check for a search parameter
if (!isset($var))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }

//connect to your database
$connect = mysql_connect("db","user","pass") or die("Not connected");

//specify database 
mysql_select_db("user") or die("could not log in");

if ($searchtype == ($title))

{

// Build SQL Query  
$query = "select * from boox where name like \"%$trimmed%\"  
   order by name"; // EDIT HERE and specify your table and field names for the SQL query
}
elseif ($searchtype == ($school))
{
// Build SQL Query  
$query = "select * from boox where school like \"%$trimmed%\"  
   order by school"; // EDIT HERE and specify your table and field names for the SQL query

}
elseif ($searchtype == ($isbn))

{
// Build SQL Query  
$query = "select * from boox where isbn like \"%$trimmed%\"  
   order by isbn"; // EDIT HERE and specify your table and field names for the SQL query


}
elseif ($searchtype == ($subject))

{
// Build SQL Query  
$query = "select * from boox where subject like \"%$trimmed%\"  
   order by subject"; // EDIT HERE and specify your table and field names for the SQL query

}
 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

// If we have no results, offer a google search as an alternative

if ($numrows == 0)
  {
  echo "<h4>Results</h4>";
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results</p>";

// google
 echo "<p><a href=\"http://www.google.com/search?q=" 
  . $trimmed . "\" target=\"_blank\" title=\"Look up 
  " . $trimmed . " on Google\">Click here</a> to try the 
  search on google</p>";
  }

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// display what the person searched for
echo "<p>You searched for: &quot;" . $var . "&quot; in &quot;" . $searchtype ."&quot; </p>";

// begin to show results set
echo "Results&nbsp;&nbsp;";
$count = 1 + $s ;

if ($searchtype = $title)

{
// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["name"];
  
  
   echo "$count.&nbsp;$title&nbsp;&nbsp
 </br><table width='297' border='1' align='center'>
  <tr>
    <td width='152'>Book Title:</td>
    <td width='129'>$row[name]</td>
  </tr>
  <tr>
    <td>Author:</td>
    <td>$row[author]</td>
  </tr>
    <tr>
    <td>ISBN#</td>
    <td>$row[isbn]</td>
  </tr>
  <tr>
    <td>Date Posted:</td>
    <td>$row[date]</td>
  </tr>
  <tr>
    <td>Posted By:</td>
    <td><a href='backpack.php?usr=$row[username]'>$row[username]</a></td>
  </tr>
  <tr>
    <td>School:</td>
    <td>$row[school]</td>
  </tr>
</table></br>";
   $count++ ;
   }
}
elseif ($searchtype = $school)
{
// now you can display the results returned
while ($row= mysql_fetch_array($result)) {
  $title = $row["school"];
   echo "$count.&nbsp;$title" ;
   $count++ ;
   }
 
}
elseif ($searchtype = $subject)
{
// now you can display the results returned
while ($row= mysql_fetch_array($result)) {
  $title = $row["subject"];
 echo "$count.&nbsp;$title" ;
   $count++ ;
   }

}
elseif ($searchtype = $isbn)
{
// now you can display the results returned
while ($row= mysql_fetch_array($result)) {
  $title = $row["isbn"];
   echo "$count.&nbsp;$title" ;
   $count++ ;
   }

}



$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt; 
  Prev 10</a>&nbsp&nbsp;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  echo "&nbsp;<a href=\"$PHP_SELF?s=$news&search?q=$var\">Next 10 &gt;&gt;</a>";
  }

$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p>Showing results $b to $a of $numrows</p>";
  
?>

hello, was wondering if there is a way to have a search box that searches all data on the current page.  similar to what a ctrl+F would do in internet exoplorer