PHP - Checking If Data Exists [loop]

Hi Guys,

I'm using the following code to write emails to a .txt file:



                // Write the email to file
                $leadsFile = "leads/emails.txt";
                $fh = fopen($leadsFile, 'a') or die ("can't open leads file!");
                $writeData = "$conEM\r\n";
                fwrite($fh, $writeData);
                fclose($fh); 


which works great, but i can't figure out how to NOT write an email to the .txt file if it's already on it, i'm not using a database for a change i'm stumped lol

thanks for any help guys

Graham

I have come across couple of similar answers for my question in this form, but could not solve my exact problem. Therefore I am posting this he

I have an xml file as shown below:

<?xml version="1.0" encoding="ISO-8859-1"?>
    <document>
        <user>
            <user_id>0121</user_id>
            <name>Tim</name>
            <file>0121.file</file>
        </user>

        <user>
            <user_id>0178</user_id>
            <name>Henry</name>
            <file>0178.file</file>
        </user>

        <user>
            <user_id>0786</user_id>
            <name>Martin</name>
            <file>0786.file</file>
        </user>

        <user>
            <user_id>1239</user_id>
            <name>Jan</name>
            <file>1239.file</file>
        </user>
    </document>
I ask the user to input his user_id and post this user_id and perform a check on the entire xml file to check whether the entered user_id exists in the xml file or not. If exists then I go further if not echo a error message. Can anybody pull me out of this?

Thanks

My error below returns (echos) that there is no data under the table sites to display. But, there is. Why is it doing this?

class_l.php

<?php

class displaySites 
{

function grabSites()

{

$query = mysql_query("SELECT title,description,votes,dates,comments,out,in FROM sites ORDER BY id DESC LIMIT 100");

if(mysql_num_rows($query) > 0)

{

while($fetch = mysql_fetch_assoc($query))

{

echo "

<div id='post-1' class='post'>

<h2 class='title'><a href='#'>". $fetch['title'] ."</a></h2>

<h3 class='date'>Submitted on ". $fetch['date'] ."</h3>

<div class='entry'>

<p>". nl2br(stripslashes($fetch['description'])) ."</p>

</div>

<p class='meta'><a href='#'>View</a></p>

<div class='hr'>

</div>

</div>

";

}

}

else

{

echo "

<div id='post-1' class='post'>

<h2 class='title'><a href='#'>Oh NOEZ!</a></h2>

<h3 class='date'>". date("M-d-Y") ."</h3>

<div class='entry'>

<p>There are currently no sites to display!</p>

</div>

<p class='meta'>View</p>

<div class='hr'>

<hr />

</div>

</div>

";

}

}
}

class register
{

function createAccount()

{

$username = mysql_real_escape_string($_POST['username']);

$password = md5(sha1(sha1($_POST['password'])));

$name = mysql_real_escape_string($_POST['title']);

$description = mysql_real_escape_string($_POST['description']);

if(isset($username) && isset($password) && isset($name) && isset($description))

{

if(!$username || !$password || !$name || !$description)

{

echo '<table border="0"><form action="register.php" method="POST">

<tr><td>Username</td><td><input type="text" name="username" maxlength="20"></td></tr>

<tr><td>Password</td><td><input type="text" name="password" maxlength="30"></td></tr>

<tr><td>Site Name</td><td><input type="text" name="title" maxlength="25"></td></tr>

<tr><td>Site Description</td><td><textarea cols="40" rows="18" name="description" maxlength="750"></textarea></td></tr>

<tr><td>Finish!</td><td><input type="submit"></td></tr>

</form></table>';

}

else

{

$query = mysql_query("SELECT * FROM sites WHERE username = '$username' LIMIT 1");

if(mysql_num_rows($query) > 0)

{

echo "Sorry, an account with this username already exists.";

}

else

{

$date = date("M-d-Y");

$ip = $_SERVER['REMOTE_ADDR'];

//create their account

mysql_query("INSERT INTO sites VALUES (null, '$username', '$password', '$name', '$description', 0, 0, 0, '$date', '$ip', 0)");

echo "You have successfully registered your site on NovaTops! <a href='login.php'>Login</a>";

}

}

}

else

{

echo "One or more of the variables are not set.";

}

}
}

