AllSeoHelp.com
Search the Entire Site
  • PHP
  • JavaScript
  • CSS
  • HTML
Learn VBA & Macros in 1 Week!

PHP - Need Help In Displaynig Form Inside For Each
Full Excel VBA Course - Beginner to Expert

Need Help In Displaynig Form Inside For Each

 View Content
Hi.


I created forms with condition to only view Items which is = Min Lot, now my problem is if no items that = Min Lot the select option below was displayed and the save button. I want to display them only also if the if condition is true. I mean if the condition was not satisfied no display, now in my code it happened is the Issued BY, Received By, Approved BY, Requested By and save button was still display.. How can I also display only them if the condition was satisfied?


Thank you

here is my code:


<?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);  
?>
<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 Items_ = document.getElementById("Items_").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;
    var Items1 = document.getElementById("Items1").value;
    var SubQty_ = document.getElementsByTagName('input');
    var SubQty = SubQty_[9].getAttribute("value");
    var sr_number_hide = document.getElementById("sr_number_hide").value;
    
  document.frmMain.action="StockRequisitionSave1.php?sr_date="+sr_date+"&sr_number="+sr_number+"&Items_="+Items_+
    "&SubItems="+SubItems+"&ItemCode="+ItemCode+"&DemandedQty="+DemandedQty+"&UoM="+UoM+"&Class="+Class+"&Description="+
    Description+"&BINLocation="+BINLocation+"&RequestedBy="+RequestedBy+"&ApprovedBy="+ApprovedBy+"&ReceivedBy="+ReceivedBy+
    "&IssuedBy="+IssuedBy+"&Items1="+Items1+"&sr_number_hide="+sr_number_hide+"&SubQty="+SubQty;
    document.frmMain.submit();
   alert("Stock Requisition data save.");
   //window.location = "StockRequisition1.php";
   window.location = "StockRequisitionDisplay1.php";
}

</script>

<script type="text/javascript">

function test_(cmpd, mult) {

     var len_ = (document.frmMain.elements.length) - 1;

     for (i=0; i <= len_; i++ ) {

       var cmp = "_" + cmpd;    
       var strPos_ = document.frmMain.elements[i].id.indexOf(cmp)
         
              if (strPos_ != -1) {
              var strPos = document.frmMain.elements[i].id.indexOf("_");
              
var strId = document.frmMain.elements[i].id.slice(strPos + 1) + "_" + document.frmMain.elements[i].id.slice(0,strPos);
    document.frmMain.elements[i].value = (document.getElementById(strId).value * mult).toFixed(2); 
     } 
    }   
    
    
}
 
</script>

</head>
<body>
<form name="frmMain" method="post"> 
   <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

$DemandedQty = $_POST['DemandedQty'];

$sql = "SELECT DISTINCT Items FROM bom_subitems ORDER BY Items";
$res_bom = mysql_query($sql, $con);
$totalDistinct = mysql_num_rows($res_bom);

