PHP - Information Not Registering In Sql Database

hello.

please could someone help me with this conundrum 

im trying to pull my content dynamically. im almost there but im stuck with some code.

so i have a layout with 3 columns and in each column i have a place holder. ph01, ph02, ph03

each page has its own id and depending on what the page id is i what to pull different elements into the 3 placeholders.

so for this code in the database i have the following:


table name: placeholders
pages_id = page id
ph_number = placeholder number
contElements_id = element ids

id    pages_id   ph_number      contElements_id
1     1              1                    1, 2, 3                         
2     1              2                    4, 5, 6                 
3     1              3                    7, 8, 9                         


table name: contelements
name = name of the element

id    name   
1    E1
2    E2
3    E3
4    E4
5    E5
6    E6
7    E7
8    E8
9    E9


SO, page_ID=1 has 3 placeholders and they should show:
ph01 should display = E1, E2, E3
ph02 should display = E4, E5, E6
ph03 should display = E7, E8, E9


this is the code im trying to put together.

on the page im using this include function in the left, center and right columns.

Code: [Select]

$phNo = "1";
echo include_admin_contElements($phNo, $pageID); 

$phNo = "2";
echo include_admin_contElements($phNo, $pageID); 

$phNo = "3";
echo include_admin_contElements($phNo, $pageID); 



now this is where the problem is.... i think
in the function file i have this but its a mess..

Code: [Select]
function  include_admin_contElements($phNo, $pageID){


$PH = Placeholders::find_all();

foreach ($PH as $PHs){
$PHid = $PHs->id;
$PHpid = $PHs->pages_id;
$PHce = $PHs->contElelments_id;
$PHn = $PHs->ph_number;

if($pageID == $PHpid){

$CE = Contelements::find_by_PHce($PHce);

foreach ($CE as $CEs){
echo $CEid = $CEs->id;
echo $CEname = $CEs->name;
}
}
}
}


- so the idea is i get $phNo, $pageID from the page,
- then find all the placeholders in the database Quote

Placeholders::find_all();

- then if the $pageID is the same as the $PHpid in the placeholder database Quote