class login 
{

function verifyLogin()

{

$username = mysql_real_escape_string($_POST['username']);

$password = md5(sha1(sha1($_POST['password'])));

if(isset($username) && isset($password))

{

if(!$username || !$password)

{

echo "<table><form action='login.php' method='POST'>

<tr><td>Username</td><td><input type='text' name='username' maxlength='20'></td></tr>

<tr><td>Password</td><td><input type='password' name='password' maxlength='30'></td></tr>

<tr><td>Finished?</td><td><input type='submit'></td></tr>

</form></table>";

}

else

{

$query = mysql_query("SELECT * FROM sites WHERE username = '$username' AND password = '$password'LIMIT 1");

if(mysql_num_rows($query) > 0)

{

echo "Congratulations! You have successfully logged in! <a href='index.php'>Home</a>";

$_SESSION['user'] = $username;

}

else

{

echo "It seems you've typed in the wrong username and/or password. <a href='login.php'>Try Again</a>";

}

}

}

else

{

echo "One or more of the variables aren't set.";

}

}
}
?>


index.php


<?php
include_once('includes/config.php');
include_once('class_l.php');

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title><?php echo $title; ?></title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="styles.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="wrapper">
   <div class="top_text"><h1><a href="#"><?php echo $site_name; ?></a></h1>

    <h2><a href="#"><?php echo $slogan; ?></a></h2></div>

<div id="content">

<div id="blog">

<div id="post-1" class="post">

<h2 class="title"><a href="#">Welcome to NovaTops!</a></h2>

<h3 class="date">Created on April 06, 2011</h3>

<div class="entry">

<p>Hello there! If your viewing this message right now, your on the awesome site called NovaTops! NovaTops allows you to register

your site in our database, and then the site's script automatically starts to rank your site. The higher your rank, the more likely

your site's going to get a ton of views!</p>

</div>

<div class="hr">

<hr />

</div>

</div>

<!-- end #post-1 -->

<?php

$displaySites = new displaySites();

$displaySites->grabSites();

?>

</div>

<!-- end #blog -->

<?php include_once('includes/navigation.php'); ?>

<!-- end #sidebar -->

<div style="clear: both; height: 1px;"></div>

</div>

<!-- end #content -->

<div id="footer">

<p>Copyright &copy; 2011. Design by <a href="http://www.flashtemplatesdesign.com/" title="Free Flash Templates">Free Flash Templates</a></p>

<p><a href="#">Privacy Policy</a> | <a href="#">Terms of Use</a> | <a href="http://validator.w3.org/check/referer" title="This page validates as XHTML 1.0 Transitional"><abbr title="eXtensible HyperText Markup Language">XHTML</abbr></a> | <a href="http://jigsaw.w3.org/css-validator/check/referer" title="This page validates as CSS"><abbr title="Cascading Style Sheets">CSS</abbr></a></p>

</div>
</div>
<!-- end #wrapper -->
</body>
</html>

Hi,

I want to make a query and check if data  exists already on my
is_availble table on calendar db tomake it unavailble .
I have 16 checkboxs.

I have this code for first one. And I did it for second one alse, although
data dosen't exist  on db, but it makes it also unvailble!

Here you can see my php code:

PHP Code:
Code: [Select]
<?php
mysql_select_db("calendar", $con);

$result2 = mysql_query("SELECT * FROM is_availble WHERE datetime=$v_datetime ");
//---------------------------------- choeckbox 1(bookable time 1)------------------------\\


echo"<div  class='box'>
<div class='boxbut'>";
if($result2)  {
echo" Booked ";
}
else{
echo" <input type='radio' name='datetime' value='". $row['day1']."&nbsp;&nbsp;&nbsp;".$row['time1']."'>
<d>". $row['day1'] ,"</d><br/><t>". $row['time1'] ."</t>";
}
echo"</div></div>";
//---------------------------------- choeckbox 2(bookable time 2)------------------------\\
echo"<div  class='box'>
<div class='boxbut'>";

if ($result2) {
echo" Booked ";
}
else{
echo" <input type='radio' name='datetime' value='". $row['day1']."&nbsp;&nbsp;&nbsp;".$row['time2']."'>
<d>". $row['day1'] ,"</d><br/><t>". $row['time2'] ."</t>";
}
echo"</div></div>";
 
Regards

Hello All,

Attached are 2 screenshots of the form and output for better reference.

What I am trying to do is select all or some checkboxes and for those boxes that are checked, echo out their Payment Method.

---If a checkbox is checked but the Payment Method box == select, give an error.

---If checkbox is checked and Payment Method != select, echo out the ID and selection from the drop down box.

Currently, I am echoing the correct ID(s) when certain boxes are checked, but I'm getting every drop down box selection when the corresponding box is not selected.

Any help would be greatly appreciated.

This is the HTML / PHP Form:

$results .= '<table align="center" width="70%" border="0" bgcolor="'.$bg.'" cellpadding="2" cellspacing="0" class="resultsUnderline">';
$results .= '<tr>';
$results .= '<td width="30%" align="left">'.'<input type="checkbox" name="checkbox[]" value="'.$app_pmt_id.'" id="checkbox" />'
.$full.'<FONT size="1" color="maroon"> ( '.$app_id.' )</FONT></td>';
$results .= '<td width="30%" align="center">'.$created.'</td>';
$results .= '<td width="20%" align="center">
<select name="pay_method[]" class="drop" id="pay_method">
<option value="select">-- Method --</option>
<option value="check">Check</option>
<option value="credit">Credit Card</option></td>';
$results .= '<td width="10%" align="center">'.$paid.'</td>';
$results .= '<td width="10%" align="right">'.$fee.'</td>';
$results .= '</tr>';
$results .= '</table>';

Here is the PHP getting the results:
if(isset($_POST['action_box']) && $_POST['action_box'] == 'mark_paid')
{
    $checked = array();
    $checked2 = array();
    
    if(!isset($_POST['checkbox']))
    {
        $val_error[] = 'You have not selected any applications.';
    }
        elseif($_POST['pay_method'] == 'select')
        {
            $val_error[] = 'Please select a Payment Method.';
        }
    else
    {
        foreach($_POST['checkbox'] as $value)
        {
            $checked[] = $value;
        }
        foreach($_POST['pay_method'] as $value2)
        {
            $checked2[] = $value2;
        }
            
        echo implode(",", $checked);
        echo implode(",", $checked2);

        //$result = mysql_query("UPDATE app_pmt SET paid = '1' WHERE app_pmt_id IN(" . implode(",", $checked) . ")");
        //header('Location: bal_due.php?id='.$_GET['id']);
    }
}

Hello. I want to check if an e-mail address is stored into a database. I've found this type of code:

Code: [Select]
function verifmail($email)
{
    db_connect();
    if (mysql_num_rows(mysql_query("SELECT email FROM users WHERE email='$email';")))
    {
        return 1;
    }
    else
    {
        return 0;
    }
}
Is it correct ? Is there any other way?