if ($totalDistinct > 0) {
    while ($row = mysql_fetch_assoc($res_bom)) {
        $Comp[] = substr($row['Items'], 12, 3);
       // $Comp = substr($cmpdArray, 12, 3);
    }
}


 foreach ($Comp as $Comp) {   


    $sql = "SELECT COUNT(WIP_1) AS WIP_1 FROM KANBAN_REPORT_OPEN WHERE SUBSTRING(LOT_CODE, 9) = '$Comp' AND WIP_1 > 0";  
    $resultWip = mysql_query($sql, $con);
    $wip_1 = mysql_result($resultWip, 0 , "WIP_1");
    $wip1Accum = $wip1Accum + $wip_1;
    
    $sql = "SELECT COUNT(WIP_2) AS WIP_2 FROM KANBAN_REPORT_OPEN WHERE SUBSTRING(LOT_CODE, 9) = '$Comp' AND WIP_2 > 0";  
    $resultWip = mysql_query($sql, $con);
    $wip_2 = mysql_result($resultWip, 0 , "WIP_2");
    $wip2Accum = $wip2Accum + $wip_2; 
    
    $sql = "SELECT COUNT(WIP_3) AS WIP_3 FROM KANBAN_REPORT_OPEN WHERE SUBSTRING(LOT_CODE, 9) = '$Comp' AND WIP_3 > 0";  
    $resultWip = mysql_query($sql, $con);
    $wip_3 = mysql_result($resultWip, 0 , "WIP_3");
    $wip3Accum = $wip3Accum + $wip_3; 

    $sql = "SELECT COUNT(WIP_4) AS WIP_4 FROM KANBAN_REPORT_OPEN WHERE SUBSTRING(LOT_CODE, 9) = '$Comp' AND WIP_4 > 0";  
    $resultWip = mysql_query($sql, $con);
    $wip_4 = mysql_result($resultWip, 0 , "WIP_4");
    $wip4Accum = $wip4Accum + $wip_4; 

    $sql = "SELECT COUNT(WIP_5) AS WIP_5 FROM KANBAN_REPORT_OPEN WHERE SUBSTRING(LOT_CODE, 9) = '$Comp' AND WIP_5 > 0";  
    $resultWip = mysql_query($sql, $con);
    $wip_5 = mysql_result($resultWip, 0 , "WIP_5");
    $wip5Accum = $wip5Accum + $wip_5; 

    $total = $wip_1  +  $wip_2 + $wip_3 + $wip_4 + $wip_5;

    

$sql = "SELECT Compounds, Min_Lot FROM param_settings WHERE Compounds = '$Comp'";
$res_param = mysql_query($sql);

$row_param = mysql_fetch_assoc($res_param);

$Compounds = $row_param['Compounds'];
$Min_Lot = $row_param['Min_Lot'];
 
    
if($Comp = $Compounds && $total == $Min_Lot){    
$sql = "SELECT DISTINCT Items FROM bom_subitems WHERE SUBSTR(Items,13,3) = '$Compounds' ORDER BY Items";

$res_bom = mysql_query($sql, $con);
while($row = mysql_fetch_assoc($res_bom)){
    
    $Items = $row['Items'];
    $Items_ = substr($Items, 12, 3);
    
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;'></td>
        <td style='border:none;'>&nbsp;</td>
        <td style='border:none;'>&nbsp;</td> 
        <td style='border: none;'><center><input type='text' style='text-align: right;' name='DemandedQty[]' id='DemandedQty' size='12' onkeyup='test_(\"$Items_\", this.value)' value=''></center></td>     
        </tr>"; 
             
$sql = "SELECT Items, SubItems, ItemCode, UoM, Class, Description, BINLocation, Quantity FROM bom_subitems WHERE Items = '$Items' ORDER BY Items"or die(mysql_error());

$res_sub = mysql_query($sql, $con);  
 $counter = 0;
 while($row_sub = mysql_fetch_assoc($res_sub)){
     $joinId = $counter . "_" .  $Items_;      
     $Items = $row_sub['Items'];
     $Items1 = substr($Items, 12, 3);
     $SubItems = $row_sub['SubItems'];
     $ItemCode = $row_sub['ItemCode'];
     $UoM = $row_sub['UoM'];
     $Class = $row_sub['Class'];
     $Description = $row_sub['Description'];
     $BINLocation = $row_sub['BINLocation'];
     $Quantity = $row_sub['Quantity']; 
     $joinId2 =  $Items_ . "_" . $counter;

    echo "<tr>
        <td style='border: none;'>&nbsp;<input type='hidden' value='$Items1'  name='Items1[]' id='Items1'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='SubItems[]' id='SubItems' value='$SubItems'  readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='ItemCode[]' id='ItemCode' value='$ItemCode'  readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>
        <td><input class='txt' type='text' name='SubQty[]' id='$joinId' readonly = 'readonly' size='12' style= 'border:none;text-align:right'/><input type='hidden' id='$joinId2' value='$Quantity' /></td>
        <td style='border: none;' size='3'>&nbsp;<input type='text' name='UoM[]' id='UoM' value='$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' name='Class' id='Class' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></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= '30'></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;'></td>     
        </tr>";    
 $counter  = $counter  + 1;
}
}
}
} 
                 