if($pageID == $PHpid){

get the content elents for that page.
- then i want to get the elements that belong to that page using Quote

Contelements::find_by_PHce($PHce);


but that does not work

Code: [Select]
                public static function find_by_PHce($PHce=0){
$sql = "SELECT * FROM ".self::$table_name." WHERE id=".$PHce."";
$result_array = self::find_by_sql($sql);
return $result_array;
                }


anyway... im stuck. this code doesn't even seperate the 3 different placeholders. it needs a more experienced eye..

its a mess

please help

thanks

ricky

I have these two files and I need to solve the problem that I need the user data in the role column to be taken when logging in. I have written it so that the data can be extracted from the database, but it does not work for me that it is “forwarded” from process.php to admin.php . Please don’t know what the error is that the admin.php file doesn’t want to load $ _SESSION['Role'] from process.php ? Thanks to everyone for helping and here is the code:

process.php

<?php 
require_once('connect.php');
session_start();
    if(isset($_POST['Login']))
    {
       if(empty($_POST['Username']) || empty($_POST['Password']))
       {
            header("location:index.php?Empty= Please Fill in the Blanks");
       }
       else
       {
            $query="select * from role_test where Username='".$_POST['Username']."' and Password='".md5($_POST['Password'])."'";
            $result=mysqli_query($con,$query);

            if(mysqli_fetch_assoc($result))
            {
                $_SESSION['User']=$_POST['Username'];

                while($row = mysqli_fetch_array($result) ){
                $_SESSION['Role']=$row['role'];
                }

                header("location:admin.php");
            }
            else
            {
                header("location:index.php?Invalid= Please Enter Correct User Name and Password ");
            }
       }
    }
    else
    {
        echo 'Not Working Now Guys';
    }

?>

 

admin.php

<?php
    session_start();

    if(!(isset($_SESSION['User'])))
    {
        header("Location: index.php");
        exit(0);
    }	  

?>
<!DOCTYPE html>
<html>
<head>
<title>Role</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<body>
<?php
$_SESSION['Role']=$role;

echo $role;

?>

</body>
</html>

 

 

 

I am creating a music blogging site however the main page will only show one video the code is below anyone have any ideas?

"
<?php
            //open database
            $connect = mysql_connect("******","username","password") or die("Not connected");
            mysql_select_db("collegebooxboox") or die("could not log in");
   
            $query = "SELECT * FROM boox ORDER BY date DESC";
            $result = mysql_query($query);
            
             // Get the page number, if none is set - it is 0
            if( isset($_GET['page']) )
            {
               $page =$_GET['page'];
            }
            else
            {
               $page  = 0;
            }   
            
$resultsPerPage = 15;
$num = mysql_num_rows($result); // amount of rows
$loops = $page*$resultsPerPage; // starting loops at..

while ($loops < $num && $loops <  ($page+1)*$resultsPerPage )
   {
   $link = mysql_result($result,$loops,"link"); // get result from the 'Title' field in the table
   $username = mysql_result($result,$loops,"username"); // get result from the 'Content' field in the table
   $messsage = mysql_result($result,$loops,"message");
   $date = mysql_result($result,$loops,"date");
   if ($pagelimit == 0)
      {
      $pagelimit == 1;   
      }
   if ($pagelimit <= 15)
   // echo stuff here
      $loopz = $loops + 1;
       echo "&nbsp;&nbsp;&nbsp
          </br><align='left'><table width='297' height='900' border='1' align='center' bgcolor='#111'>
                 <tr>
                  <td>$loopz.&nbsp;$link   
                            </br>
                  $message
                  </br>
                  Posted By: $username $date
                  </td>
                 </tr>
               </table></br><br>";
          $count++ ;
          $pagelimit++;
          $loops++;
   }
      
      if ( $page!=0 ) // Show 'Previous' link
      {
         $page--;
         $prevpage = ($page +  1);
         echo "<br><br><br><a href='index.php?page=$page'>Previous  $prevpage &nbsp;&nbsp;&nbsp;&nbsp;</a>";
         $page++;
      }
      if ($loops > 5&&($page+1)*$resultPerPage < $num ) // Show 'next' link
      {
         $page++;
         $nextpage = ($page + 1);
         echo "<a href='index.php?page=$page'>   Next $nextpage</a>";
      }
   
         ?>
"

Hi Everyone,

I have a program that generates 200 unique images keeping the first image static in each run.The images keep scrolling on to the screen pause for 3 seconds and scroll off I'm able to generated all 200 unique images without repetition, everything is working well except for the lase two images the last two  images are scrolling on to the screen but are not been displayed in the database, Moreover The last image is a duplicate of 197th image.I don't know what is happening.....

Here is MY code..........



<?php
      session_start();
      $sid = $_SESSION['id'];
      $_SESSION['imageDispCnt'] = 0;
$myQuery = "SELECT * from image";
$conn = mysql_connect("localhost","User","Passwd");
mysql_select_db("database_Name",$conn);
$result = mysql_query($myQuery);
$img =Array();
$id =Array();
$i =0;
$imagepath = 'http://localhost/images/';
while ($row = mysql_fetch_array($result))
      {
      $img[$i] =  $imagepath.$row['img_name'];
      $id[$i] =  $row['imageid'];
      $i = $i + 1;
       }
 ?>
      </head>
      <script language="JavaScript1.2">
var scrollerwidth='800px';
var scrollerheight='600px';
var scrollerbgcolor='white';
var pausebetweenimages=3200;
var s;
var sec;
var d;
var j;
var imgid;
var milisec = 0;
var seconds = 0;
var flag = 1;
var ses_id = '<?php echo $sid;?>';
var count = 0;
var i = 0;
var imgname;
var imgid;
var k =0;
var slideimages=new Array();
var img_id = new Array();
var index;

<?php
  $l =0;   
$count = array();
   $j = rand(0,199);
   while($l < 200)
   {
    while(in_array($j, $count))
        {
           $j = rand(0,199);
        }
        $count[$l] =  $j;
        $l++;
       
     }?>
    <?php
  $k = 0;
  for($k = 0;$k<count($count);$k++){
  ?>
  index = <?php echo $k;?>;
  <?php
        $indx = $count[$k];?>
  if(index == 0){
     slideimages[0] = '<img src="http://localhost/images/hbag044.jpg" name="r_img" id="0"/>';
     img_id[0] = '<input type="hidden" value="0" id="imgId" />';
  }
 
  else if(index > 0)
  {
    slideimages[<?php echo $k?>] = '<img src="<?php echo $img[$indx]?>" name="r_img" id="<?php echo $id[$indx]?>"/>';
     img_id[<?php echo $k?>] = '<input type="hidden" value="<?php echo $id[$indx]?>" id="imgId" />';
  }
<?php
}
?>


Can Any one plese help me

Appreciate your help...


Thanks

Not sure how to even search for what I'm looking for, which is to say I'm really in need of guidance. 

I have a pre-populated database that I set up with about 260 names in it.  It also has information like, height (basketball players) and high school.  It's a list of kids I mean to invite to play in a league.  From there, they will actually come to the league's site and register.

I'd like for my form to check to see if they are already in the database, and if they are just add personal information, like email and phone number.  If they are not, I'd like for the form to enter all of the information (name, school, etc).

I am pulling an youtube embedded code from a database however when I have the homepage pull it from the database it will not show anything after the video....

EXAMPLE...(this is what it should look like)

1.) Title By: Author
     Youtube Video
     Message
     Posted By:

(however this is what it looks like)

1.) Title By: Author
     Youtube Video
 
*The "message" and "Posted By:" just do not show up*

The code is below can someone help me with this problem., it would be greatly appreciated.


Code: [Select]
<?php
//open database
$connect = mysql_connect("Database","name","password") or die("Not connected");
mysql_select_db("database") or die("could not log in");

$query = "SELECT * FROM boox ORDER BY date DESC";
$result = mysql_query($query);

 // Get the page number, if none is set - it is 0
if( isset($_GET['page']) )
{ 
$page =$_GET['page']; 
}
else
{
$page  = 0;
}

$resultsPerPage = 15;
$num = mysql_num_rows($result); // amount of rows
$loops = $page*$resultsPerPage; // starting loops at..

while ($loops < $num && $loops <  ($page+1)*$resultsPerPage )
{
$link = mysql_result($result,$loops,"link"); // get result from the 'link' field in the table
$username = mysql_result($result,$loops,"username"); // get result from the 'username' field in the table
$messsage = mysql_result($result,$loops,"message");
$author = mysql_result($result,$loops,"author");
$title = mysql_result($result,$loops,"title");
$date = mysql_result($result,$loops,"date");
if ($pagelimit == 0)
{
$pagelimit == 1;
}
if ($pagelimit <= 15)
// echo stuff here
$loopz = $loops + 1;
 echo "&nbsp;&nbsp;&nbsp
 </br><align='left'><table width='297' height='900' border='1' align='center' bgcolor='#111'>
  <tr>
    <td>$loopz.)&nbsp;$title By: $author
</br>
$link
</br>
$message
</br>
Posted By: $username $date
</td>
  </tr>
</table></br><br>";
 $count++ ;
 $pagelimit++;
 $loops++;
}