I'm terrible at getting my question clear, but this is my last try.
I got this which gets sent when clicking the button;
 

                    echo"Auto/Prijs<br><br><select name='autos'>";
                echo"<br><br>";
                        
                $sql = "SELECT `garage`.`id`, `car_id`, `schade`, `naam`, `prijs` FROM `garage` LEFT JOIN `cars` ON (`garage`.`car_id` = `cars`.`id`) WHERE `user_id`=".ID." ORDER BY `id` ASC LIMIT ".($page * 10).", 10";
    $sql = mysql_query($sql) or die(mysql_error());
        $i = 1;
    while($res = mysql_fetch_assoc($sql)){
        echo"
        
    
    <option value='".$res['car_id']."'>".$res['naam']."</option><br>
        ";

This is a dropdown, showing carnames instead of car_id's.
Now, the car_id is not unique, but refers to a car. The 'id' in the 'garage' table IS unique. Am I able to like call the 'id' too, and on sending check if that ID is actually the sent 'car_id'? Because, you can tamper the sent car_id and simply change it.

This happens on sending:

    if(isset($_POST['start'])){
    $prijs = $_POST['prijs'];
    $carr = $_POST['autos'];
    $sql = mysql_query("SELECT `id` FROM `automarkt` WHERE `seller_id`=".ID." LIMIT 1") or die(mysql_error());
    mysql_query("INSERT INTO `automarkt`(`seller_id`, `prijs`, `car_id`) VALUES (".ID.", ".$prijs.", ".$carr.")") or die(mysql_error());

I'm out of idea's, and can't get clear enough on what I need to do. I need to check if the sent car_id is actually in the 'user''s garage. (Trying to do it by checking the unique entry 'id' in the 'garage' table.

Hi there,

I was thinking of using this following check system to see if a user has entered a good valid value for a categories selection, but it is just is_numeric, here's my line of single code for this:

Code: [Select]
if(!array_key_exists('category', $_GET) || trim(is_numeric($_GET['category'])) == '')
Is there anything better that I can be using than is_numeric()?

I mean this would allow 2.22 which for the categories selection, would not be valid, I will only be allowing integer values, I mean it would potentially come up with no category selected but that wouldn't be very good would it?

It could be applied to a blog I am doing aswell, any guidance on such an improvement on this function would very much be appreciated,
Jeremy.

Friends,

I want to check a site if there is any data avaliable for a given Domain Name....

For example

Quote

http://www.keywordspy.com/research/search.aspx?tab=domain-organic&market=uk&q=abc.co.uk


In this URl the Domain is the "&q=" POST Parameter which is: abc.co.uk

In the Output, Observe the Columns Keyword, Position, Volume etc.... So for any Domain we want to check if there is one or more keyword returned.

Here is the Example of a Domain for which there is no Data:

Quote

http://www.keywordspy.com/research/search.aspx?tab=domain-organic&market=uk&q=notfoundforme.co.uk


As you Observe there is no data in Keyword, Position or Volume Columns for this Domain (i.e. notfoundforme.co.uk)

All i want is to Echo All the Keywords, their Position and Volumes for any domain for which data is avaliable.

Code:

Here is the Code i have which scrapes the Whole data with Curl, but i am not able to make getkwspydata function work to get the  Keyword, Position or Volume data for the domain, i know some regex and preg_match needs to be done but its too technical for me, may someone help me with this?


<?php


function getkwspydata($host) {
$request = "http://www.google.com/search?q=" . urlencode("site:" . $host) . "&amp;hl=en";
    
    $request = "http://www.keywordspy.com/research/search.aspx?tab=domain-organic&market=uk&q=". urldecode($host);
    
$data = getPageData($request);
// preg_match('/<div id=resultStats>(About )?([\d,]+) result/si', $data, $p);
// $value = ($p[2]) ? $p[2] : "n/a";
// $string = "<a href=\"" . $request . "\">" . $value . "</a>";
//return $string;
    
    print_r($data);
}



function getDomainName($host) {
$hostparts = explode('.', $host); // split host name to parts
$num = count($hostparts); // get parts number
if(preg_match('/^(ac|arpa|biz|co|com|edu|gov|info|int|me|mil|mobi|museum|name|net|org|pp|tv)$/i', $hostparts[$num-2])) { // for ccTLDs like .co.uk etc.
$domain = $hostparts[$num-3] . '.' . $hostparts[$num-2] . '.' . $hostparts[$num-1];
}
else {
$domain = $hostparts[$num-2] . '.' . $hostparts[$num-1];
}
return $domain;
}






function getPageData($url) {
if(function_exists('curl_init')) {
$ch = curl_init($url); // initialize curl with given url
curl_setopt($ch, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']); // add useragent
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // write the response to a variable
if((ini_get('open_basedir') == '') && (ini_get('safe_mode') == 'Off')) {
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true); // follow redirects if any
}
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 5); // max. seconds to execute
curl_setopt($ch, CURLOPT_FAILONERROR, 1); // stop when it encounters an error
return @curl_exec($ch);
}
else {
return @file_get_contents($url);
}
}


$sitehost = ($_POST['sitehost']) ? $_POST['sitehost'] : $_SERVER['HTTP_HOST'];
$sitedomain = getDomainName($sitehost);

?>
<html>
<head>
<title>SEO Report for <?=$sitedomain;?></title>
</head>
<body>
<form method="post" action="<?$_SERVER['PHP_SELF'];?>">
<p><b>Domain/Host Name:</b> <input type="text" name="sitehost" size='30' maxlength='50' value="<?=$sitehost;?>"> <input type="submit" value="Grab Details"></p>
</form>
<ul>
<li>Google indexed pages: <?=getkwspydata($sitehost);?></li>

</ul>
</body>
</html>

Cheers
Natasha T.

Hi..

Sorry, if I need to repost my problem in while loop. cause until now I can't resolve my problem in saving all data from while loop.

I have this code StockRequisition.php where FORM was displayed.

<?php                                                                          
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date =date('Y-m-d H:i:s');

        $sql = "SELECT sr_number FROM stock_requisition ORDER BY sr_date DESC LIMIT 1";
        $result = mysql_query($sql, $con);
        
        if (!$result) {
            echo 'failed'; 
            die();
        }
        $total = mysql_num_rows($result);
        if ($total <= 0) {
            $currentSRNum = 1;
            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD) 
            {  
                $currentSRNum = 1;
            } 
            else 
            {  
                $currentSRNum += 1;
            }        
            
        } 
        else {
//------------------------------------------------------------------------------------------------------------------
            // Stock Number iteration.... 
            $row = mysql_fetch_assoc($result);
            
            $currentSRNum = (int)(substr($row['sr_number'],0,3));
            
            $currentSRYear  = (int)(substr($row['sr_number'],2,2));
            $currentSRMonth = (int)(substr($row['sr_number'],0,2));
            $currentSRNum = (int)(substr($row['sr_number'],6,4));
            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD) 
            {  
                $currentSRNum = 1;
            } 
            else 
            {  
                $currentSRNum += 1;
            }                                           
        }
//------------------------------------------------------------------------------------------------------------------         
        $yearMonth = date('ymd');    
        $currentSR = $currentYMD . sprintf("%04d", $currentSRNum);   
?>
<html>
<title>Stock Requisition</title>
<head>
<link rel="stylesheet" type="text/css" href="kanban.css">

