Learn VBA & Macros in 1 Week!

PHP - Having A Form Insert The Data In The Database.

Full Excel VBA Course - Beginner to Expert

Having A Form Insert The Data In The Database.	View Content

I almost have it but I am missing something. The form is being sent and the row is being created but there is not data. It is blank. I know it is something simple I am missing but I cannot figure it out If anyone can look at my code below and tell me what I am missing to make the inputed info be seen, I would sure appreciate it.

<?php

include_once('class/class_email.php');

// contact to database
$connect = mysql_connect("localhost", "admin", "password") or die ("Error , check your server connection.");

mysql_select_db("database");

$fname = $_POST['fname'];
$lname = $_POST['lname'];
$email = $_POST['email'];
$company = $_POST['company'];
$telephone = $_POST['telephone'];
$comments = $_POST['comments'];
$EID = $_POST['eid'];
extract ($_POST);

// Pick up the form data and assign it to variables
// 
$id = intval($id);
$fname = strip_tags($fname);
$lname = strip_tags($lname);
$email = strip_tags($email);
$company = strip_tags($company);
$telephone = intval($telephone); 


$query="INSERT INTO users(`id`, `fname`, `lname`, `email`,`company`,`telephone`) VALUES('$id','$fname','$lname','$email','$company','$telephone')";

echo $query;

mysql_query($query)  or die(mysql_error());
echo mysql_error();

$SQL_GetEquipment = "SELECT * FROM `new_equip` WHERE `id`='$EID' LIMIT 1;";
$result = mysqli_query($connect,$SQL_GetEquipment);
$row = mysqli_fetch_assoc($result);
$EmailBody = "$fname $lname has requested a quote from NAPE on Item $EID\n 

Information on quote request: \n
Name: $fname $lname \n
Email: $email \n
Company: $company \n
Number: $telephone  \n 
Comments: $comments  \n 
\n
Information Requested for: {$row['itemname']}\n
The URL to {$row['itemname']} is: http://www.mydomain.com.com/new-product.php?Item=$EID
\n
Click to send a quote now:\n
http://www.mydomain.com.com/Admin/send-quote.php?id=$EID ";

$e = new email();

//First value is the URL of your server, the second the port number
$e->set_server( 'mail.mydomain.com.com', 26);

//First value is your username, then your password
$e->set_auth('noreply@mydomain.com', '112233');

//Set the "From" setting for your e-mail. The Name will be base64 encoded
$e->set_sender( 'Quote Requested', 'noreply@mydomain.com' );

//for one recipient
//$send_to = array('myemail@mydomain.com','myemail2@mydomain.com');
$send_to = ('myemail@gmail.com');
//you may also specify multiple recipients by creating an array like this:
//$send_to = array('foo1@localhost.local', 'foo2@localhost.local', 'foo3@localhost.local');


$subject = 'Quote Request from NAPE';
$body = "$EmailBody";
if( $e->mail($send_to, $subject, $body, $headers) == true )
{
  //message was received by the smtp server
  //['last'] tends to contain the queue id so I like to save that string in the database
  echo 'last: '.htmlspecialchars($e->srv_ret['last']).'';
}else{
  //something went wrong
  echo 'all: '.nl2br(htmlspecialchars($e->srv_ret['all'])).'';
  echo 'full:'.nl2br(htmlspecialchars($e->srv_ret['full'])).'';
}

?>

Full Excel VBA Course - Beginner to Expert

Insert Data To Database Where Data From While Loop

Similar Tutorials

View Content

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;'> <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;'> <input type='hidden' value='$Items1' id='Items1' name='Items1'></td>
        <td style='border: none;'> <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;'> <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'> <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;'> <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;'> <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;'> <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.

Cannot Insert Data Into A Database.. Please Help

Similar Tutorials

View Content

Everything on this page works the form loads and i can insert info into the form but when i click submit it just reloads the page(action="this page") and nothing happens.
thanks in advance
-Adam
Code: [Select]
<?php
require("connection/connection.php");
include("connection/functions.php");
?>
<HTML>
<head>
<meta content="yes" name="apple-mobile-web-app-capable" />
<meta content="index,follow" name="robots" />
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<link href="" rel="apple-touch-icon" />
<meta content="minimum-scale=1.0, width=device-width, maximum-scale=0.6667, user-scalable=no" name="viewport" />
<meta name="format-detection" content="telephone=no"/>
<link href="css/style.css" rel="stylesheet" media="screen" type="text/css" />
<script src="javascript/functions.js" type="text/javascript"></script>
<title>.: Bookmarks :.</title>
<link href="" rel="apple-touch-startup-image" />

<meta content="apple-mobile-web-app-status-bar-style" content="default" />
</head>
<body class="musiclist">
<div id="topbar">
<div id="title">.: Bookmarks :.</div>
<div id="leftbutton">
<a href="default.html"><img src="images/home.png"></a>
</div>
<div id="rightbutton">
<a href="">Programs</a>
</div>
</div>
<div id="tributton">
<div class="links">
<a id="pressed" href="Bookmarks/Bookmarks.php">Bookmarks</a><a href="Music/Music.html">Music</a><a href="">Movies</a>
</div>
</div>
<div id="content" style="top: 36px">
<form method="post" action="AddBookmark.php">
<span class="graytitle">Add Bookmark</span>
<ul class="pageitem">
<li class="bigfield"><input type="text" name="BookmarkName" placeholder="Bookmark Name" /></li>
<li class="bigfield"><input type="text" name="BookmarkLink" placeholder="Bookmark Link" /></li>
<li class="select"><select name="d">
<?php
                            $getbookmarksections = mysql_query("SELECT * FROM bookmarksections");
                            confirm_query($getbookmarksections);

                            while($getbm = mysql_fetch_array($getbookmarksections)){
$id = $getbm["ID"];
$sn = $getbm["SectionName"];
                             echo "<option value=\"$id\">$sn</option>";
                            }
                        ?>