?>
</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()" style="width: 5em;">

</div>

</form>
</body>
</html>



I will attach my sample form output


Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Beginner ?: What Is This Php Code Doing Inside This Form?
Html Form Inside Php If Statement
Form Field Inside String?
Passing Form Data To Php Inside Iframe
Echo An Array Inside Form Confirmation Email
How Can I Put A Form Inside A Form?
Store The Id Number Inside "one" Array Inside For Loop?
Moved: Running Javascript Inside Html Inside Php
Javascript Inside Php...or Php Inside Java
Js Inside Php
How To Put Php Inside Php
Can You Put An If And An Else Inside Of An If?
While Inside While, Needs To Be Something Different
Div Inside Div
Add Rel Inside Echo
If Inside Of Select?
If Statements Inside While?
Array_push Inside While
While Inside A Foreach?
&quot Inside Of Db


Learn VBA & Macros for Excel in 1 Week!


Beginner ?: What Is This Php Code Doing Inside This Form?

 Similar Tutorials View Content
Hi all,
I am trying to replicate/modify this checkbox for a different script and I don't understand what the php code is doing in this form? Could someone explain to me whats happening by including that php code in the form?

Code: [Select]
<input type="checkbox" onclick="showArchive()" NAME="showarchive" id="showarchive" <?php echo ($showarchive ? 'checked="checked"' : '');?> />
Thanks!



Html Form Inside Php If Statement

 Similar Tutorials View Content
Hey guys!

Im trying to setup an IF statement on my home page.

Its purpose is to show EITHER a login form and state your not logged in if it cannot find a stored cookie OR if it does find a stored cookie it will NOT show the HTML form and state you are logged in.

I have it mostly working apart from the fact Im not sure how to insert a HTML form into PHP IF statement and make it work. Since I dont want the user to see the login form when they are already logged in.

Here is a link to the php script: http://pastebin.com/aenq4gbE

Here is link to the live page: http://jfbsystems.co.uk/secure

Any help or ideas would be much appreciated!

JellyFishBoy


Form Field Inside String?

 Similar Tutorials View Content
Hi there!
I am wondering if anyone knows how to handle strings that contain form fields, so when the form is submitted the fields inside the string are updated.

For example say i have the following $string:
Code: [Select]
please enter your username: <input type=text size=50 name=username value=" ">
When I display it on the browser, inside of a form, it displays the blank text field.
Say the user enters a value in the text field, "John", and hits submit.

I need the $string to be updated to the following:
Code: [Select]
please enter your user name: <input type=text size=50 value="John">
I know it sounds wierd but I need the form to be inside of the string!

Thanks in advance for any help!



Passing Form Data To Php Inside Iframe

 Similar Tutorials View Content
Hi, I have a (probably quite simple) question about passing form data to a php script that contains an iframe with another php script that also needs some of this form data.

Basically, my problem is as follows:

I have the following code in a file called example1.php:

Code: [Select]
<html>
//some html stuff

<?php
if(isset($_POST['from'])) {$from1 = $_POST['from'];} 
else {$from1 = 'English';}
$langList = array('English', 'French', 'German', 'Dutch');

print('<select id="from" name="from">');
foreach ($langList as $lang) {printf('<option %s>%s</option>', 
     ($from1 == $lang ? 'selected="selected"' : ''), $lang);
     }
echo '</select>';
?>

//some more html stuff
</html>

As you can see, it retrieves a variable via POST and selects its value from a list. The variable is posted from an html file (example0.htm) containing the following:

Code: [Select]
<form method="post" action="example1.php">

This worked fine, until I put example1.php inside an iframe in example2.php as follows:
Code: [Select]
<html>
//some html here
<?php
//some php here
?>
<iframe src ='example1.php' id='something' name='something' >
</iframe>
</html>
and changed: "post" action="example2.php" in my html form.

My question is: how do I pass form data from example0.htm to example2.php to example1.php, so that example2.php gets loaded when the submit button on my form gets pressed, but so that example1.php (which gets loaded from the iframe in example2.php) can also access the form data?

Thanks!