if ( $page!=0 ) // Show 'Previous' link
{
$page--;
$prevpage = ($page +  1);
echo "<br><br><br><a href='index.php?page=$page'>Previous  $prevpage &nbsp;&nbsp;&nbsp;&nbsp;</a>";
$page++;
}
if ($loops > 5&&($page+1)*$resultPerPage < $num ) // Show 'next' link
{
$page++;
$nextpage = ($page + 1);
echo "<a href='index.php?page=$page'>   Next $nextpage</a>";
}
 
?>

Hi all,

Does anyone know if it's possible to generate a dropdown list filled with database information.
I use the following to get the information from the database:
$query                      = "SELECT Name
                               FROM city
                               WHERE member_ID = '$member_ID'";
$result                     = mysql_query($query)
                              or die(mysql_error());
while($row = mysql_fetch_assoc($result))
{
     echo $row['Name'] . '<br>';
}

Thnx Ryflex

hi everyone,
Im trying to make a checkout page, where if the user is logged in, the address information is called from the database and fills the form automatically, my problem is i don't know how to fill the php variables with the result of my sql query..sorry to be a complete noob but can someone explain how i would do this?
<?php
if (!defined('WEB_ROOT')
    || !isset($_GET['step']) || (int)$_GET['step'] != 1) {
exit;
}
require_once 'loginfunctions.php';
checkCustomerLogin();
$errorMessage = '&nbsp;';
?>

<?php
// get the customer id from the session.
$cu_id = $_SESSION['cu_id']
?>
<?php
//connect to server
$mysqli = mysqli_connect("localhost", "root", "", "onlinestore");
//get default shipping and payment address
$mysql = "SELECT cu_id,od_shipping_first_name,od_shipping_last_name,od_shipping_address1,od_shipping_address2,od_shipping_phone,od_shipping_city,od_shipping_state,od_shipping_postal_code FROM tbl_customer WHERE $cu_id = cu_id";
$result = mysqli_query($mysql,$mysqli);
$row = mysql_fetch_assoc($result);
//populate form with values ?
$txtShippingFirstName = 'test';
$txtShippingLastName = 'test';
$txtShippingAddress1 = 'test';
$txtShippingAddress2 = 'test';
$txtShippingPhone = 'test';
$txtShippingState = 'test';
$txtShippingCity = 'test';
$txtShippingPostalCode = 'test';
?>

<script language="JavaScript" type="text/javascript" src="library/checkout.js"></script>
<table width="550" border="0" align="center" cellpadding="10" cellspacing="0">
    <tr> 
        <td>Step 1 Of 3 : Please Confirm Shipping And Payment Information </td>
    </tr>