</select><span class="arrow"></span></li>
<li class="button">
<input name="AddBookmark" type="submit" value="Add Bookmark" />
</li>
</ul>
</form>
<?php
if(isset($_POST["AddBookmark"])){
$SectionID = $id;
$Bookmark = $_POST["BookmarkName"];
$BookmarkLink = $_POST["BookmarkLink"];

$add = "INSERT INTO `bookmarks` (`ID` ,`SectionID` ,`Bookmark` ,`BookmarkLink`)
VALUES ('NULL', '$SectionID', '$Bookmark', '$BookmarkLink')";
  if(confirm_query($add)){
  echo "<span class=\"graytitle\">Bookmark '$BookmarkName' in '$sn' Added.</span>";
  }
}
                ?>
</div>
<div id="footer">
</div>
</body>
</HTML>
<?php
//Close Connection
if(isset($connection)){
mysql_close($connection);
}
?>
this is the code i suspect is not working
Code: [Select]
<?php
if(isset($_POST["AddBookmark"])){
        $SectionID = $id;
        $Bookmark = $_POST["BookmarkName"];
$BookmarkLink = $_POST["BookmarkLink"];

$add = "INSERT INTO `bookmarks` (`ID` ,`SectionID` ,`Bookmark` ,`BookmarkLink`)
VALUES ('NULL', '$SectionID', '$Bookmark', '$BookmarkLink')";
if(confirm_query($add)){
      echo "<span class=\"graytitle\">Bookmark '$BookmarkName' in '$sn' Added.</span>";
        }
}
?>

Insert Data Into Database Without Waiting For It

Similar Tutorials

View Content

Hello all.
I have a php script which will insert csv data into database using PDO.
But it's slow even with just few thousands records.

So how can I prevent client from waiting for it when they want to upload data?

I tried INSERT DELAYED but it's not working...

Thank you.

Unable To Insert Data Into Database

Similar Tutorials

View Content

Hello all,
I hope you are doing great.I am using phpmyadmin for the first time.So I created a table called guestbook with 4 attributes: id,name,email,message..Then I created a php file with the following code (saved in htdoc in Xampp folder)and html form which would take the data from the user and insert into the database which could later be retrieved.So far I have just written the insertion code which successfully creates the form but when I click on submit button it opens the same php file with the code and no insertion is made in the database..here is my code..please help me urgently..i have my project deadline very soon.
php file called guest.php:
<?php
   $user="root";
   $password="";
   $database="Guestbook";
   $name=$_POST['name'];
   $email=$_POST['email'];
   $body=$_POST['body'];
   $connect("localhost",$user,$password);
   mysql($connect);
   @mysql_select_db($database)or die("unable to select db");
   $query = mysql_query("INSERT INTO Guestbook(id,name,email,body) VALUES('','$name','$email','$body')");
   if(!$query)
   {
      echo mysql_errno().':'.mysql_error();
         }
   mysql_close();
   ?>
html file called new.html:
<html>
<head>
<title>Guestbook</title>
</head>
<body>
<form method="post" action="guest.php" >
Name:<input type="text" name="name" size="30"/><br/>
Email: <input type="text" name="email" size="30"/><br/>
<p>Text:<br/>
<textarea name="message" rows="15" cols="60"></textarea></p>
<br/>
<input type="submit" value="Submit"/>
<input type="reset" value="Clear"/>
</form>
</body>
</html>

Trying To Insert Data Into A Mysql Database

Similar Tutorials

View Content

Hi,

I'm having trouble adding data to the database (test) that i created. I just can't see where I'm going wrong. need some other peoples opinions.

I have tried taking the id out of the SQL statement completely as it is an auto increment, but that doesn't seem to work either.

Thanks in advance...

<?php

$fname = $_POST['fname'];
$sname = $_POST['sname'];
$email = $_POST['email'];
$pword = $_POST['password'];
$gender = $_POST['gender'];

$user_name = "root";
$password = "";
$database = "test";
$server = "127.0.0.1";

$db_handle = mysql_connect($server, $user_name, $password);

$db_found = mysql_select_db($database, $db_handle);

if ($db_found)
{
$SQL = "INSERT INTO members (id, fname, sname, email, password, gender) VALUES (NULL, $fname, $sname, $email, $pword, $gender);";
$result = mysql_query($SQL);

mysql_close($db_handle);

print "Thanks for joining us ".$fname.".";
print "<br /><br />";
print $fname . "<br />";
print $sname . "<br />";
print $email . "<br />";
print $pword . "<br />";
print $gender . "<br />";
}
else
{
print "Database NOT Found";
mysql_close($db_handle);
}

?>

Insert Data From Mysql Database

Similar Tutorials

View Content

I am trying to display data from mysql. Each row from the mysql database shows up under rows.

I want the rows of data from mysql to appear in colums of 4.

can some one help please.

<?php
$sql = 'SELECT * FROM dbtable ORDER BY id';
$result = $db->query($sql);
$output[] = '<ul>';
while ($row = $result->fetch()) {
      $output[] = '<table>';
         $output[] = '<tr>';
         $output[] = '<td class="style10"><strong>'.$row['item'].'</strong></td>';
         $output[] = '</tr>';
         $output[] = '<tr>';
         $output[] = '<td><img src="images/'.$row['pic'].'" width="100" height="150" /></td>';
         $output[] = '</tr>';
         $output[] = '<tr>';
         $output[] = '<td>'.$row['description'].'</td>';
         $output[] = '</tr>';
      $output[] = '</table>';
}
echo join('',$output);
?>