Echo An Array Inside Form Confirmation Email

 Similar Tutorials View Content

Hi! My question is probably simple but I've been scratching my head for hours now... I'm pretty new to php. I have an online form for orders; when submitted, an email is sent to the shop manager containing the info the client has filled in. So I pass all the info in the code below, but I can't manage to echo the array containing the order's items/qty/item_code. (I'm using Wordpress, Oxygen Builder, Metabox and Code Snippets, if that helps). Here's the code (used as a Code Snippet):

add_action( 'rwmb_frontend_after_process', function( $config, $post_id ) {
    if ( 'command-form' !== $config['id'] ) {
        return;
    }

    $name = rwmb_meta( 'name', '', $post_id );
    $email = rwmb_meta( 'email', '', $post_id );
    $phone = rwmb_meta( 'phone', '', $post_id );
    $orders = rwmb_meta( 'order', '', $post_id ); */ ---> this is the array I wish to show the elements from (array --> [0]:{item:"item", qty:"qty", code:"code"]}, [1]:{}, etc...} */
    $comments = rwmb_meta( 'comments', '', $post_id );
    $reception = rwmb_meta( 'reception', '', $post_id );
    $destination = rwmb_meta( 'destination', '', $post_id );
    $payment = rwmb_meta( 'payment', '', $post_id );

    $body = "Vous avez reçu une nouvelle commande en ligne!

Nom: $name
Courriel: $email
Téléphone: $phone
Commande: */ ---> this is where I want it displayed, but since it is within $body = " ", I can't seem to be able to use foreach( ) or even print_r( )... */
Commentaires: $comments
Réception: $reception
Paiement: $payment";
     

    $headers = ['Content-type: text/html', "Reply-To: $email"];
    wp_mail( 'address@domain.com', 'Nouvelle commande en ligne', $body );
}, 10, 2 );

 

Help with this would be greatly appreciated! Please let me know if any details are missing. Thanks in advance!

Jordan

Edited June 23 by JordanC

How Can I Put A Form Inside A Form?

 Similar Tutorials View Content
Here is my code so far...
<head>
<script type="text/javascript" src="includes/jquery.js"></script>
<script language="javascript" type="text/javascript">
$(document).ready(function(){
  //trigger when clicking element
  $(".toggle").click(function () {
//check visibility
if ($(this).next().is(":hidden")) {
$(this).next().slideDown("slow"); //slide it down
} else {
$(this).next().hide(); //hide it
}
});
});
</script>
</head>
<?php include("header.inc"); ?>
<table border="0" width="100%"><tr><td valign="top" width="800">
<?php
echo "<div id='content'>";
echo "<h2 div id='title'>";
echo "Messages";
echo "</h2>";

if($_SESSION['uid']){

echo "<div align='right'><a href='create_message.php'>Create Message&nbsp&nbsp</a></div>";

echo "<h3 div id='subtitle'>";
echo "Inbox";
echo "</h3>";

//Inbox///////////////////////////////////////////////////////////////
$query = mysql_query("SELECT * FROM messages WHERE to_user='$username' ORDER BY id DESC");
$numrows = mysql_num_rows($query);
if ($numrows != 0){
echo "<form action='delete_message.php' method='POST'>";
echo "<div id='messages'>
<div id='leftside'>From...</div>
<div id='leftside'><input type='submit' name='deleteinbox' value='Delete' class='button'></div>
<div id='rightside'>Date</div>
<div id='center'>Subject and Message</div>
<div style='clear: both;'></div>
</div>";

while($row = mysql_fetch_assoc($query)){
$msg_id = $row['id'];
$msg_to_user = $row['to_user'];
$msg_to_id = $row['to_id'];
$msg_from_user = $row['from_user'];
$msg_from_id = $row['from_id'];
$msg_subject = $row['subject'];
$msg_content = $row['content'];
$msg_date = $row['date'];
$msg_from_delete = $row['from_delete'];
$msg_to_delete = $row['to_delete'];

if (!$msg_to_delete){
echo "<div id='messages'>";
echo "<div id='leftside'>
<input type='checkbox' name='cb$msg_id' value='$msg_id'>
<a href='profile.php?id=$msg_from_id' target='_blank'>$msg_from_user</a>
</div>";
echo "<div id='rightside'>$msg_date</div>";

echo "<div id='center'>
<span class='toggle'><a href='#'>$msg_subject</a></span>
<div class='hiddenDiv'>
<br>$msg_content<br><br>
<span class='toggle'><a href='#'>REPLY</a></span>
<div class='hiddenDiv'>
<form action='msgreply.php' method='POST'>
<input type='hidden' value='$msg_id' name='replyid'>
<input type='text' name='replysubject' style='width: 300px;' class='text-box' value='  $msg_subject'><br>
<textarea name='replycontent' style='width: 298px;' rows='5'></textarea><br><br>
<input type='submit' name='replybutton' class='button' value='Reply'>
</form>
</div>
</div>
</div>";

echo "<div style='clear: both;'></div>";
echo "</div>";
$num += 1;
}
}
if ($num == 0){
echo "You have no messages in your inbox.";
}
echo "</form>";

}
else
echo "You have no messages in your inbox!";

}else
echo "You must be logged in to view your messages!";
?>
</div>
</td><td width="250">