</table>
<p id="errorMessage"><?php echo $errorMessage; ?></p>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>?step=2" method="post" name="frmCheckout" id="frmCheckout" onSubmit="return checkShippingAndPaymentInfo();">
    <table width="550" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">
        <tr class="entryTableHeader"> 
            <td colspan="2">Shipping Information</td>
        </tr>
        <tr> 
            <td width="150" class="label">First Name</td>
            <td class="content"><input name="txtShippingFirstName" type="text" class="box" id="txtShippingFirstName" value="<?php echo $txtShippingFirstName ?>" size="30" maxlength="50"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Last Name</td>
            <td class="content"><input name="txtShippingLastName" type="text" class="box" id="txtShippingLastName" value="<?php echo $txtShippingLastName ?>" size="30" maxlength="50"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Address1</td>
            <td class="content"><input name="txtShippingAddress1" type="text" class="box" id="txtShippingAddress1" value="<?php echo $txtShippingAddress1 ?>" size="50" maxlength="100"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Address2</td>
            <td class="content"><input name="txtShippingAddress2" type="text" class="box" id="txtShippingAddress2" value="<?php echo $txtShippingAddress2 ?>" size="50" maxlength="100"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Phone Number</td>
            <td class="content"><input name="txtShippingPhone" type="text" class="box" id="txtShippingPhone" value="<?php echo $txtShippingPhone ?>" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Province / State</td>
            <td class="content"><input name="txtShippingState" type="text" class="box" id="txtShippingState" value="<?php echo $txtShippingState ?>" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">City</td>
            <td class="content"><input name="txtShippingCity" type="text" class="box" id="txtShippingCity" value="<?php echo $txtShippingCity ?>" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Postal / Zip Code</td>
            <td class="content"><input name="txtShippingPostalCode" type="text" class="box" id="txtShippingPostalCode" value="<?php echo $txtShippingPostalCode ?>" size="10" maxlength="10"></td>
        </tr>
    </table>
    <p>&nbsp;</p>
    <table width="550" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">
        <tr class="entryTableHeader"> 
            <td width="150">Payment Information</td>
            <td><input type="checkbox" name="chkSame" id="chkSame" value="checkbox" onClick="setPaymentInfo(this.checked);"> 
                <label for="chkSame" style="cursor:pointer">Same as shipping information</label></td>
        </tr>
        <tr> 
            <td width="150" class="label">First Name</td>
            <td class="content"><input name="txtPaymentFirstName" type="text" class="box" id="txtPaymentFirstName" size="30" maxlength="50"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Last Name</td>
            <td class="content"><input name="txtPaymentLastName" type="text" class="box" id="txtPaymentLastName" size="30" maxlength="50"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Address1</td>
            <td class="content"><input name="txtPaymentAddress1" type="text" class="box" id="txtPaymentAddress1" size="50" maxlength="100"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Address2</td>
            <td class="content"><input name="txtPaymentAddress2" type="text" class="box" id="txtPaymentAddress2" size="50" maxlength="100"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Phone Number</td>
            <td class="content"><input name="txtPaymentPhone" type="text" class="box" id="txtPaymentPhone" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Province / State</td>
            <td class="content"><input name="txtPaymentState" type="text" class="box" id="txtPaymentState" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">City</td>
            <td class="content"><input name="txtPaymentCity" type="text" class="box" id="txtPaymentCity" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Postal / Zip Code</td>
            <td class="content"><input name="txtPaymentPostalCode" type="text" class="box" id="txtPaymentPostalCode" size="10" maxlength="10"></td>
        </tr>
    </table>
    <p>&nbsp;</p>
    <table width="550" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">
      <tr>
        <td width="150" class="entryTableHeader">Payment Method </td>
        <td class="content">
        <input name="optPayment" type="radio" id="optPaypal" value="paypal" checked="checked" />
        <label for="optPaypal" style="cursor:pointer">Paypal</label>
        <input name="optPayment" type="radio" value="cod" id="optCod" />
        <label for="optCod" style="cursor:pointer">Cash on Delivery</label></td>
      </tr>
    </table>
    <p>&nbsp;</p>
    <p align="center"> 
        <input class="box" name="btnStep1" type="submit" id="btnStep1" value="Proceed &gt;&gt;">
    </p>
</form>

I have a form gathering data from the database. There is one field 'country' which is a combo box. The combo box is populated from the countries table which joins the customers table to provide the country specific to the customer. I'm trying to have the combo box display the country associated with the customer. I think I'm close in my code, but unsure. This is a playground to so I can implement on our other site. 

<?php
require_once('database.php');
$sql2 = "SELECT * From countries
";
$countries = $db->query($sql2);

if(isset($_GET['customerID'])) {
    $customerID = filter_input(INPUT_GET, 'customerID', FILTER_SANITIZE_NUMBER_INT);
    $sql = "SELECT * FROM customers  WHERE customerID =$customerID ";
//$sql2 = "SELECT * From countries
//INNER JOIN customers ON countries.countryCode=customers.countryCode
//WHERE customers.customerID = $customerID";
    $stmt = $db->query($sql);
}
if(isset($_GET['customerID'])){
    $customerID = filter_input(INPUT_GET, 'customerID', FILTER_SANITIZE_NUMBER_INT);
    $countryQuery = "
    {$sql2} INNER JOIN customers ON countries.countryCode = customers.countryCode WHERE customers.customerID = $customerID";

    $countriesQuery = $db->prepare($countryQuery);
    $countriesQuery->execute(['customerID' => $_GET['customerID']]);

    $selectedCountry = $countriesQuery->fetch(PDO::FETCH_ASSOC);

    var_dump($selectedCountry);

}