Insert Xml Feed Data Into Mysql Database

Similar Tutorials

View Content

Hi

I have been trying to grab some data from an XML feed parse it and then insert it into a database. I will only need to do this on one occasion so no update or deletes.

Sample of xml structu
Code: [Select]
<property>
<id>34935</id>
<date>2009-11-03 06:52:45</date>
<ref>SVS0108</ref>
<price>450000</price>
<currency>EUR</currency>
<price_freq>sale</price_freq>
</property>

Using xml2array class to parse the feed:

<?php
/**
* xml2array Class
* Uses PHP 5 DOM Functions
*
* This class converts XML data to array representation.
*
*/
class Xml2Array
{
    /**
     * XML Dom instance
     *
     * @var XML DOM Instance
     */
    private $xml_dom;

    /**
     * Array representing xml
     *
     * @var array
     */
    private $xml_array;

    /**
      * XML data
      *
      * @var String
      */
      private $xml;


      public function __construct($xml = '')
      {
          $this->xml = $xml;
      }

      public function setXml($xml)
      {
          if(!empty($xml))
          {
              $this->xml = $xml;
          }
      }

    /**
     * Change xml data-to-array
     *
     * @return Array
     */
    public function get_array()
    {
        if($this->get_dom() === false)
        {
            return false;
        }

        $this->xml_array = array();
        $root_element = $this->xml_dom->firstChild;
        $this->xml_array[$root_element->tagName] = $this->node_2_array($root_element);

        return $this->xml_array;
    }

    private function node_2_array($dom_element)
    {
        if($dom_element->nodeType != XML_ELEMENT_NODE)
        {
            return false;
        }

        $children = $dom_element->childNodes;

        foreach($children as $child)
        {
            if($child->nodeType != XML_ELEMENT_NODE)
            {
                continue;
            }

            $prefix = ($child->prefix) ? $child->prefix.':' : '';

            if(!is_array($result[$prefix.$child->nodeName]))
            {
                $subnode = false;

                foreach($children as $test_node)
                {
                    if($child->nodeName == $test_node->nodeName && !$child->isSameNode($test_node))
                    {
                        $subnode = true;
                        break;
                    }
                }
            }
            else
            {
                $subnode = true;
            }

            if ($subnode)
            {
                $result[$prefix.$child->nodeName][] = $this->node_2_array($child);
            }
            else
            {
                $result[$prefix.$child->nodeName] = $this->node_2_array($child);
            }
        }

        if (!is_array($result))
        {
            $result['#text'] = html_entity_decode(htmlentities($dom_element->nodeValue, ENT_COMPAT, 'UTF-8'), ENT_COMPAT,'ISO-8859-15');
        }

        if ($dom_element->hasAttributes())
        {
            foreach ($dom_element->attributes as $attrib)
            {
                $prefix = ($attrib->prefix) ? $attrib->prefix.':' : '';
                $result["@".$prefix.$attrib->nodeName] = $attrib->nodeValue;
            }
        }

        return $result;
    }

    /**
     * Generated XML Dom
     *
     */
    private function get_dom()
    {
        if(empty($this->xml))
        {
            echo 'No XML found. Please set XML data using setXML($xml)';
            return false;
        }

        $this->xml_dom = @DOMDocument::loadXML($this->xml);

        if($this->xml_dom)
        {
            return $this->xml_dom;
        }

        echo 'Invalid XML data'; exit;
    }
}
?>

My results page:
<?php
require_once('classes/xml2array.php');
require_once('conn.php');

    function curlURL($url) {
     $ch= curl_init();
       curl_setopt($ch, CURLOPT_URL, $url);
         curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
           curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2');
       $output = curl_exec($ch);
      return $output;
   }

  $curlResults = curlURL("http://localhost/alphashare_dump/property.xml");

  $xml = $curlResults;


$converter = new Xml2Array();
$converter->setXml($xml);
$xml_array = $converter->get_array();

$array = ($xml_array['root']['property']);

echo "<pre>";
print_r($array);
echo "</pre>";

////////////// INSERT DATA INTO DB ////////////////////////////////////////////////////

?>

My array structure looks like this:

Code: [Select]
Array
(
[0] => Array
(
[id] => Array
(
[#text] => 34935
)

[date] => Array
(
[#text] => 2009-11-03 06:52:45
)

[ref] => Array
(
[#text] => SVS0108
)

[price] => Array
(
[#text] => 450000
)

[currency] => Array
(
[#text] => EUR
)

[price_freq] => Array
(
[#text] => sale
)

[part_ownership] => Array
(
[#text] => 0
)

Can somebody help with actually getting this into some format that will enable me to insert this into my database please

GT

Need Help To Extract Data From The Webpage And Insert To My Database

Similar Tutorials

View Content

Hi,

I want to extract weather for 5 cities from www.wunderground.com/global/SB.html and put the field data such as colombo, temprature, humidity and conditions in to a mysql table so I can display the weather for this 5 cities and automatically set a cronjob to update it everyday. Issue is I am unable to extract the specific data from this page.

Please help.

thanks

Insert Php Database Data Into A Javascript Array?

Similar Tutorials

View Content

Hello =)

I'm trying to create a javascript array which should be filled with data from a mysql database.
so what i wannt to do is to loop out a new array element for each row in my database.
I should also say that i'm working in a php file.

I tried (and failed) to do it like this:

Code: [Select]
<?php include('databbaseconnect.php'); ?>
<script type="text/javascript">
var StoreDetails = [
['Please select an option','','','','',''],
<?php
mysql_select_db("alltomboule_se", $db);
$result = mysql_query("SELECT * FROM spelare");
while($row = mysql_fetch_array($result))
{
echo "['".$row['namn'].$row['enamn']."','".$row['namn'].",'".$row['enamn']."','".$row['klubb']."','".$row['licensnr']."','".$row['id']."'],";
}
?>
['','','','','',''] // Note: no comma for last row
];

I wannt the array to look like this:
Code: [Select]
var StoreDetails = [
['Please select an option','','','','',''],
['Oscar Andersson','Oscar','Andersson','BON','16643','2'],
['Olle Johansson','Olle','Johansson','BFT','14443','3'],
['Ingvar Andersson','Ingvar','Andersson','BON','14333','4'],
['Kalle Kula','Kalle','Kula','BON','34576','5'],
['','','','','','']
];

Insert Data Into Database From Multi Select List

Similar Tutorials

View Content

could anyone please help me with the code which is i have already displayed data as a multi select list but now i need to select one or more from them and insert into another database table. would be appreciate your help. thanx

Store Form Data Into Mysql Database, Then Email Same Form Data

Similar Tutorials

View Content

I have a form on our website that a user can fill out for custom product. I want the form data to be 1) stored into a mysql database AND after storing said data, 2) email the same data to our sales department.

1) The form data DOES get stored into mysql database (except for the first two fields, for some weird reason)

2) I added a "mail" section to the php file that stores the data into the database, but it is not working correctly. I have stripped the email portion down to sending just one of the fields in the "message" to make it easier for troubleshooting

I have included here, both the form section of the html file, and the formdata.php file that processes the data for your analysis. I am relatively new to php so there are going to be some issues with security, but I can work on those after I get the store & email process to work correctly. Please review my code and see if anyone can be of assistance. I looked through the forums and couldn't find another issue that was the same as mine. If I just overlooked, please tell me the thread post #. Thanks

THE FORM WHICH COLLECTS THE DATA
*******************************
<form method=POST action=formdata.php>

<table width="640" border=0 align="center">
<tr>
<td align=right><b>First Name</b></td>
<td><input type=text name=FName size=25></td>
<td><div align="right"><b>Telephone</b></div></td>
<td><input type=text name=Tel size=25></td>
</tr>
<tr>
<td align=right><b>Last Name</b></td>
<td><input type=text name=LName size=25></td>
<td><div align="right"><b>Fax</b></div></td>
<td><input type=text name=Fax size=25></td>
</tr>
<tr>
<td align=right><b>Title</b></td>
<td><input type=text name=Title size=25></td>
<td><div align="right"><b>Email</b></div></td>
<td><input type=text name=Email size=50></td>
</tr>
<tr>
<td align=right><b>Company</b></td>
<td><input type=text name=Comp size=25></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align=right><b>Address</b></td>
<td><input type=text name=Addr size=25></td>
<td><div align="right"><b>Estimated Annual Volume</b></div></td>
<td><input type=text name=EAV size=25></td>
</tr>
<tr>
<td align=right><b>City</b></td>
<td><input type=text name=City size=25></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align=right><b>State/Province</b></td>
<td><input type=text name=SProv size=25></td>
<td><div align="right"><b>Application</b></div></td>
<td><input type=text name=Appl size=25></td>
</tr>
<tr>
<td align=right><b>Country</b></td>
<td><input type=text name=Ctry size=25></td>
<td><div align="right"><b>Type of System</b></div></td>
<td><input type=text name=Syst size=25></td>
</tr>
<tr>
<td align=right><b>Zip/Postal Code</b></td>
<td><input type=text name=ZPC size=25></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align=right> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align=right> </td>
<td><div align="right"><strong><font color="#FFFF00" face="Arial, Helvetica, sans-serif">COIL
DESIGN</font></strong></div></td>
<td><font color="#FFFF00" face="Arial, Helvetica, sans-serif"><strong>PARAMETERS</strong></font></td>
<td> </td>
</tr>
<tr>
<td align=right> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align=right><b>Primary Resistance (ohms)</b></td>
<td><input type=text name=Pres size=25></td>
<td><div align="right"><b>Primary Inductance (mH)</b></div></td>
<td><input type=text name=Pind size=25></td>
</tr>
<tr>
<td align=right><b>Secondary Resistance (ohms)</b></td>
<td><input type=text name=Sres size=25></td>
<td><div align="right"><b>Secondary Inductance (H)</b></div></td>
<td><input type=text name=Sind size=25></td>
</tr>
<tr>
<td align=right> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align=right><b>Peak Operating Current (Amps)</b></td>
<td><input type=text name=POC size=25></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align=right> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align=right><b>Output Energy (mJ)</b></td>
<td><input type=text name=Egy size=25></td>
<td><div align="right"><b>Output Voltage (kV)</b></div></td>
<td><input type=text name=Volt size=25></td>
</tr>
<tr>
<td align=right> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align=right><b># HV Towers per Coil</b></td>
<td><input type=text name=TPC size=25></td>
<td><div align="right"><b># of Coils per Package</b></div></td>
<td><input type=text name=CPP size=25></td>
</tr>
<tr>
<td align=right> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align=right> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th colspan=4><b>Please enter any additional information he </b></th>
</tr>
<tr>
<th colspan=4><textarea name=Mess cols=50 rows=10 id="Message"></textarea></th>
</tr>
</table>
</dl>
<div align="center">
<p>
<input type=hidden name=BodyTag value="<body bgcolor="#484589" text="#FFFFFF" link="#FFFF00" alink="#FFFFFF" vlink="#FF7F00">">
<input type=hidden name=FA value=SendMail>
</p>
<p><font color="#FFFF00" face="Arial, Helvetica, sans-serif"><strong>PLEASE MAKE SURE ALL
INFORMATION<br>
IS CORRECT BEFORE SUBMITTING</strong></font></p>
<p>
<input type=submit value="Submit Form">
</p>
</div>
</form>
THE FILE THAT PROCESSES THE FORM DATA (formdata.php)
***********************************************
<?php
$con = mysql_connect("localhost","XXX","XXX");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("customform", $con);

$sql="INSERT INTO formdata (Fname, Lname, Title, Comp, Addr, City, SProv, Ctry, ZPC, Tel, Fax, Email, EAV, Appl, Syst, Pres, Pind, Sres, Sind, POC, Egy, Volt, TPC, CPP, Mess)
VALUES ('$_POST[Fname]','$_POST[Lname]','$_POST[Title]','$_POST[Comp]','$_POST[Addr]','$_POST[City]','$_POST[SProv]','$_POST[Ctry]','$_POST[ZPC]','$_POST[Tel]','$_POST[Fax]','$_POST[Email]','$_POST[EAV]','$_POST[Appl]','$_POST[Syst]','$_POST[Pres]','$_POST[Pind]','$_POST[Sres]','$_POST[Sind]','$_POST[POC]','$_POST[Egy]','$_POST[Volt]','$_POST[TPC]','$_POST[CPP]','$_POST[Mess]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Your Information Was Successfully Posted";

mysql_close($con);

$to = "recipient email address here";
$subject = "Custom Form";
$email = $_POST['Email'] ;
$message = $_POST['Comp'] ;
$headers = "From: $Email";
$sent = mail($to, $subject, $message, $headers) ;
if($sent)
{print "Your mail was sent successfully"; }
else
{print "We encountered an error sending your mail"; }
?>

Php Form For Insert Into Database?

Similar Tutorials

View Content

Hi...

Got a slight problem with my code, it keeps telling me that there is an error in my syntax, yet I have used the same code before perfectly, and for the life of me cannot see the problem? ....any ideas?

<?php
if (!isset($_SESSION)) {
session_start();
}
// Connects to your Database
mysql_connect("localhost", "justair1_mick", "guru1969") or die(mysql_error()) ;
mysql_select_db("justair1_justair") or die(mysql_error()) ;

$filename = ($_FILES['image']['name']);
$group = $_POST['group'];
$make_model = $_POST['make_model'];
$seats = $_POST['seats'];
$transmission = $_POST['transmission'];
$doors = $_POST['doors'];
$lg_bags = $_POST['lg_bags'];
$sm_bags = $_POST['sm_bags'];
$aircon = $_POST['aircon'];
$day1 = $_POST['1_day'];
$days2 = $_POST['2_days'];
$days3_6 = $_POST['3_6days'];
$week = $_POST['week'];
$days8_13 = $_POST['8_13days'];
$days14 = $_POST['14_days'];

if(isset($filename)){
   //This is the directory where images will be saved
   $target = "images/";
   $target2 = $target . basename( $_FILES['image']['name']);

   //This gets all the other information from the form
   $fileA=($_FILES['image']['name']);
}

$updateSQL = "INSERT INTO car_groups (group, make_model, transmission, seats, doors, lg_bags, sm_bags, aircon, image) VALUES ('$group', '$make_model', '$transmission', '$seats', '$doors', '$lg_bags', '$sm_bags', '$aircon', '$filename')";

mysql_query($updateSQL) or die(mysql_error());

//Writes the photo to the server
move_uploaded_file($_FILES['image']['tmp_name'], $target2);

header ("Location: carhireInsert.php");
?>

It keeps telling me...
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group, make_model, transmission, seats, doors, lg_bags, sm_bags, aircon, image) ' at line 1" ..?

Really stuck on this one...

Any help would be apreciated..
thanks.. Mick.

Trying To Insert To A Database With A Passed Value And A Form

Similar Tutorials

View Content

Hey all,

I'm very new to php and am having an issue writing to my database with a passed value and info taking from a form and am lost as to what to do.
The $comm_id is the value I am getting from another php page that I am passing in the link from the other page. I need to insert that value, the session variable, and the $cmt value, which is taken from the user input from the form. As it stands now, when I run this, the $comm_id and $u_id insert and the $cmt is blank, BUT $cmt is echoing on the screen with the proper value.

Any tips or direction would be great as i've been trying to sort this out for days now and i'm stumped.

<?php

$host='localhost';
$user='username';
$password='password';
$dbname='db_a';
session_start();
$id_link=mysql_connect($host,$user,$password);
mysql_select_db($dbname, $id_link);

$comm_id = $_GET['commId'];
$u_id = $_SESSION['userId'];
echo $comm_id;
echo $u_id;

$cmt = $_POST["comm"];
mysql_query("insert into Comments values($u_id, $comm_id,'$cmt');");
echo $cmt;

?>

<FORM ACTION="test.php" METHOD="POST">
<input type="text" name="comm">
<input type="SUBMIT">
</FORM>

Php Form Post And Database Insert

Similar Tutorials

View Content

Ok .I tried to look for the problem for about 1 hour but I can't see what's wrong whit the following code:
In firebug the post values appear correctly like so:id=116&usern=asdawe&com=qweqw&page=116&submit=submit
and the inserc() function works correctly because i tried it whit a array of data created by my;
Code: [Select]

<?php
if(isset($_POST['submit']))
{
$comment = new comment;
$comment->storeform($_POST);
$comment->insertc();
}
?>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
<input type="hidden" name="id" value="<?php echo $result['article']->id ?>"/>

<ul>
<li>
<input type="text" name="usern" id="usern" />
</li>

<li>
<textarea name="com" id="com" COLS=40 ROWS=6></textarea>
</li>

<input type="hidden" name="page" value="<?php echo $result['article']->id ?>" />
<input type="submit" name="submit" value="submit" />

</ul>

</form>

Code: [Select]

<?php

class comment{

public $id = null;
public $usern = null;
public $com = null;
public $page = null;

public function __construct($data=array() )
{
if( isset($data['id']) ) $this->id= (int)$data['id'];
if( isset($data['usern']) ) $this->usern= preg_replace ( "/[^\.\,\-\_\'\"\@\?\!\:\$ a-zA-Z0-9()]/", "", $data['usern'] );
if( isset($data['com']) ) $this->com= preg_replace ( "/[^\.\,\-\_\'\"\@\?\!\:\$ a-zA-Z0-9()]/", "", $data['com'] );
if( isset($data['page']) ) $this->page= (int)$data['page'];

}

public function storeform ( $params ) {

    // Store all the parameters
    $this->__construct( $params );
}

public function insertc()
{
$con = new PDO(DBN,DB_USER,DB_PASS);
    $sql = "INSERT INTO comments (usern,com,page) VALUES (:usern,:com,:page)";
$st =$con->prepare($sql);
$st->bindValue( ":usern", $this->usern, PDO::PARAM_STR );
        $st->bindValue( ":com", $this->com, PDO::PARAM_STR );
$st->bindValue( ":page", $this->page, PDO::PARAM_INT );
        $st->execute();
$this->id = $con->lastInsertId();
        $con = null;
}
}

?>

Insert Data From A Form Into Table

Similar Tutorials

View Content

HI first timer here so please forgive me if this is in the wrong section.

Anyway, here goes.

I have 2 tables

Table 1
Levels
LevelID
LevelName

Table 2
Members
MemberID
FirstName
LastName
Birthdate
LevelID

I have a form that has the LevelID populated from table 1 with a query. When I enter all my data and hit submit the data gets written to the members table. However, the LevelID is written as 0 for each and everyone record that I have entered. So the question is what am I missing?

As mentioned I am very new at this so any help would be greatly appreciated. Please see below for my code.

Thanks in advance

<?php
require_once 'dblogin1.php';
$db_server = mysql_connect($db_hostname, $db_username, $db_password);
if (!$db_server) die("Unable to connect to MySQL: " . mysql_error());

mysql_select_db($db_database)
or die("Unable to select database: " . mysql_error());
$sql = "SELECT\n"
. "levels.LevelID,\n"
. "levels.LevelName\n"
. "FROM\n"
. "levels\n";

   $result = mysql_query($sql) or die(mysql_error());

$options="";

while($row = mysql_fetch_array($result)){

$LevelId=$row["LevelID"];
$LevelName=$row["LevelName"];
$options.="<OPTION VALUE=\"$LevelID\">".$LevelName.'</option>';
}
?>
<style type="text/css">

</style>

<table width="500" border="1" align="center" cellpadding="0" cellspacing="1" >
<tr>
<td>
<form name="form1" method="post" action="insert_ac.php">
<table width="100%" border="1" cellspacing="1" cellpadding="3">
<tr>
<td colspan="3"><div align="center">
<p><strong>Myers Player Registration Form</strong></p>
</div></td>
</tr>
<tr>
<td>First Name</td>
<td><div align="center">:</div></td>
<td><input name="firstname" type="text" id="firstname"></td>
</tr>
<tr>
<td>Last Name</td>
<td><div align="center">:</div></td>
<td><input name="lastname" type="text" id="lastname"></td>
</tr>
<tr>
<td>Birthdate (yyyy-mm-dd)</td>
<td><div align="center">:</div></td>
<td><input name="birthdate" type="text" id="birthdate">
</td>
</tr>

<tr>
<td>Level</td>
<td><div align="center">:</div></td>
<td><select name="LevelID">
<OPTION VALUE="0">Choose
<?php echo $options?>

</select></td>
</tr>
</form>
</td>
</tr>
</table>

Insert Php + Mysql Data Into A Form

Similar Tutorials

View Content

Hi.

I'm making a private webpage for my self where i can post news, games, music titles and movies.
I'm made it so that i can post and delete them from my page.
Also i wanted to have the option to edit them.

So i made a action that shows me a list og the posts in each category.
And then i want the option to hit UPDATE, and then it should open the form with the info's from MySQL.

I've made those two options as the following:

Code: [Select]
elseif ( $action == "EditNews" ) {
// EDIT NEWS START
if ( !$_GET['id'] ) {
?>
<div id="content">

<?php
$sql = mysql_query("SELECT * FROM news") or die(mysql_error());
while ( $row = mysql_fetch_assoc($sql) ) {
echo "<a href=\"?page=Admin&action=UpdateNews&id=" . $row['news_id'] . "\">Update</a> | " . $row['subject'] . "<br>";
}
echo "</div>";

} else {
$type = $_GET['type'];
$id = $_GET['id'];
}
// EDIT NEWS END

} elseif ( $action == "UpdateNews" ) {
// UPDATE NEWS START
if ( !$_POST['submit'] ) {
$id = $_GET['id'];
$sql = mysql_query("SELECT * FROM news WHERE news_id='$id'") or die(mysql_error());

$user_id = $_SESSION['uid'];
$subject = $_row['subject'];
$body = nl2br($_row['body']);

?>
<div id="content">
<form action="?page=Admin&action=EditNews" method="post">
<div id="">Subject</div>
<div id=""><input id="input" type="text" name="subject"></div>
<div id="">Message</div>
<div id=""><textarea id="input" name='body' cols='15' rows='4'></textarea></div>
<div id=""><input id="submit" class="input" type="submit" name="submit" value="Post News"></div>
</form>
</div>
<?php
} else {
?>
<div id="content">Not Working!</div>
<?php
}
// UPDATE NEWS END
}

- I know i miss something, but i've tried to get to the point, where i only have the form as blank, and need some help from there.
I hope someone can help me with my problem.

MOD EDIT: [code] . . . [/code] tags added.

Feedback Form - Insert Into Database & Email Results

Similar Tutorials

View Content

Hello:

Did my first post last week and am new to PHP. Making the jump from Classic ASP into PHP. I got some good advice last time.

I have a feedback form I have been using, and it works fine for sending results to the website owner.

How can I add to it so it will first add all the data to mySQL database, and then email the results to the site owner? Also, I hear about SQL injection attacks a lot - is my current code safe from that?

This is what I have:

contact.php
Code: [Select]
...

<form method="post" name="myform" action="sendmail.php">

Full Name: <input type="text" name="FullName" />

Address: <input type="text" name="Address" />

City: <input type="text" name="City" />

State: <input type="text" name="State" />

Zip: <input type="text" name="Zip" />

Phone: <input type="text" name="Phone" />

Email: <input type="text" name="Email" />

Website: <input type="text" name="Website" />

Comments: <textarea cols="43" rows="6" name="Comments"></textarea>

<input type="submit" /><br />

</form>

...

sendmail.php

Code: [Select]
<?php

$FullName = $_REQUEST['FullName'] ;
$Address = $_REQUEST['Address'] ;
$City = $_REQUEST['City'] ;
$State = $_REQUEST['State'] ;
$Zip = $_REQUEST['Zip'] ;
$Phone = $_REQUEST['Phone'] ;
$Email = $_REQUEST['Email'] ;
$Website = $_REQUEST['Website'] ;
$Comments = $_REQUEST['Comments'] ;

mail( "info@website.com", "Contact Request",

"Full Name: $FullName\nAddress: $Address\n City: $City\n State: $State\n Zip: $Zip\n Phone: $Phone\n Email: $Email\n Website: $Website\n Comments: $Comments\n",
"From: $Email" );

header( "Location: http://www.website.com/thanks.php" );

?>

Any help or coding examples would be most appreciated!

Thanks!

Insert The Form Values From An Array Into A Database As One String

Similar Tutorials

View Content

Hi everyone,

I'm new to this group and new to php. I have created a multi-part form that allows the user the option to add multiple input fields to a form to upload images. Here is the form structu

Code: [Select]
<form action="Scripts/processreports2.php" method="post" enctype="multipart/form-data" name="report_form" target="uploader" class="reportfrm">
<fieldset>
<legend>Upload your images</legend>
<ol id="add_images">
<li>
<input type="file" class="input" name="files[]" />
</li>
<li>
<input type="file" class="input" name="files[]" />
</li>
<li>
<input type="file" class="input" name="files[]" />
</li>
</ol>
<input type="button" name="addFile" id="addFile" value="Add Another Image" onclick="window.addFile(this);"/>
</fieldset>
<p>* indicates a required field.</p>
<input name="submit" type="submit" id="submit" value="Send Info!" />
</form>

Through php a maximum of three input fields are fed into an array that checks to make sure that the uploaded files are images and not some other type of file. The uploading porition of this script works.

Now I am trying to get the values of the input fields as a string and insert them into the database as one record.

Let's say the user has three files they want to upload. I have managed to get the files as a string ie; file1.jpg, file2.jpg, file3.jpg but what is happening is that I am getting three separate records with file1.jpg, file2.jpg, file3.jpg in them. If the user has only two files to upload then I get two separate records with file1.jpg and file2.jpg in them. (Hope that makes sense). I want one record.

I have been struggling with this since Monnday and while every day I get closer, this is as close as I can get. Below is the php code.

#connect to the database

mysql_connect("localhost", "root", "");

mysql_select_db("masscic");

//Upload Handler to check image types

function is_image($file) {

$file_types = array('jpeg', 'gif', 'bmp'); //acceptable file types

if ($img = getimagesize($file)){

//echo '<pre>';

//print_r($_FILES); used for testing

//print_r($img); used for testing

if(in_array(str_replace('image/', '', $img['mime']), $file_types))

return $img;

}

return false;
}

//form submission handling

if(isset($_POST['submit'])) {

//file variables

$fname = $_FILES['files']['name'];

$ftype = $_FILES['files']['type'];

$fsize = $_FILES['files']['size'];

$tname = $_FILES['files']['tmp_name'];

$ferror = $_FILES['files']['error'];

$newDir = '../uploads/'; //relative to where this script file resides

for($i = 0; $i < count($fname); $i++) {
//echo 'File name ' . $fname[$i] . ' has size ' . $fsize[$i]; used for testing

if ($ferror[$i] =='UPLOAD ERR OK' || $ferror[$i] ==0)

{

if(is_image($tname[$i]))

{

//append the tmp_name($tname) to the file name ($fname) and upload to the server

move_uploaded_file($tname[$i], ($newDir.time().$fname[$i]));

echo '<li><span class="success">'.$fname[$i].' -- image has been accepted<br></span></li>';

}else

echo '<li><span class="error">'.$fname[$i].' -- is not an accepted file type<br></span></li>';

}

if (is_array($fname))

$files = implode(', ',$fname);

//else $files = $fname;

$sqlInsert = mysql_query("INSERT INTO files (file_names) VALUES('$files')") or die (mysql_error());

}
}

Trying To Email Form Data After Successful Insert Into Mysql

Similar Tutorials

View Content

Not sure exactly what my problem is here, but i have looked at this at least a hundred times and I just can't figure out what is going on. Everything works great except for the sending the email part. It displays the error "There was a problem sending the mail". The form field checking works fine, the insert into mysql works fine - - but it won't send the email. I have tried using double quotes and single quotes for the email information ($to, $subject, etc...) I have even eliminated the form data from the email information and it still doesn't send. I am hopelessly stuck at this point    Any ideas?? Code below:

<html>
<body bgcolor = 'blue'>
<div align = 'center'>
<h1>test FORM</h1>
</div>
<p>
<?php

If ($_POST['submit']) //if the Submit button pressed
{
//collect form data

$fname = $_POST['FName'];
$lname = $_POST['LName'];
$email = $_POST['Email'];
$tel = $_POST['Tel'];
$mess = $_POST['Mess'];

$errorstring = "";

if (!$fname)
$errorstring = $errorstring."First Name<br>";
if (!$lname)
$errorstring = $errorstring."Last Name<br>";
if (!$email)
$errorstring = $errorstring."Email<br>";

if ($errorstring !="")
echo "<div align = 'center'><b>Please fill out the following fields:</b><br><font color = 'red'><b>$errorstring</b></font></div>";
else
{

$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$email = mysql_real_escape_string($email);
$tel = mysql_real_escape_string($tel);
$mess = mysql_real_escape_string($mess);

$con = mysql_connect("localhost","user","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("mec", $con);

$sql="INSERT INTO formtest (FName, LName, Title, Tel, Email, Mess)
VALUES ('$fname','$lname','$title','$tel','$email','$mess')";

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
$to = 'myemailaddress';
$subject = 'test form';
$message = 'Hello';
$headers = 'From Me';
$sent = mail($to, $subject, $message, $headers);
if($sent)
{print "Email successfully sent";}
else
{print "There was an error sending the mail";}

mysql_close($con);

}

}

?>
<p>
<form action= 'testmecform.php' method= 'POST'>


  <table width = '640' border = '0' align = 'center'>
    <tr>
      <td align = 'right'><b>First Name</b></td>
      <td><input type = 'text' name = 'FName' value = '<?php echo $fname; ?>' size = '25'></td>
      <td><div align = 'right'><b>Telephone</b></div></td>
      <td><input type = 'text' name = 'Tel'  value = '<?php echo $tel; ?>' size = '25'></td>
    </tr>
    <tr>
      <td align = 'right'><b>Last Name</b></td>
      <td><input type = 'text' name = 'LName' value = '<?php echo $lname; ?>' size = '25'></td>
  <td> </td>
      <td> </td>
    </tr>
    <tr>
      <td align = 'right'><b>Email</b></td>
      <td><input type = 'text' name = 'Email'  value = '<?php echo $email; ?>' size = '25'></td>
      <td> </td>
      <td> </td>
    </tr>
    <tr>
      <th colspan = '4'><b>Please enter any additional information he </b></th>
    </tr>
    <tr>
      <th colspan = '4'><textarea name = 'Mess' cols = '50' rows = '10'><?php echo $mess; ?></textarea></th>
    </tr>
    <tr>
      <th colspan = '4'><b>Please make sure all information is correct before submitting</b></th>
    </tr>
    <tr>
      <th colspan = '4'><input type = 'submit' name = 'submit' value = 'Submit Form'></th>
    </tr>
  </table>
</form>
</body>
</html>

Insert Data In Html Table Or Form From Php Sql Retrieve

Similar Tutorials

View Content

I'm creating a report page and can't figure out how to retrieve multiple rows from a table and display them in html. There are 5 data elements in each row and I'm thinking that using a form in the html might be the best way as I'm totally ignorant about tables in html. I'm a newbie to php and can't figure out how to accomplish this. Here's the code that I have so far:

<?php
$filename = NULL;
session_start();
// start of script every time.

//  setup a path for all of your canned php scripts
$php_scripts = '../php/'; // a folder above the web accessible tree
//  load the pdo connection module  
require $php_scripts . 'PDO_Connection_Select.php';

//*******************************
//   Begin the script here
// Connect to the database

if (!$con = PDOConnect("foxclone")):
{
    echo "Failed to connect to database" ;
    exit;
}
else:
{
    $sql = 'SELECT COUNT(IP_ADDRESS) FROM download WHERE FILENAME IS NOT NULL'; 

    $sql1 = 'Update  download t2, ip_lookup t1 set t2.country = t1.country, t2.area = t1.area, t2.city = t1.city where ((t2.IP_ADDRESS) = (t1.start_ip) OR (t2.IP_ADDRESS) > (t1.start_ip)) AND ((t2.IP_ADDRESS) = (t1.end_ip) OR (t2.IP_ADDRESS) < (t1.end_ip)) AND (t2.FILENAME is not null and t2.country is null)';

    $sql2 = 'SELECT (IP_ADDRESS, FILENAME, country, area, city) from download where FILENAME is not null';

// Update the table
    $stmt = $con->prepare($sql1);
    $stmt->execute();  

// Get count of rows to be displayed in table
    $stmt = $con->prepare($sql);
    $stmt->execute() ;
    $cnt = $stmt->fetch(PDO::FETCH_NUM);

// retrieve one row at a time
    $i = 1;
    while($i <= $cnt){
      $stmt = $con->prepare($sql2);
      $row->execute(array(''));  // Do I need an array here?
// from here on, I'm lost

    $i++;

I'd appreciate any guidance you can provide or understandable tutorials you can point me to.

Larry