<?php include("sidebar.inc"); ?>

</td>
</table>
  </body>

</html>

<?php include("footer.inc"); ?>

Basically I am making a personal messaging system however I can't seem to find a way of putting the reply form "inside" the delete form.  Is there any simple answer as I am very new to php.

The deletion works fine however whenever I submit a reply it takes me to the delete page!

Thanks,
Cameron


Store The Id Number Inside "one" Array Inside For Loop?

 Similar Tutorials View Content
The Script: 
$desired_width = 110;

if (isset($_POST['submit'])) {
    $j = 0; //Variable for indexing uploaded image

    for ($i = 0; $i < count($_FILES['file']['name']); $i++) {//loop to get individual element from the array
        $target_path = $_SERVER['DOCUMENT_ROOT'] . "/gallerysite/multiple_image_upload/uploads/"; //Declaring Path for uploaded images

        $validextensions = array("jpeg", "jpg", "png");  //Extensions which are allowed
        $ext = explode('.', basename($_FILES['file']['name'][$i]));//explode file name from dot(.) 
        $file_extension = end($ext); //store extensions in the variable

        $new_image_name = md5(uniqid()) . "." . $ext[count($ext) - 1];
		$target_path = $target_path . $new_image_name;//set the target path with a new name of image
        $j = $j + 1;//increment the number of uploaded images according to the files in array       
      
	  if (($_FILES["file"]["size"][$i] < 100000) //Approx. 100kb files can be uploaded.
                && in_array($file_extension, $validextensions)) {
            if (move_uploaded_file($_FILES['file']['tmp_name'][$i], $target_path)) {//if file moved to uploads folder
                echo $j. ').<span id="noerror">Image uploaded successfully!.</span><br/><br/>';

                $tqs = "INSERT INTO images (`original_image_name`, `image_file`, `date_created`) VALUES ('" . $_FILES['file']['name'][$i] . "', '" . $new_image_name  . "', now())";
                $tqr = mysqli_query($dbc, $tqs);

                // Select the ID numbers of the last inserted images and store them inside an array.
                // Use the implode() function on the array to have a string of the ID numbers separated by commas.
                // Store the ID numbers in the "image_file_id" column of the "thread" table.

                $tqs = "SELECT `id` FROM `images` WHERE `image_file` IN ('$new_image_name')";
                $tqr = mysqli_query($dbc, $tqs) or die(mysqli_error($dbc));

                $fetch_array = array();
                $row = mysqli_fetch_array($tqr);
                $fetch_array[] = $row['id'];


                /*
                 * This prints e.g.:
                    Array ( [0] => 542 )

                    Array ( [0] => 543 )

                    Array ( [0] => 544 )
                 */
                print_r($fetch_array);

                // Goes over to create the thumbnail images.
                $src = $target_path;
                $dest = $_SERVER['DOCUMENT_ROOT'] . "/gallerysite/multiple_image_upload/thumbs/" . $new_image_name;

                make_thumb($src, $dest, $desired_width);


            } else {//if file was not moved.
                echo $j. ').<span id="error">please try again!.</span><br/><br/>';
            }
        } else {//if file size and file type was incorrect.
            echo $j. ').<span id="error">***Invalid file Size or Type***</span><br/><br/>';
        }
    }
}
Hey, sorry that I am posting this darn image upload script again, I have this almost finished and I am not looking to ask more questions when it comes to this script specifically.   With the script above I have that part where the script should store the ID numbers (the auto_increment column of the table) of the image files inside of one array and then the "implode()" function would get used on the array and then the ID numbers would get inserted into the "image_file_id" column of the "thread" table.   As you can see at the above part the script prints the following: 
                    Array ( [0] => 542 )

                    Array ( [0] => 543 )

                    Array ( [0] => 544 )