?>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<!-- the head section -->
<head>
    <title>My Guitar Shop</title>
    <link rel="stylesheet" type="text/css" href="main.css" />
</head>

<!-- the body section -->
<body>
<div id="page">

    <div id="header">
        <h1>SportsPro Technical Support</h1>
        <p>Sports management software for the sports enthusiast.</p></h1>
    </div>

    <div id="main">

        <h1>View/Update Customer</h1>

        <form action="update.php" method="get" >
        <?php




        ?>
        <div id="content">
            <!-- display a table of products -->
            <h2>Customers</h2>
            <form  name="customerInfo">
               <?php foreach ($stmt as $cust) { ?>
                <div>
                    <label>First Name</label>
            <input type="text" name="name" class ="form-control" value ="<?php echo $cust['firstName']; ?>">
            </div><br>
                <div>
                    <label>Last Name</label>
                    <input type="text" name="name" class ="form-control" value ="<?php echo $cust['lastName']; ?>">
                </div><br>
            <div>
            <label>Address</label>
            <input type="text" name="address" class ="form-control" value ="<?php echo $cust['address']; ?>">
                </div><br>
                <div>
                    <label>City</label>
            <input type="text" name="city" class ="form-control" value ="<?php echo $cust['city']; ?>">
                </div><br>
                <div>
                    <label>State</label>
            <input type="text" name="state" class ="form-control" value ="<?php echo $cust['state']; ?>">
                </div><br>
                <form action="update.php" method="get">
                    <select name="country">
                        <option value=""></option>
                        <?php
                        foreach ($countries->fetchAll() as $country): ?>
                            <option value="<?php echo $country['customerID']; ?>
                          <?php echo isset($customerID) == $selectedCountry['customerID'] ? ' selected':''?>
                            "><?php echo $country['countryName']; ?></option>

                        <?php endforeach;?>

                    </select>


                </form>
                </div>



                <br>
                <div>
                    <label>Country Code</label>
            <input type="text" name="countryCode" class ="form-control" value ="<?php echo $cust['countryCode']; ?>">
                </div><br>
                <div>
                    <label>Zip Code</label>
            <input type="text" name="postalCode" class ="form-control" value ="<?php echo $cust['postalCode']; ?>">
                </div><br>
                <div>
                    <label>Email </label>
            <input type="text" name="email" class ="form-control" value ="<?php echo $cust['email']; ?>">
                </div><br>
                <div>
                    <label>Phone Number </label>
            <input type="text" name="phone" class ="form-control" value ="<?php echo $cust['phone']; ?>">
                </div><br>
                <div>
                    <label>Password </label>
            <input type="text" name="password" class ="form-control" value ="<?php echo $cust['password']; ?>">
                </div><br>
                <div>

                <?php    }

                                ?>


        </div>

    </div>
            <form action="UpdateCustomer.php" method="get">
                <input   type="submit" name="data" value="Update_Data"></input>
            </form>
    <div id="footer">
        <p>
            © <?php echo date("Y"); ?> SportsPro, Inc.
        </p>
    </div>

</div><!-- end page -->
</body>
</html>

 

Hi. I'm not so sure if this falls into the category of php (since I'm not even remotely sure how to do this), but I'd like to set up an email address, that, when it receives an email, automatically inserts the contents of that email into a database (for example, if the email is:

name: Bob
phone: 5556667777

Then it would enter "Bob" into the "name" column of a new row, and "5556667777" into the "phone" column of that same row.

Does anybody know how I can go about doing this (php or not), or if it's possible at all?

