/    Sign up×
Community /Pin to ProfileBookmark

Problem in mysql statement and if condition

Copy linkTweet thisAlerts:
Dec 18.2010

Good day!

I have code to check if the cloth type is NW or W for the operation name Operation3, Operation4, and Operation5.

NW = AAA, BBB, CCC
W = all cloth that was not belong to NW

Here is the code I want to ask for you if correct and if I have missing code, because I’m not good in if condition and mysql statement.

[code]
<?php
include ‘config.php’;

$cloth_type = $_POST[‘clt_type’];
$input_qty = $_POST[‘input_qty’];
$output_qty = $_POST[‘output_qty’];

if ($_POST[“clt_no”]){

$query = “SELECT t.operation_name FROM clt_traceability t, clt_transact c WHERE c.cloth_type = ‘” . $cloth_type . “‘ AND t.operation_name = ‘Operation3, Operation4, Operation5 ‘ AND t.clt_no = c.clt_no”;
$result = mysql_query($query);

if($cloth_type = ‘AAA, BBB ,CCC’) {
$input_qty = $input_qty * 14.15;
$output_qty = $output_qty * 14.15;
}
else{
$input_qty = $input_qty * 15.85;
$output_qty = $output_qty * 15.85;
}
}

?>
[/code]

And I attached the code where I want to put the code for checking the cloth type and for the automatic multiply the input qty and output qty depend on the cloth type because the user input numbers by frame so I need to multiply it to become dozen which I put in the test code above.

Thank you.

[upl-file uuid=058a6e5d-97a2-4408-8035-3f5c521efe50 size=11kB]cmain9.txt[/upl-file]

to post a comment
PHP

8 Comments(s) ↴