And I am looking to insert into the column of the table the following: 
542, 543, 544
I thought of re-writing the whole image upload script since this happens inside the for loop, though I thought maybe I could be having this done with the script as it is right now.   Any suggestions on how to do this?

Moved: Running Javascript Inside Html Inside Php

 Similar Tutorials View Content
This topic has been moved to JavaScript Help.

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


Javascript Inside Php...or Php Inside Java

 Similar Tutorials View Content
I'm trying to pull results from a database (using php) to populate a javascript "top news rotation" script I found.

The problem is that I'm getting the "java is disabled" message that is in the code...instead of the results I'm expecting.

Here's the code:

Code: [Select]


<!-- create a element in your HTML like the following -->
<div id="quotetext" >
Text will go here. Be sure to add initial text here for users with JavaScript disabled.
</div>


<!-- The easiest way is to place the below JavaScript code after the above HTML. The better
     way would be to add in the <head> section of the document and call the rotatequote() function through the window.onload event. However this can cause problems if you have other scripts that use the
     window onLoad settings -->
<script type="text/javascript" >
var myquotes = new Array(


<?php
$link = mysql_pconnect($host, $username, $password);  
mysql_select_db('briansch_brn',$link);
$sql = "SELECT * FROM story WHERE ORDER BY date DESC LIMIT 4";
$rs = mysql_query($sql,$link);  
$matches = 0; 
while ($row = mysql_fetch_assoc($rs))  {
$matches++;
 
echo "'<strong>$row[headline]</strong><br />(posted $row[date]) - $row[short_story]<br /><a href='/pages/$row[keyword]'>READ MORE</a>'";

if($matches < 4) {
        echo ',';
        }
if($matches == 4) {
        echo '';
        }



}  
if (! $matches) { 
echo (""); 
}  
echo "";  
?>

);

function rotatequote()
{
thequote = myquotes.shift(); //Pull the top one
myquotes.push(thequote); //And add it back to the end

document.getElementById('quotetext').innerHTML = thequote;
// This rotates the quote every 10 seconds.
// Replace 10000 with (the number of seconds you want) * 1000
t=setTimeout("rotatequote()",10000);
}

// Start the first rotation.
rotatequote();
</script>

I know that javascript inside php is hard to make work...and I know that php inside javascript is hard to make work.  Any ideas?

Thanks!


Js Inside Php

 Similar Tutorials View Content
I have a php code... In which there is a link and i want to apply a javascript onclick event onthat link...

Code: [Select]
echo "<a onclick=vieww_det(". $arr[$i].", ".$arr[$j].")>View Details </a>";

But its not working...

Any help will be appreciated

- Pranshu Agrawal
pranshu.a.11@gmail.com


How To Put Php Inside Php

 Similar Tutorials View Content
I need to put php inside php.
Code: [Select]
$insertGoTo = "index.php? "$sbninesven" ";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
What do I do to get that inside of
$insertGoTo = "index.php? "$sbninesven" ";


Can You Put An If And An Else Inside Of An If?

 Similar Tutorials View Content
hello, might be a stupid question but can you put an if and else inside of if brackets like i have done in this script?