Thanks,
ARWebDesign

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=347193.0

Hi, Webapp noob here.   I have an application that is going to be data-heavy, so I would like to avoid saving things to the database whenever possible. The application in a nutshell is an android application wired up to a php web app(with MySQL) where you can send requests to the phone and the phone will respond with text or image data with POST.   The normal way to do this would be for the phone to post the data to the database, then have the webapp display it. However, what im wondering is if it is possible for a user on the webapp to request information from the phone, and then when the phone replies using a POST to display the information temporarily in maybe a popup window instead of having to save it to the database.     Thanks!

Hi,

I have created a session based logon system using php and MYSQL from some tutorials I found online which is working very successfully. I can log on and of and move through different pages with no problems.

My query is how do I output or display the information that is specific to the user which is currently logged on and block access to any other users information. I am quite sure there is a simple solution that is escaping me.

If you could point me in the right direction it would be greatly appreciated.

Thanks in advance

I am having a lot of trouble with this code, and I have no clue how to fix it.  Right now, I have a GUI for a fictitious car dealership that has 5 populated drop down menus called Make, Model, Year, Color, and Mileage.  What I want the code to do is read the selections made by the user with the drop down menus once the user hits the submit button and then filter the tables that I have in a mysql database to meets the choice requirements of the user.

The code will bring up the GUI, but once I hit the submit button, I get the following errors

Please if anyone can help me that would be fantastic.  I really have no clue

Hi All,

I Have an issue validating and inserting the data in to the database.

I am beginner and the error message is new to me however i have google it but unable to find

hope any one can help

Thanks in advanced.


Error :

"Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\signupck.php on line 32

Deprecated: Function eregi() is deprecated in C:\wamp\www\signupck.php on line 50
Welcome, You have successfully signed up

Click here to login"

Please find the Code Below:

File name:signup.php
Code: [Select]
<!doctype html public "-//w3c//dtd html 3.2//en">
<html>
<head>
<title>Fast Fix Pro Signup</title>
<script type="text/javascript">
function validate(form) {
   

if(form1.userid.value == "")
  {
    alert('Please enter userid ');
    form1.userid.focus();
           return false;
  }
 
 if(form1.userid.value == "")
  {
    alert('Please enter userid ');
    form1.userid.focus();
           return false;
  }
 
  if(form1.password.value == "")
  {
    alert('Please enter password ');
    form1.password.focus();
           return false;
  }
 
    if(form1.password2.value == "")
  {
    alert('Please renter the password ');
    form1.password2.focus();
           return false;
  }
 
 
  if(form1.email.value == "")
  {
    alert('Please enter Email ');
    form1.email.focus();
           return false;
  }
  if(form1.fname.value == "")
  {
    alert('Please enter First Name ');
    form1.fname.focus();
           return false;
  }
 
    if(form1.lname.value == "")
  {
    alert('Please enter Last Name ');
    form1.lname.focus();
           return false;
  }


if (!document.form1.agree.checked) { alert("Please Read the guidlines and check the box below  .");

 return false; }

return true;

}
</script>
</head>
<body bgcolor="#ffffff" text="#000000" link="#0000ff" vlink="#800080" alink="#ff0000">
<br/>
<br/>
<table width='67%' height="454" border='0' align=center cellpadding='0' cellspacing='0'><form name="form1" method=post action="signupck.php" onsubmit='return validate(this)'><input type="hidden" name="todo" value=post>



<tr bgcolor='#f1f1f1'><td align=center colspan=2><font face='Verdana' size='2' ><b>Signup</b></td></tr>

<tr bgcolor='#f1f1f1'><td >&nbsp;<font face='Verdana' size='2' >User ID</td><td ><font face='Verdana' size='2'><input type=text name=userid></td></tr>



<tr ><td >&nbsp;<font face='Verdana' size='2' >Password</td><td ><font face='Verdana' size='2'><input name=password type=password></td></tr>