Copy linkTweet thisAlerts:
@DasherDec 18.2010 — [code=php]if($cloth_type = 'AAA, BBB ,CCC')
// maybe should be;
if ($cloth_type == 'AAA' || ($cloth_type == 'BBB' || ($cloth_type == 'CCC' )
[/code]
Copy linkTweet thisAlerts:
@rhodaroseauthorDec 20.2010 — I mix my test code and my full code:

[code=php]
<?php



define('CLOTH_TYPE_SPECIAL_VALUE', 'AAA, BBB, CCC');
define('INPUT_MULTIPLE', 14.15);
define('OUTPUT_MULTIPLE', 15.85);

include 'config.php';

$rexist = 0;
if($_POST["clt_no"])
{
$query = "INSERT INTO clt_transact (cloth_type) VALUES ('" . $_POST["cloth_type"] . "')";
$result = mysql_query($query);
$clt_transact_id = mysql_insert_id();

$opname = $_POST["opname"];
$inqty = $_POST["inqty"];
$outqty = $_POST["outqty"];
$varqty = $_POST["varqty"];


$totalarr = count($opname) - 1;
for($ctr=0; $ctr < $totalarr; $ctr++)
{
$inqty[$ctr] = (float) $inqty[$ctr];
$varqty[$ctr] = (float) $varqty[$ctr];
$outqty[$ctr] = (float) $outqty[$ctr];

$query = "INSERT INTO clt_traceability (operation_name, input_qty, output_qty, variance_qty, clt_transact_id) VALUES ('" . $opname[$ctr] . "', '" . $inqty[$ctr] . "','" . $outqty[$ctr] . "', '" . $varqty[$ctr] . "', '" . $clt_transact_id . "')";
$result = mysql_query($query);
}
}

if (isset($_POST['cloth_type']) && !empty($_POST['cloth_type'])) {
$clothType = $_POST['cloth_type'];
} else {
$clothType = null;
}

if (null !== $clothType) {
if (isset($_POST['input_qty']) && !empty($_POST['input_qty'])) {
$inputQty = $_POST['input_qty'];

if (CLOTH_TYPE_SPECIAL_VALUE == $clothType) {
$inputQty *= INPUT_MULTIPLE;
}
} else {
$inputQty = null;
}

if (isset($_POST['output_qty']) && !empty($_POST['output_qty'])) {
$outputQty = $_POST['output_qty'];

if (CLOTH_TYPE_SPECIAL_VALUE == $clothType) {
$outputQty *= OUTPUT_MULTIPLE;
}
} else {
$outputQty = null;
}

$sql = "SELECT t.operation_name
FROM clt_traceability AS t, clt_transact AS c
WHERE c.cloth_type = '" . $cloth_type . "'
AND t.operation_name IN('Operation3', 'Operation4', 'Operation5')
AND t.clt_no = c.clt_no";

$resultSet = mysql_query($sql);
}

$rexist = 1;
?>
[/code]
[code=html]
<html>
<head>
<style type="text/css">
.myclass {
font-size: 10pt; font-family:Arial, Helvetica, sans-serif;
}
</style>

<script type="text/javascript">
document.onkeypress = function(e){
e = e || event; e.returnValue = true;
var t = e.target || e.srcElement, re = /^(inqty|outqty)(d+)$/, f = arguments.callee, m, i;
function next(){
if(!f.els && (m = t.form) === document.forms.clttype){
var ipts = m.getElementsByTagName('input'), els = []; i = ipts.length - 1;
for (i; i > -1; --i){
if(ipts[i].type && ipts[i].type.toLowerCase() === 'text'){
els.push(ipts[i]);
}
}
f.els = els;
}
if(f.els){
i = f.els.length - 1;
for (i; i > -1; --i){
if(f.els[i] === t && (m = f.els[i - 1])){
m.focus();
}
}
}
}
if((m = re.exec(t.id)) && e.keyCode === 13){
e.returnValue = false;
t.form.elements['varqty' + m[2]].value = t.form.elements['inqty' + m[2]].value - t.form.elements['outqty' + m[2]].value;
} else if (t.type && e.keyCode === 13 && t.type.toLowerCase() !== 'submit') {
e.returnValue = false;
}
if(!e.returnValue){
next();
if(e.preventDefault){e.preventDefault();}
}
return e.returnValue;
}
</script>
</head>
<body>
<form action='frame.php' method="post" name="clttype">
[/code]
[code=php]
<?php
$rexist = 1;

echo "<table>";
echo "<tr><td>Cloth Type</td><td><input type='text' name='cloth_type' id='cloth_type' /></td></tr>";
echo "</table>";
echo "<p>&nbsp;</p>";

$query = "SELECT * FROM clt_trace_operations ORDER BY operation_name";
$last_operation_name = "";
$result = mysql_query($query);
if($result)
{
$rexist = 1;
echo "<table>";
echo "<tr><th class='myclass'>OPERATIONS</th><th class='myclass'>INPUT <br/> QTY</th><th class='myclass'>OUTPUT <br/> QTY</th><th class='myclass'>VARIANCE Qty</th></tr>";
$totalrows = mysql_num_rows($result);
$trows = $totalrows - 1;
for($ctr = 0; $ctr < $trows; $ctr++)
{
$row = mysql_fetch_array($result);
$tctr = $ctr + 1;
echo "nt<tr>";
echo "ntt<td>";
if ($last_operation_name != $row["operation_name"]) echo $row["operation_name"];
$last_operation_name = $row["operation_name"];
echo "<input type='hidden' width='400' name='opname[]' value='" . $row["operation_name"] . "' /></td>";
echo "ntt<td><input size='6' type='text' name='inqty[]' id='inqty" . $ctr . "' /></td>";
echo "ntt<td><input size='6' type='text' name='outqty[]' id='outqty" . $ctr . "' ></td>";
echo "ntt<td><input size='6' type='text' name='varqty[]' id='varqty" . $ctr . "' /></td>";
echo "nt</tr>";
}
if($totalrows > 1);
{
$row = mysql_fetch_array($result);
echo "nt<tr>";
echo "ntt<td>";
if ($last_operation_name != $row["operation_name"]) echo $row["operation_name"];
$last_operation_name = $row["operation_name"];
echo "<input type='hidden' width='400' name='opname[]' value='" . $row["operation_name"] . "' /></td>";
echo "<input type='hidden' name='opname[]' value='" . $row["operation_name"] . "' /></td>";
echo "ntt<td><input size='6' type='text' name='inqty[]' id='inqty" . $ctr . "' /></td>";
echo "ntt<td><input size='6' type='text' name='outqty[]' id='outqty" . $ctr . "' /></td>";
echo "ntt<td><input size='6' type='text' name='varqty[]' value='' id='varqty" . $ctr . "' /></td>";
echo "nt</tr>";
}
echo "</table>";
}
echo "<p><input type='submit' value=' Save ' id='saveform' /></p>";
echo "<input type='hidden' name='clt_typeno' value='" . $_POST["clt_typeno"] . "' />";
?>
</form>
</body>
</html>
[/code]

and when i run this code and I type AAA as a cloth type and I input 20 in input qty it did not multiply automatically in 14.15, the 20 was not changed.

Thank you
Copy linkTweet thisAlerts:
@DasherDec 20.2010 — I have code to check if the cloth type is NW or W for the operation name Operation3, Operation4, and Operation5.

NW = AAA, BBB, CCC

W = all cloth that was not belong to NW[/QUOTE]

[code=php]"<tr><td>Cloth Type</td><td><input type='text' name='cloth_type' id='cloth_type' /></td></tr>";[/code]

Your code is relying on a form entry of someone entering exactly "AAA, BBB, CCC" into in the input line. What if they enter "aaa, bbb, ccc" or "AAA,BBB, CCC" or "ABC". Possibly those choices should be a <SELECT><OPTION></SELECT> pull down if they must be so precise.
Copy linkTweet thisAlerts:
@rhodaroseauthorDec 20.2010 — [code=php]"<tr><td>Cloth Type</td><td><input type='text' name='cloth_type' id='cloth_type' /></td></tr>";[/code]

Your code is relying on a form entry of someone entering exactly "AAA, BBB, CCC" into in the input line. What if they enter "aaa, bbb, ccc" or "AAA,BBB, CCC" or "ABC". Possibly those choices should be a <SELECT><OPTION></SELECT> pull down if they must be so precise.[/QUOTE]

Yes I'm relying which the user entering in the textfield. Thank you
Copy linkTweet thisAlerts:
@rhodaroseauthorDec 20.2010 — I also try this code:
[code=php]
<?php
include 'config.php';
$rexist = 0;
if($_POST["clt_no"])
{
$query = sprintf("INSERT INTO clt_transact(cloth_type)VALUES ('%s')",

mysql_real_escape_string($_POST["cloth_type"])
);

$result = mysql_query($query);
$clt_transact_id = mysql_insert_id();

$opname = $_POST["opname"];
$inqty = $_POST["inqty"];
$outqty = $_POST["outqty"];
$varqty = $_POST["varqty"];


$totalarr = count($opname) - 1;
for($ctr=0; $ctr < $totalarr; $ctr++)
{
$inqty[$ctr] = (float) $inqty[$ctr];
$varqty[$ctr] = (float) $varqty[$ctr];
$outqty[$ctr] = (float) $outqty[$ctr];

$query = "INSERT INTO clt_traceability (operation_name, input_qty, output_qty, variance_qty, clt_transact_id) VALUES ('" . $opname[$ctr] . "', '" . $inqty[$ctr] . "','" . $outqty[$ctr] . "', '" . $varqty[$ctr] . "', '" . $clt_transact_id . "')";
$result = mysql_query($query);
}
}

$query = "SELECT t.operation_name FROM clt_traceability t, clt_transact c WHERE c.cloth_type = '" . $cloth_type . "' AND t.operation_name IN ('Operation3, Operation4, Operation5 ') AND t.clt_no = c.clt_no";
$result = mysql_query($query);

if($cloth_type == 'AAA' or $cloth_type == 'BBB' or $cloth_type == 'CCC') {
$input_qty = $input_qty * 14.15;
$output_qty = $output_qty * 14.15;
}
else{
$input_qty = $input_qty * 15.85;
$output_qty = $output_qty * 15.85;
}
$rexist = 0;
?>
[/code]
<i>
</i>&lt;html&gt;
&lt;head&gt;
&lt;style type="text/css"&gt;
.myclass {
font-size: 10pt; font-family:Arial, Helvetica, sans-serif;
}
&lt;/style&gt;

<i> </i>&lt;script type="text/javascript"&gt;
document.onkeypress = function(e){
e = e || event; e.returnValue = true;
var t = e.target || e.srcElement, re = /^(inqty|outqty)(d+)$/, f = arguments.callee, m, i;
function next(){
if(!f.els &amp;&amp; (m = t.form) === document.forms.clttype){
var ipts = m.getElementsByTagName('input'), els = []; i = ipts.length - 1;
for (i; i &gt; -1; --i){
if(ipts[i].type &amp;&amp; ipts[i].type.toLowerCase() === 'text'){
els.push(ipts[i]);
}
}
f.els = els;
}
if(f.els){
i = f.els.length - 1;
for (i; i &gt; -1; --i){
if(f.els[i] === t &amp;&amp; (m = f.els[i - 1])){
m.focus();
}
}
}
}
if((m = re.exec(t.id)) &amp;&amp; e.keyCode === 13){
e.returnValue = false;
t.form.elements['varqty' + m[2]].value = t.form.elements['inqty' + m[2]].value - t.form.elements['outqty' + m[2]].value;
} else if (t.type &amp;&amp; e.keyCode === 13 &amp;&amp; t.type.toLowerCase() !== 'submit') {
e.returnValue = false;
}
if(!e.returnValue){
next();
if(e.preventDefault){e.preventDefault();}
}
return e.returnValue;
}
&lt;/script&gt;
&lt;/head&gt;
&lt;body&gt;

[code=php]
<form action='frame.php' method="post" name="clttype">

<?php
$rexist = 1;

echo "<table>";
echo "<tr><td>Cloth Type</td><td><input type='text' name='cloth_type' id='cloth_type' /></td></tr>";
echo "</table>";
echo "<p>&nbsp;</p>";

$query = "SELECT * FROM clt_trace_operations ORDER BY operation_name";
$last_operation_name = "";
$result = mysql_query($query);
if($result)
{
$rexist = 1;
echo "<table>";
echo "<tr><th class='myclass'>OPERATIONS</th><th class='myclass'>INPUT <br/> QTY</th><th class='myclass'>OUTPUT <br/> QTY</th><th class='myclass'>VARIANCE Qty</th></tr>";
$totalrows = mysql_num_rows($result);
$trows = $totalrows - 1;
for($ctr = 0; $ctr < $trows; $ctr++)
{
$row = mysql_fetch_array($result);
$tctr = $ctr + 1;
echo "nt<tr>";
echo "ntt<td>";
if ($last_operation_name != $row["operation_name"]) echo $row["operation_name"];
$last_operation_name = $row["operation_name"];
echo "<input type='hidden' width='400' name='opname[]' value='" . $row["operation_name"] . "' /></td>";
echo "ntt<td><input size='6' type='text' name='inqty[]' id='inqty" . $ctr . "' /></td>";
echo "ntt<td><input size='6' type='text' name='outqty[]' id='outqty" . $ctr . "' ></td>";
echo "ntt<td><input size='6' type='text' name='varqty[]' id='varqty" . $ctr . "' /></td>";
echo "nt</tr>";
}
if($totalrows > 1);
{
$row = mysql_fetch_array($result);
echo "nt<tr>";
echo "ntt<td>";
if ($last_operation_name != $row["operation_name"]) echo $row["operation_name"];
$last_operation_name = $row["operation_name"];
echo "<input type='hidden' width='400' name='opname[]' value='" . $row["operation_name"] . "' /></td>";
echo "<input type='hidden' name='opname[]' value='" . $row["operation_name"] . "' /></td>";
echo "ntt<td><input size='6' type='text' name='inqty[]' id='inqty" . $ctr . "' /></td>";
echo "ntt<td><input size='6' type='text' name='outqty[]' id='outqty" . $ctr . "' /></td>";
echo "ntt<td><input size='6' type='text' name='varqty[]' value='' id='varqty" . $ctr . "' /></td>";
echo "nt</tr>";
}
echo "</table>";
}
echo "<p><input type='submit' value=' Save ' id='saveform' /></p>";
echo "<input type='hidden' name='clt_typeno' value='" . $_POST["clt_typeno"] . "' />";
?>
</form>
</body>
</html>
[/code]

When I run this code I input BBB in cloth type and I insert numbers in input qty and it did not automatically multiply in 14.15 but no errors encountered. The reason why I need to automatically multiply it because the user input numbers where is the unit of measure is Frame I need to convert it to Dozen so I will multiply to 14.15 if NW and 15.85 if W.
Copy linkTweet thisAlerts:
@DasherDec 20.2010 — When I run this code I input BBB in cloth type and I insert numbers in input qty and it did not automatically multiply in 14.15 but no errors encountered. The reason why I need to automatically multiply it because the user input numbers where is the unit of measure is Frame I need to convert it to Dozen so I will multiply to 14.15 if NW and 15.85 if W. [/QUOTE]

Your if() statement does not work with "BBB" it only works with "AAA, BBB, CCC" as a string. That is all items including commas, not just any of them.
Copy linkTweet thisAlerts:
@rhodaroseauthorDec 20.2010 — What should I need to used to make it AAA was read also the BBB and CCC?What code should be?Thank you
Copy linkTweet thisAlerts:
@DasherDec 21.2010 — I am not the an expert at sprintf() usage but this works for me;
[code=php]
$j = mysql_real_escape_string($_POST["cloth_type"]);
$query = "INSERT INTO clt_transact(cloth_type) VALUES (";
$query .= sprintf('&#37;s',$j).")";

echo $query."<br>";
echo $query;

[/code]

I am not sure why you are doing the sprintf().

I also don't know why you rely so much on someone entering the AAA or what ever accurately, and just insert it into the database whether it correct or not.
×

Success!

Help @rhodarose spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 6.1,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,
)...