<script type="text/javascript">
function save_sr(){
    var sr_date = document.getElementById("sr_date").value;
    var sr_number = document.getElementById("sr_number").value;
    var Items1 = document.getElementById("Items1").value;
    var SubItems = document.getElementById("SubItems").value;
    var ItemCode = document.getElementById("ItemCode").value;
    var DemandedQty = document.getElementById("DemandedQty").value;
    var UoM = document.getElementById("UoM").value;
    var Class = document.getElementById("Class").value;
    var Description = document.getElementById("Description").value;
    var BINLocation = document.getElementById("BINLocation").value;
    var RequestedBy = document.getElementById("RequestedBy").value;
    var ApprovedBy = document.getElementById("ApprovedBy").value;
    var ReceivedBy = document.getElementById("ReceivedBy").value;
    var IssuedBy = document.getElementById("IssuedBy").value;
    
    document.stock_requisition.action="StockRequisitionSave.php?sr_date="+sr_date+"&sr_number="+sr_number+"&Items1="+Items1+
    "&SubItems="+SubItems+"&ItemCode="+ItemCode+"&DemandedQty="+DemandedQty+"&UoM="+UoM+"&Class="+Class+"&Description="+
    Description+"&BINLocation="+BINLocation+"&RequestedBy="+RequestedBy+"&ApprovedBy="+ApprovedBy+"&ReceivedBy="+ReceivedBy+
    "&IssuedBy="+IssuedBy;
    document.stock_requisition.submit();
    alert("Stock Requisition data save.");
    window.location = "StockRequisition.php";
}
</script>
</head>
<body>
<form name="stock_requisition" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<div id="ddcolortabs">
<ul>
<li> <a href="ParameterSettings.php" title="Parameter Settings"><span>Parameter Settings</span></a></li>
<li style="margin-left: 1px"><a href="kanban_report.php" title="WIP Report"><span>Wip Report</span></a></li>
<li><a href="fsn.php" title="Finished Stock Note"><span>WMS FG</span></a></li>
<li id="current"><a href="StockRequisition.php" title="WMS RM"><span>WMS RM</span></a></li>

</ul>
</div>

<div id="ddcolortabs1">
<ul>
<li><a href="ReceivingMaterials.php" title="Receiving Materials"><span>Receiving Materials</span></a></li>
<li><a href="Shelving.php" title="Shelving"><span>Shelving</span></a></li>
<li id="current"><a href="StockRequisition.php" title="Stock Requisition"><span>Stock Requisition</span></a></li>
</ul>
</div>

<div id="SR_date">
<label>Date :</label>
<input type="text" name="sr_date" value="<?php echo $sr_date; ?>" size="16" readonly="readonly" style="border: none;">    
</div>
<div id="SR_number">
<label>SR# :</label>
<input type="text" name="sr_number" value="<?php echo $currentSR; ?>" size="10" readonly="readonly" style="font-weight: bold; border: none;">
<br/> 
</div> 
   <div>
<table>
<thead>
<th>Items</th>
<th>Sub Items</th>
<th>Item Code</th>
<th>Demanded Qty</th>
<th>UoM</th>
<th>Class</th>
<th>Description</th>
<th>BIN Location</th>
</thead>
<?php
$sql = "SELECT DISTINCT Items FROM bom_subitems ORDER BY Items";
$res_bom = mysql_query($sql, $con);

while($row = mysql_fetch_assoc($res_bom)){
    
    $Items = $row['Items'];
echo "<tr>
        <td style='border: none;font-weight: bold;'>&nbsp;<input type='name' value='$Items' name='Items' id='Items' readonly = 'readonly' style = 'border:none;width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='5'></td>
        </tr>";       
     
$sql = "SELECT Items, SubItems, ItemCode, UoM, Class, Description, BINLocation FROM bom_subitems WHERE Items = '$Items' ORDER BY Items"or die(mysql_error());

$res_sub = mysql_query($sql, $con);  
 
 while($row_sub = mysql_fetch_assoc($res_sub)){

     $Items1 = $row_sub['Items'];
     $SubItems = $row_sub['SubItems'];
     $ItemCode = $row_sub['ItemCode'];
     $UoM = $row_sub['UoM'];
     $Class = $row_sub['Class'];
     $Description = $row_sub['Description'];
     $BINLocation = $row_sub['BINLocation'];         
     
    echo "<tr>
        <td style='border: none;'>&nbsp;<input type='hidden' value='$Items1' id='Items1' name='Items1'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='SubItems' value='$SubItems' id='SubItems' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='ItemCode' value='$ItemCode' id='ItemCode' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'><center><input type='text' name='DemandedQty' id='DemandedQty' value='' size='7'></center></td>
        <td style='border: none;' size='3'>&nbsp;<input type='text' name='UoM' value='$UoM' id='UoM' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='3'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='Class' value='$Class' id='Class' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='Description' value='$Description' id='Description' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='BINLocation' value='$BINLocation' id='BINLocation' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>     
        </tr>";
}
}   
   
               
?>
</table>
</div>
<?php
   $RequestedBy = array('AAA', 'BBB', 'CCC', 'DDD');
   
   $ApprovedBy = array('EEE', 'FFF', 'GGG', 'HHH');
   
   $ReceivedBy = array('III', 'JJJ', 'KKK', 'LLL');
   
   $IssuedBy = array('MMM', 'NNN', 'OOO', 'PPP'); 