<tr bgcolor='#f1f1f1'><td >&nbsp;<font face='Verdana' size='2' >Re-enter Password</td><td ><font face='Verdana' size='2'><input name=password2 type=password></td></tr>

<tr ><td ><font face='Verdana' size='2' >&nbsp;Email</td><td  ><input type=text name=email></td></tr>

<tr bgcolor='#f1f1f1'><td >&nbsp;<font face='Verdana' size='2' >First Name</td><td ><font face='Verdana' size='2'><input type=text name=fname></td></tr>

<tr ><td >&nbsp;<font face='Verdana' size='2' >Last Name</td><td ><font face='Verdana' size='2'><input type=text name=lname></td></tr>


<tr bgcolor='#f1f1f1' ><td >&nbsp;<font face='Verdana' size='2' >I agree to terms and conditions</td><td ><font face='Verdana' size='2'><input type=checkbox name=agree value='yes'></td></tr>

<tr ><td align=center colspan=2><input type=submit value=Signup>
    <input name="Reset" type=reset value=Reset>
<td colspan=2 align=left>&nbsp;</td></td></tr>

</table>
<center>
<br><font face='Verdana' size='2' ><a href='login.php'>Already a member ? Please Login</a></font></center>
</body>
</html>


File Name :signuppck.php
Code: [Select]
<?php

include ("Connection.php");// database connection details stored here

?>

<!doctype html public "-//w3c//dtd html 3.2//en">

<html>

<head>
<title>(Type a title for your page here)</title>
<meta name="GENERATOR" content="Arachnophilia 4.0">
<meta name="FORMATTER" content="Arachnophilia 4.0">
</head>

<body bgcolor="#ffffff" text="#000000" link="#0000ff" vlink="#800080" alink="#ff0000">

<?php
extract($_POST); //<---I don't recommand this really

if(isset($todo) and $todo=="post")
{
   $status = "OK";
   $msg="";
   // if userid is less than 3 char then status is not ok
   if(!isset($userid) or strlen($userid) <3)
   {
      $msg=$msg."User id should be =3 or more than 3 char length<BR>";
      $status= "NOTOK";
   }
   if(mysql_num_rows(mysql_query("SELECT userid FROM signup WHERE userid = '$userid LIMIT 1' ")))  <-------------------(line 32)
   {
      $msg=$msg."Userid already exists. Please try another one<BR>";
      $status= "NOTOK";
   }

   if ( strlen($password) < 3 )
   {
      $msg=$msg."Password must be more than 3 char legth<BR>";
      $status= "NOTOK";
   }

   if ( $password <> $password2 )
   {
      $msg=$msg."Both passwords are not matching<BR>";
      $status= "NOTOK";
   }
   
   if (!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $email))  <--------------- (Line 50)
   { 
      $msg=$msg."enter valid email address<BR>";
      $status= "NOTOK";
   }
   if ($agree<>"yes")
   {
      $msg=$msg."You must agree to terms and conditions<BR>";
      $status= "NOTOK";
   }

   if($status<>"OK")
   { 
      echo "<font face='Verdana' size='2' color=red>$msg</font><br><input type='button' value='Retry' onClick='history.go(-1)'>";
   }else{ // if all validations are passed.
      $query=mysql_query("INSERT INTO signup(userid,password,email,Fname,Lname) values('$userid','$password','$email','$fname','$lname')");;
   echo "<font face='Verdana' size='2' color=green>Welcome, You have successfully signed up<br><br><a href=login.php>Click here to login</a><br></font>";
   }

}

?>



</body>



</html>

File Name :<include file>
Code: [Select]
<HTML>
<HEAD>
 <TITLE>Connecting to Database</TITLE>
</HEAD>
<BODY>

<?php
$db = "quantas";
mysql_connect("localhost","root","") or die (mysql_error());
mysql_select_db($db);
?>
</BODY>
</HTML>