<?php
require("../include/mysqldb.php");
$uinwish = $_GET['uinwish'];
$wishrefer = $_SERVER["HTTP_referer"];
$wishdate  = mktime(0, 0, 0, date("m"), date("d")+3, date("Y"));
$rand_wish_cookie = $_COOKIE["wishtracking"];

$con = mysql_connect("$dbhost","$dbuser","$dbpass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("$dbame", $con);


$sql = "select * from Wish_list_guest where usercookie='$rand_wish_cookie' and uinwish='$uinwish'";     //search db has the profile already been added to favorites
$result = mysql_query($sql);


$row = mysql_fetch_row($result);
if (mysql_num_rows($result)!= 1) {    //if 1 of more results found profile already added redirect back!


//Re-direct back script!!
if (!isset ($wishrefer)){

$host  = $_SERVER['HTTP_HOST'];
$uri   = rtrim(dirname($_SERVER['PHP_SELF']), '/\\');
$extra = 'profile.php?uin=';
header("Location: http://$host/$extra$uinwish");
exit;

}


else { header("Location: $wishrefer");
exit;
}

//end redirect script

else {

mysql_query("INSERT INTO Wish_list_guest (usercookie, date_delete, uinwish, referwish)
VALUES ('$rand_wish_cookie', '$wishdate', '$uinwish', '$wishrefer')");


mysql_close($con);

}

if (!isset ($wishrefer)){

$host  = $_SERVER['HTTP_HOST'];
$uri   = rtrim(dirname($_SERVER['PHP_SELF']), '/\\');
$extra = 'profile.php?uin=';
header("Location: http://$host/$extra$uinwish");
exit;

}


else {
header('Location: $wishrefer');
exit;

}


?>



While Inside While, Needs To Be Something Different

 Similar Tutorials View Content
Everything works except for the data needed for "$f_images", which what I am trying to get is the multiple images for each product.

Code: [Select]
            <?php
$featured_results = mysql_query("SELECT * FROM products JOIN product_images ON products.product_id=product_images.product_id WHERE products.product_active='1' AND thumb='1' Limit 10");

while($featured_row = mysql_fetch_assoc($featured_results))
{
//Thumbnail Query
$fthumb_result = mysql_query("SELECT image_name FROM product_images WHERE product_id='".$mfeatured_row['product_id']."' AND thumb='1'");
$fthumb = mysql_fetch_row($fthumb_result);

$fimages_result = mysql_query("SELECT image_name FROM product_images WHERE product_id='".$featured_row['product_id']."'");
while($fimages_row = mysql_fetch_assoc($fimages_result))
{
$f_images .= "'/includes/getimage.php?img=".$fimages_row[0]."&w=224', ";
}

$f_vars .=  "\nproductId = ".$featured_row['product_id'].";\napp.isotope.vars.homeFeaturedImages[productId] = [".$f_images."];\napp.isotope.vars.homeFeaturedProducts[productId] = {\nname  : \"".$featured_row['product_name']."\",\nprice : \"".$featured_row['product_price']."\",\nurl   : '/'\n};";

}
?>


Div Inside Div

 Similar Tutorials View Content
Hello,


First of all I am using only divs in my site.

I am using js to open links inside my content div and is working fine.

Now I have a form that customers need to fill. when they fill wrong things they get error msgs.

How do I make the error msg to appear in my page instead of opening a new blank one?

Thank you


Add Rel Inside Echo

 Similar Tutorials View Content
Hello,

I need to add rel="..." in the first part of the script but it is not working,

below is the script:

Code: [Select]
echo " <a href='products/".$image[$abc]."' target='_blank'><img border=0 src='products/thumbs2/".$image[$abc]."' /></a>";

Thank you,


If Inside Of Select?

 Similar Tutorials View Content
As of right now I have values of 0 for the fields in champ_id as well as the con1_id, con2_id, and con3_id which is all fine. The end query returns 0 results which I understand however I'm trying to figure out that if the values in these fields is 0 then have it echo "Vacant" but i'm not sure if you can do a if statement inside a select statement.

$query = "SELECT 
titles.titlename,
    titles.id, 
( SELECT c.charactername FROM characters AS c WHERE c.id = champions.champ_id ) AS champion,
( SELECT c.charactername FROM characters AS c WHERE c.id = champions.con1_id ) AS con1, 
( SELECT c.charactername FROM characters AS c WHERE c.id = champions.con2_id ) AS con2, 
( SELECT c.charactername FROM characters AS c WHERE c.id = champions.con3_id ) AS con3
FROM 
     champions 
     INNER JOIN titles 
          ON champions.title_id = titles.id";


If Statements Inside While?

 Similar Tutorials View Content
I'm sure you can do this in PHP, but for some reason when I view news.php - It automatically tells me I liked the post, when I haven't even clicked like yet!


while($fetch = mysql_fetch_assoc($query))
{
if($_GET['like'] == $fetch['id'])
{
$like = mysql_real_escape_string($_GET['like']);
$has_liked = mysql_query("SELECT * FROM likes WHERE id = '$like' AND username = '". $_SESSION['user'] ."'");
if(mysql_num_rows($has_liked) > 0)
{
echo "
<div id='post-1' class='post'>
<h2 class='title'><font color='white'>#". $i." ".$fetch['title'] ."</font>
<h3 class='date'>". $fetch['date'] ."</h3>
<div class='entry'>
<p>". nl2br(stripslashes($fetch['content'])) ."</p>
</div>
<p class='meta'><b>You've already liked this announcement.</b></p>
</div>
";
}
else
{
mysql_query("UPDATE news SET likes = likes + 1 WHERE id = '". $_GET['id'] ."'");
echo "
<div id='post-1' class='post'>
<h2 class='title'><font color='white'>#". $i." ".$fetch['title'] ."</font>
<h3 class='date'>". $fetch['date'] ."</h3>
<div class='entry'>
<p>". nl2br(stripslashes($fetch['content'])) ."</p>
</div>
<p class='meta'><b>You liked this announcement.</b></p>
</div>
";
}
}
else
{
echo "
<div id='post-1' class='post'>
<h2 class='title'><font color='white'>#". $i." ".$fetch['title'] ."</font>
<h3 class='date'>". $fetch['date'] ."</h3>
<div class='entry'>
<p>". nl2br(stripslashes($fetch['content'])) ."</p>
</div>
<p class='meta'><a href='news.php?like=". $fetch['id'] ."'>Like</a></p>
</div>
";
}
}



Array_push Inside While

 Similar Tutorials View Content
Hey guys I have the following script that correctly retrieves 2 values from mysql: security_code and selected_address:
The problem I have, is how can I add the retrieved values (more than 1 row) inside an array called $data


$data = array();
$result = mysql_query("SELECT security_code, selected_address FROM purchase WHERE purchase_id = '412012' AND selected_address = 'General Roca 900' ORDER BY `offers_bought`.`security_code` ASC"); 
$cant = 0; 
while($row=mysql_fetch_array($result))
{
array_push($data[$row['selected_address']], $row['security_code']);
        $cant++;
}


The array_push function gives me the following error:
Warning: array_push() [function.array-push]: First argument should be an array in C:\wamp\www\Test\test\excelTest.php on line 24

In other words this is want I want to achieve:
$data = array(array("selected_address" => $row['security_code']));
Only that this example adds only 1 retrieved row

Any ideas?
Thanks in advance!
Cheers,


While Inside A Foreach?

 Similar Tutorials View Content
I get this error so I was wondering if it is because I can't put a while inside a foreach?
"syntax error, unexpected T_WHILE in home/g/h/t...."

while($rows=mysql_fetch_array($rr)){
$pt_id = unserialize($rows['pts']);
foreach ($pt_id as $indiv) {
$q = "select * from indiv where id_incr = '$indiv'";
echo $q;
$result = mysql_query($q)
while $ptrow =mysql_fetch_array($result)){
echo $ptrow['v1'];
echo "<br>";
}
}
}


&quot Inside Of Db

 Similar Tutorials View Content
I have &quotThe Unforgettable&quot Jimmy Watkins  inside my db  and it PRODUCES
&quoteThe Unforgettable" Jimmy Watkins when its rendered.

Anyone know why?
Privacy