?>

 <div id='Requested_By'>
<label>Requested By:</label>
 <select name="RequestedBy">
 <option value="Select">Select</option>
 <option value="AAA" <?php if($_POST['RequestedBy'] == 'AAA') echo "selected='selected'"; ?>>AAA</option>
  <option value="BBB" <?php if($_POST['RequestedBy'] == 'BBB') echo "selected='selected'"; ?>>BBB</option>
 <option value="CCC" <?php if($_POST['RequestedBy'] == 'CCC') echo "selected='selected'"; ?>>CCC</option>
  <option value="DDD" <?php if($_POST['RequestedBy'] == 'DDD') echo "selected='selected'"; ?>>DDD</option>
 </select>
</div>

<div id='Approved_By'>
<label>Approved By:</label>
<select name="ApprovedBy">
<option name='Select'>Select</option>
<option value="EEE" <?php if($_POST['ApprovedBy'] == 'EEE') echo "selected='selected'"; ?>>EEE</option>
  <option value="FFF" <?php if($_POST['ApprovedBy'] == 'FFF') echo "selected='selected'"; ?>>FFF</option>
 <option value="GGG" <?php if($_POST['ApprovedBy'] == 'GGG') echo "selected='selected'"; ?>>GGG</option>
  <option value="HHH" <?php if($_POST['ApprovedBy'] == 'HHH') echo "selected='selected'"; ?>>HHH</option>
</select>
</div>

<div id='Received_By'>
<label>Issued By:</label>
<select name="IssuedBy">
<option name='Select'>Select</option>
<option value="III" <?php if($_POST['ReceivedBy'] == 'III') echo "selected='selected'"; ?>>III</option>
  <option value="JJJ" <?php if($_POST['ReceivedBy'] == 'JJJ') echo "selected='selected'"; ?>>JJJ</option>
 <option value="KKK" <?php if($_POST['ReceivedBy'] == 'KKK') echo "selected='selected'"; ?>>KKK</option>
  <option value="LLL" <?php if($_POST['ReceivedBy'] == 'LLL') echo "selected='selected'"; ?>>LLL</option>

</select>
</div>

<div id='Issued_By'>
<label>Received By:</label>
<select name="ReceivedBy">
<option name='Select'>Select</option>
<option value="MMM" <?php if($_POST['IssuedBy'] == 'MMM') echo "selected='selected'"; ?>>MMM</option>
  <option value="NNN" <?php if($_POST['IssuedBy'] == 'NNN') echo "selected='selected'"; ?>>NNN</option>
 <option value="OOO" <?php if($_POST['IssuedBy'] == 'OOO') echo "selected='selected'"; ?>>OOO</option>
  <option value="PPP" <?php if($_POST['IssuedBy'] == 'PPP') echo "selected='selected'"; ?>>PPP</option>

</select>
</div>

<div id="save_btn">
<input type="button" name="button" value="save" onClick="save_sr()">
</div>
</form>
</body>
</html>



and here is StockRequisitionSave.php
code for saving data to database :


<?php                                                                          
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date = $_POST['sr_date'];
$sr_number = $_POST['sr_number'];
$Items1 = $_POST['Items1'];
$SubItems = $_POST['SubItems'];
$ItemCode = $_POST['ItemCode'];
$DemandedQty = $_POST['DemandedQty'];
$UoM = $_POST['UoM'];
$Class = $_POST['Class'];
$Description = $_POST['Description'];
$BINLocation = $_POST['BINLocation'];
$RequestedBy = $_POST['RequestedBy'];
$ApprovedBy = $_POST['ApprovedBy'];
$ReceivedBy = $_POST['ReceivedBy'];
$IssuedBy = $_POST['IssuedBy'];

$sql = "INSERT INTO stock_requisition
(sr_date, sr_number, Items, SubItems, ItemCode, DemandedQty, UoM, Class, Description, BINLocation, RequestedBy,
ApprovedBy, ReceivedBy, IssuedBy)
VALUES
('$sr_date', '$sr_number', '$Items1', '$SubItems', '$ItemCode', '$DemandedQty', '$UoM', '$Class', '$Description',
'$BINLocation', '$RequestedBy', '$ApprovedBy', '$ReceivedBy', '$IssuedBy')
";  

$result = mysql_query($sql, $con);            
?>


the problem is only the last data was save.

I will attach my form.

I hope somebody can help me..
I really don't know how can I save all data from form into my database.

Thank you so much for your understanding and help.

Here is the while loop:
Code: [Select]
<?php 
 require_once("../includes/initialize.php");
$sql="SELECT * FROM product WHERE product_id IN (";
foreach($_SESSION['cart'] as $id => $value) {
$sql.=$id.","; }
$sql=substr($sql, 0, -1).") ORDER BY model ASC";
$query=mysql_query($sql);
$totalprice=0;

while($row=mysql_fetch_array($query)){
$subtotal=$_SESSION['cart'][$row['product_id']]['quantity']*$row['price'];
$totalprice+=$subtotal;
?>
<tr>
                          <td><?php echo $row['model'] ?></td>
    <td><?php echo $_SESSION['cart'][$row['product_id']]['quantity'] ?></td>
    <td><?php echo  number_format($row['price'], 2, ',', '.');  ?>din</td>
    <td><?php $cena = $_SESSION['cart'][$row['product_id']]['quantity']*$row['price'];
echo number_format($cena, 2, ',', '.');  ?>din</td>
</tr>
<?php }  ?>
How to get data out of the loop? I need it to be same as data echoed (this is the echo result: BFG 225/30 ZR 20 4 21.667,00din 86.668,00din).

Hi all,

This has just been bugging me forever, I actually just hardcoded the line it in years ago to just be done with it.  But when I use the while loop to pull up the data for this table, it prints out every row but the last one.  I've wracked my brain for years trying to fix it, and just cannot find the solution.  Below is the entire page code I'm using and you can see at the bottom what I have sadly hardcoded in to make the last row display.  That's the row that will not show up.  If you want to see the actual live page it's he

https://www.lakerstats.com/numerical-roster/

The UNK line at the end if the one that never prints out that I hardcoded.

Page code as mentioned above. Appreciate any help!

[php]
$db = mysql_connect("localhost", "xxxx", "xxxx");

mysql_select_db("lakerstats",$db);
echo "<table class=numeric WIDTH=100% cellpadding=0 cellspacing=0 border=0>

<tr><td class=left colspan=\"2\" height=10><font size=\"2\" color=#000000>Current players are listed in ALL CAPS.<br />Retired uniforms are listed in <b><font color=\"#FF0000\">red</font></b>.<br /></font></td></tr><tr>";

$uniforms = "SELECT p.fname, p.lname, p.playerid, u.number, p.current_roster, u.retired, u.retired_player, p.profile_name, p.uniform_1, p.uniform_2 FROM player p, uniforms u WHERE u.number = p.uniform_1 or u.number = p.uniform_2 or u.number = p.uniform_3 or u.number = p.uniform_4 ORDER BY u.number+0, p.years, p.lname, p.fname";

$uniresult = mysql_query($uniforms) or die ("Query failed");
$numofrows = mysql_num_rows($uniresult);

//let's get the number of rows in our result so we can use it in a for loop

$temp = "0";
$sHTMLTemp = "";
while ($unirow = mysql_fetch_array($uniresult)) // Where $result is your result set
{
if ($temp != $unirow['number'])
  {
    $temp = $unirow['number'];
    if ($unirow['number'] == "100") {
    $unirow['number'] = "0";
    } else if ($unirow['number'] == "101") {
    $unirow['number'] = sprintf("%02d", 0);
    } else if ($unirow['number'] == "102") {
    $unirow['number'] = "UNK";
    } else {    
    $unirow['number'] = $unirow['number'];
    }

    $sHTMLTemp = preg_replace("/(.+),/","\\1",$sHTMLTemp);
    print $sHTMLTemp ;
    print "</tr>";

     $sHTMLTemp = "";


 if ($unirow[retired] == "yes") {
    echo "<tr><td class=left height=10><font size=\"2\" color=\"#FF0000\"><b>#" . $unirow[number] . "</b></font><font size=\"2\"> - ";
} else {
    echo "<tr><td class=left height=10><font size=\"2\" color=\"#000000\">#" . $unirow[number] . "</font><font size=\"2\"> - ";
}

}

 if ($unirow[current_roster] == "yes") {
$unirow[fname] = strtoupper($unirow[fname]);
$unirow[lname] = strtoupper($unirow[lname]);
} else {
$unirow[fname] = $unirow[fname];
$unirow[lname] = $unirow[lname];
}

 if ($unirow[retired_player] == $unirow[playerid]) {
$sHTMLTemp .= "<b><a href=\"/player-stats-bio/?pname=".$unirow['profile_name']."\"><font color=\"#FF0000\">" . $unirow['fname'] . " " . $unirow['lname'] . "</font></a></b>, ";
} else {
$sHTMLTemp .= "<a href=\"/player-stats-bio/?pname=".$unirow['profile_name']."\">" . $unirow['fname'] . " " . $unirow['lname'] . "</a>, ";
}

}


echo "<a href=\"/player-stats-bio/?pname=jim_fritsche\">Jim Fritsche</a>, <a href=\"/player-stats-bio/?pname=bobby_watson\">Bobby Watson</a>";

echo "</font></td></tr>";

echo "</font></td></tr></table>";

mysql_close($db);
[/php]

 

Edited September 14, 2020 by ban5150

Hi Guys,

Theres probably a really simple way to do this, but i haven't touched php in a wee while lol this code:


                            foreach ($menu as $elem) {
                                $selected1 = '';
                                $selected2 = '';
                                if ($elem['system_name'] == $this->system_name) {
                                    $selected1 = '<b>';
                                    $selected2 = '</b>';
                                }
                                if ($elem['system_name'] != 'home-content') {
                                    $elem['system_name'] = $elem['system_name'] . '.html';
                                } else {
                                    $elem['system_name'] = '';
                                }

                                printf('<li class="%s">%s<a href="%s/%s">%s</a>%s</li>', $elem['li_class'], $selected1, ROOT, $elem['system_name'], $elem['title'], $selected2);
                            }
                            ?>


Prints out the navigation on one of my sites, when the code loops through the menu i want to change one of the href targets for example:


if (loop through menu)
{
 if (page returned for example users page)

  {
   <a href="[b]CHANGE THIS TO SOMETHING.html[/b]">
  }
}


So i only need to change one of the hrefs not all of them

any help would be appreciated

thanks guys

Graham

i am trying to fit this php code to so when ever i upload a video link to the database it prints in the divs from left to right. ( i have made blank boxes for where the videos should be, so you guys can see what i mean. i will give you the code here.

Code: [Select]
<?php
$query = mysql_query("SELECT * FROM `G4V_Videos` ORDER BY `id` DESC") or die(mysql_error());

while ($data = mysql_fetch_array($query)) { 
?>
ID-nummer: <?php print $data['id']; ?> - Name: <?php print $data['navn']; ?> -
<a href="/Video.php?id=<?php print $data['id']; ?>"><img src="http://i.ytimg.com/vi/<?php print $data['link'];?>/hqdefault.jpg" width="200" height="160" /></a><br />
<a href="/Video.php?=<?php print $data['id']; ?>">
<?php
}
?>

and the website is here, http://www.game4vids.com/index.php

and i also want it so once i have used up all the boxes it posts the new video in box one and overwrites the old one if you get what i mean.

This website is a great example of what i mean.
http://www.retardo.dk

I have a loop that writes out data for franchises. It works the first time through, but not the 2nd. Here is the page where the data is written out:
http://184.172.137.97/~royl21st/1.php

Here is the code that spits out the wrong data after the first successful loop. Any ideas?
Code: [Select]
    $areaCodeData = getData($sSql, $con, $dbName);
       $areaCodeRowCount = mySQL_num_rows($areaCodeData);
       $areaCodeRowCur = mysql_fetch_assoc($areaCodeData);
       if ($areaCodeRowCount != 0) {
          echo "<div class='box left'>";
          // list all Area Codes for this Franchise
          echo "<div class='details'>";
          $areaCodes = "";
          for ( $ctrAreaCode = 0; $ctrAreaCode <= $areaCodeRowCount - 1; $ctrAreaCode += 1) {
             // grab AreaCodes
             $areaCodes = "<b>".$areaCodes.$areaCodeRowCur['AreaCode']."</b>, ";     
             // fetch next AreaCode row
             $areaCodeRowCur = mysql_fetch_assoc($areaCodeData);
          } // end ctrAreaCode for loop
          $areaCodes = substr($areaCodes, 0, strlen($areaCodes)-2)."<br />";
          echo "<em>-- Area Codes Supported:</em><br/>";
          echo $areaCodes;
          echo "</div>";
          echo "</div><br />";
       } //end Area Code loop
       
       // reset AreaCode loop pointers (is this a PHP bug?)
       mysql_data_seek($areaCodeData,0);
At this point I'm desperate and I have to get this working ASAP.

The Grand Rapids, Kalamazoo, Holland area codes are
616, 269, 616
and their area codes are 49xxx

Thanks in advance for the help...