Learn VBA & Macros in 1 Week!

PHP - Unable To Insert Data Into Database

Full Excel VBA Course - Beginner to Expert

Unable To Insert Data Into Database	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>

Full Excel VBA Course - Beginner to Expert

Unable To Insert Data In Db

Similar Tutorials

View Content

Hello....I am using ajax,jquery with php to insert data in db.....but the script is not working.

form.html:
Code: [Select]

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
label{
display:block;
}
</style>
<script type="text/javascript" src="jquery-1.5.min.js">
</script>
<script type="text/javascript">
$(function()
{
$('#submit').click(function(){
$('#container').append('<img src="ajax-loader.gif" id="loading" alt="image" />');

var name=$('#name').val();
var email=$('#email').val();
var d=$('#d').val();
var m=$('#m').val();
var y=$('#y').val();
var add=$('#add').val();
var phone=$('#phone').val();
$.ajax({
url: 'process.php',
type: 'POST',
data: 'name=' + name + '&email=' + email + '&d=' + d + '&m=' + m + '&y=' + y + '&add=' + add + '&phone=' + phone,
success: function(result){
$('#response').remove();
$('#container').append('<p id="response">' + result + '</p>');
$('#loading').fadeOut(500,function(){
$(this).remove();
});
}
});
return false;

});

});

</script>

</head>

<body>
<h2>User Registeration</h2>
<form action="process.php" method="POST">
<div id="container">

Name:<br>
<input type="text" name="name" id="name" /><br>
Email:<br>
<input type="text" name="email" id="email" /><br>
Date Of Birth:<br>
<input type="text" id="d" name="d" size="2" />
<input type="text" id="m" name="m" size="2" />
<input type="text" id="y" name="y" size="4" /><br>
Address:<br>
<input type="text" id="add" name="add" /><br>
Phone:<br>
<input type="text" id="phone" name="phone" /><br>

<input type="submit" name="submit" id="submit" value="GO!" />
</div>
</form>

</body>
</html>

process.php
My db id named "jquery" and table is "tab"

Code: [Select]

<?php
$conns=mysql_connect("localhost","root","");
if(!$conns)
echo "error in connection";
mysql_select_db("jquery", $conns);

$name=$_POST['name'];
$email=$_POST['email'];
$m=$_POST['m'];
$d=$_POST['d'];
$y=$_POST['y'];
$add=$_POST['add'];
$phone=$_POST['phone'];

echo $name,"<br>";
echo $email,"<br>";
echo $m, "<br>";
echo $d,"<br>";
echo $y,"<br>";
echo $add, "<br>";
echo $phone,"<br>";

$query="INSERT INTO tab (name,email,d,m,y,add,phone) VALUES ('$name',$email','$d','$m','$y','$add','$phone')";
if(!mysql_query($query,$conns))
echo "Error";
else
echo "DATA inserted";
?>

The output shown is:
pulkit
pulkit@gmail.com
1
26
1991
lucknow
987576787
Error

For some values i entered.

Unable To Insert The Data Into Data Base

Similar Tutorials

View Content

Hi Team,

I have a php page where I have taken the same userid and linked in the next page and also used show/hide function.

I am able to see that the userid is linking but when i submit the data is not getting insert and also no error

Please help

below is the Tower.php file.

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>BHP2</title>
<style type="text/css">

</style>
</head>

<body>

<div id="Layer1">
<form id="form5" name="form5" method="link" action="Insert.php">
<div id="Layer2">
<div id="Layer6"><img src="AZimages/BHP-Billiton-logo.jpg" width="235" height="65" alt="BHP" /></div>
<h1 align="center"> </h1>
<div class="style1" id="Layer4">
<h1 align="center" class="style2">BHP DATA TRACKER </h1>
</div>
</div>
<div id="Layer7">
<div align="center"><span class="style4">SELECT THE TOWER BELOW </span>
<div id="Layer13">

<input type="hidden" name="empid" value="<?php echo $_GET['id']; ?>" size="20">
<input type="hidden" name="date" value="<?php echo date("Y-m-d H:i:s"); ?>" >
<input type="submit" name="B1" value="Start !" />

</div>
<div id="Layer12">
<div align="left">

<input name="rad1" type="radio" value="RF" id="rad1" />
<label >RF</label>

</div>
</div>
<div id="Layer11">
<div align="left">
<input name="rad1" type="radio" value="ISAP" id="rad1" />
<label >ISAP</label>

</div>
</div>
<div id="Layer10">
<div align="left">
<input name="rad1" type="radio" value="GSD" id="rad1" checked="checked" />
<label >GSD</label>

</div>
</div>
<div id="Layer9">
<div align="left">
<input name="rad1" type="radio" id="rad1" value="CSD" />
<label>CSD</label>
</p>
</div>
</div>
<br />
</div>
</div>
</form>
</div>
</body>
</html>

Below is the insert.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>BHP DATA SUMBIT</title>
<?php
include ("count.php");
?>

<?php
if(isset($_GET['action']))
{
$action = $_GET['action'];
if ($action = 'yes')
{
include ("Connection.php");
$PName = $_POST['rad11'];
$Date = date("Y-m-d H:i:s");
$empidno = $_POST['idd'];
$qsdate = $_POST['testinput'];
$cb1 = $_POST['chkbox1'];
$cb2 = $_POST['chkbox2'];
$cb3 = $_POST['chkbox3'];
$cb4 = $_POST['chkbox4'];
$cb5 = $_POST['chkbox5'];
$Com = $_POST['textfield2'];
$dd1 = $_POST['textfield'];
$dd2 = $_POST['select'];
$dd3 = $_POST['select2'];
$dd4 = $_POST['textfield4'];
$dd5 = $_POST['textfield3'];
$dd6 = $_POST['select3'];
$sev = $_POST['radio1'];
$olddate = $_POST['odate'];
$pname = $_POST['radiobutton'];

$query="INSERT INTO bhp ticketinformation (`userid`,
`processname`,
`begindate`,
`dateposted`,
`CALL`,
`EMAIL`,
`NEW`,
`EXISTING`,
`Piroty`,
`MTICKET`,
`Services`,
`group1`,
`group2`,
`Icall`,
`Tcreatedtime`,
`comment`)
VALUES ( '$empidno' , '$pname' , '$olddate' , '$Date' , '$cb1' , '$cb2' , '$cb3' , '$cb4' , '$sev' , '$dd1' , '$dd2' , '$dd3' , '$dd4' , '$dd5' , '$dd6' , '$Com')";
mysql_query($query);
Header('location:tower.php?id=' . $empidno);
}
}
?>
<head>
<style type="text/css">

</style>

<script language="JavaScript" >
function showInfo()
{
var elem = document.getElementById('verify');
if(document.testform.select3.value == "verify" || document.testform.select3.value == "verify1" )
{
elem.style.display="inline";
}
else
{
elem.style.display="none";
}
}
</script>

<script language="JavaScript">

function validator()
{
if(document.testform.Checkbox1.checked == false &&
document.testform.Checkbox2.checked == false &&
document.testform.Checkbox3.checked == false &&
document.testform.Checkbox4.checked == false)
{
alert ('You did not choose any of the checkboxes!');
return false;
}
if (document.testform.textfield.value =="")
{
alert("Enter Max Ticket No");
return false;
}
if (document.testform.select.value == "" || document.testform.select.value == "SELECT SERVICE DROP DOWN")
{
alert ('Select the SELECT SERVICE DROP DOWN');
return false;
}
if (document.testform.select2.value == "" || document.testform.select2.value == "SELECT RG GROUP")
{
alert ('SELECT RG GROUP');
return false;
}
if (document.testform.select3.value == "" || document.testform.select3.value == "SELECT GROUPS")
{
alert ('SELECT GROUPS');
return false;
}
if (document.testform.textfield2.value =="")
{
alert("Comments Feild is Empty.If there are no Comment then type NA(Not Applicable)");
return false;
}
if (document.testform.Checkbox1.checked == false)
document.getElementById("chkbox1").value = "";
else
document.getElementById("chkbox1").value = "EMAIL";
if (document.testform.Checkbox2.checked == false)
document.getElementById("chkbox2").value = "";
else
document.getElementById("chkbox2").value = "NEW";
if (document.testform.Checkbox3.checked == false)
document.getElementById("chkbox3").value = "";
else
document.getElementById("chkbox3").value = "EXISTING";
if (document.testform.Checkbox4.checked == false)
document.getElementById("chkbox4").value = "";
else
document.getElementById("chkbox4").value = "CALL";
alert('Record has been posted in the portal');
}
</script>
</head>

<body>
<div id="Layer1">
<div id="Layer2">
<div id="Layer6"><img src="AZimages/BHP-Billiton-logo.jpg" width="235" height="67" alt="BHP" /></div>
<h1 align="center"> </h1>
<div class="style1" id="Layer4">
<h1 align="center" class="style2">BHP DATA TRACKER </h1>
</div>
</div>
<div id="Layer7">

<form method="POST" action="Insert.php?action=yes&&id=<?php echo $_GET['empid']; ?>" name="testform" onSubmit="return validator();">

<div id="Layer8">

<input type="checkbox" id="Checkbox4" name="checkbox4" value="CALL" />
CALL</label>

</div>
<div id="Layer9">

<label>
<input type="checkbox" id="Checkbox1" name="checkbox1" value="EMAIL" />
EMAIL</label>

</div>
<div id="Layer10">

<label>
<input type="checkbox" id="Checkbox2" name="checkbox2" value="NEW" />
NEW</label>

</div>
<div id="Layer11">

<label>
<input type="checkbox" id="Checkbox3" name="checkbox3" value="EXISTING" />
EXISTING</label>

</div>
<div id="Layer12">

<label>
<input name="radio1" type="radio" id="radio1" value="P1" checked="checked" />
P1</label>

</div>
<div id="Layer13">

<label>
<input name="radio1" type="radio" id="radio1" value="P2" />
P2</label>

</div>
<div id="Layer14">

<label>
<input name="radio1" type="radio" id="radio1" value="P3" />
P3</label>

</div>
<div id="Layer15">

<label>
<input name="radio1" type="radio" id="radio1" value="P4" />
P4</label>

</div>
<div id="Layer16">

<label>MAXIMUM TICKET
<input type="text" name="textfield" />
</label>

</div>
<div id="Layer17">

<label>SERVICE DROP DOWN
<select name="select" style="width: 162px; height: 23px">
<option>SELECT SERVICE DROP DOWN</option>
<option>OTHER(FW)</option>
<option>1 MESSAGE</option>
<option>1 MOBILITY</option>
<option>1 VOICE</option>
<option>1 SAP</option>
<option>1 PORTAL</option>
<option>1 COLLAB</option>
<option>1 GSAP</option>
<option>1 SECURITY</option>
<option>1 WAN</option>
<option>S DOMAIN</option>
<option>1 AUTH</option>
<option>1 DOCM</option>
<option>1 REMOTE</option>
</select>
</label>

</div>
<div id="Layer18">

<label>RG GROUP
<select name="select2" style="width: 162px; height: 23px">
<option>SELECT RG GROUP</option>
<option>I-AM-AU-AM-HWT</option>
<option>I-EUS-IN-CSC-DSK-CSD</option>
<option>I-EUS-IN-CSC-DSK-GSD</option>
<option>I-EUS-GB-DCS-BHPVICFW</option>
<option>I-ITS-AU-HW</option>
<option>I-SRM-AU-IAM-LAMU</option>
<option>I-ITS-AU-SW</option>
<option>C-BHP-AU-CSC-LSD-NONBRG</option>
<option>C-BHP-AU-ACN-AQM</option>
</select>
</label>

</div>
</div>
<div id="Layer19">

<label>SELECT GROUPS
<select name="select3" onchange="showInfo()" style="width: 162px; height: 23px">
<option value="none" >SELECT GROUPS</option>
<option value="verify">TP</option>
<option value="verify1">OA</option>
<option>OC</option>
<option>OTHERS</option>
</select>
</label>
<div id="verify" style="display:none;">

<br/><br/>
<label>INCOMING CALL/EMAIL TIME
<input type="text" name="textfield4" />
</label>
<br/><br/>
<label>MAXIMO TICKET CREATED TIME
<input type="text" name="textfield3" />
</label>
</div>

<div id="Layer24">

<label>COMMENTS
<input type="text" name="textfield2" />
</label>

</div>
<div id="Layer26">

<input name="Reset" type="reset" id="Reset" value="Reset" />

</div>
<div id="Layer25">
<input type="submit" name="Submit" value="Submit" />
<input type="hidden" name="chkbox1" id="chkbox1" />
<input type="hidden" name="chkbox2" id="chkbox2" />
<input type="hidden" name="chkbox3" id="chkbox3" />
<input type="hidden" name="chkbox4" id="chkbox4" />
<input type="hidden" name="chkbox5" id="chkbox5" />
<input type="hidden" name="rad11" id="rad11" value="<?php echo $_GET['rad1']; ?>" />
<input type="hidden" name="idd" id="idd" value="<?php echo $_GET['empid']; ?>" />
<input type="hidden" name="odate" id="odate" value="<?php echo $_GET['date']; ?>" />
</form>

</div>
</div>
</div>
</body>
</html>

THANKS IN ADVANCED

Unable To Save Submitted Data In A Mysql Database Using Php

Similar Tutorials

View Content

<?php $GLOBALS['title']="Admission-HMS"; $base_url="http://localhost/hms/"; require('./../../inc/sessionManager.php'); require('./../../inc/dbPlayer.php'); require('./../../inc/fileUploader.php'); require('./../../inc/handyCam.php'); $ses = new \sessionManager\sessionManager(); $ses->start(); if($ses->isExpired()) { header( 'Location:'.$base_url.'login.php'); } else { $name=$ses->Get("loginId"); } $msg=""; if ($_SERVER["REQUEST_METHOD"] == "POST") { if (isset($_POST["btnSave"])) { $db = new \dbPlayer\dbPlayer(); $msg = $db->open(); echo '<script type="text/javascript"> alert("'.$msg.'");</script>'; if ($msg = "true") { $userIds = $db->getAutoId("U"); $flup = new fileUploader\fileUploader(); $perPhoto = $flup->upload("/hms/files/photos/",$_FILES['perPhoto'], $userIds[1]); // var_dump($perPhoto); $handyCam=new \handyCam\handyCam(); if (strpos($perPhoto, 'Error:') === false) { $dateNow=date("Y-m-d"); $data = array( 'userId' => $userIds[1], 'userGroupId' => "UG004", 'name' => $_POST['name'], 'studentId' => $_POST['stdId'], 'cellNo' => $_POST['cellNo'], 'gender' => $_POST['gender'], 'dob' => $handyCam->parseAppDate($_POST['dob']), 'passportNo' => $_POST['passportNo'], 'fatherName' => $_POST['fatherName'], 'fatherCellNo' => $_POST['fatherCellNo'], 'perPhoto' => $perPhoto, 'admitDate' => $dateNow, 'isActive' => 'Y' ); $result = $db->insertData("studentinfo",$data); if($result>=0) { $data = array( 'userId' => $userIds[1], 'userGroupId' => "UG004", 'name' => $_POST['name'], 'loginId' => $_POST['stdId'], 'verifyCode' => "vhms2115", 'expireDate' => "2115-01-4", 'isVerifed' => 'Y' ); $result=$db->insertData("users",$data); if($result>0) { $id =intval($userIds[0])+1; $query="UPDATE auto_id set number=".$id." where prefix='U';"; $result=$db->update($query); // $db->close(); echo '<script type="text/javascript"> alert("Admitted Successfully.");</script>'; } else { echo '<script type="text/javascript"> alert("' . $result . '");</script>'; } } elseif(strpos($result,'Duplicate') !== false) { echo '<script type="text/javascript"> alert("Student Already Exits!");</script>'; } else { echo '<script type="text/javascript"> alert("' . $result . '");</script>'; } } else { echo '<script type="text/javascript"> alert("' . $perPhoto . '");</script>'; } } else { echo '<script type="text/javascript"> alert("' . $msg . '");</script>'; } }

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.

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);
?>

Having A Form Insert The Data In The Database.

Similar Tutorials

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'])).'';
}

?>

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

I Want Insert Data In Database With "spaces ".

Similar Tutorials

View Content

<?php

require_once('upper.php');

require_once('database.php');

echo $error_msg='';

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

{

$LoginId=mysqli_real_escape_string($dbc,trim($_POST['LoginId']));

$Password1=mysqli_real_escape_string($dbc,trim($_POST['Password1']));

$Password2=mysqli_real_escape_string($dbc,trim($_POST['Password2']));

$Name=mysqli_real_escape_string($dbc,trim($_POST['Name']));

$Age=mysqli_real_escape_string($dbc,trim($_POST['Age']));

$BloodGroup=mysqli_real_escape_string($dbc,trim($_POST['BloodGroup']));

if(!isset($_POST['Sex']))

{

echo 'Please enter Sex<br>';

}

else{

$Sex= mysqli_real_escape_string($dbc,trim($_POST['Sex']));

}

$Qualification=mysqli_real_escape_string($dbc,trim($_POST['Qualification']));

$ContactNumber=mysqli_real_escape_string($dbc,trim($_POST['ContactNumber']));

$Email=mysqli_real_escape_string($dbc,trim($_POST['Email']));

$Address=mysqli_real_escape_string($dbc,trim($_POST['Address']));

$AboutYourself=mysqli_real_escape_string($dbc,trim($_POST['AboutYourself']));

//$countCheck=count($_POST['checkbox']);

//echo $countCheck;

//$checkbox=$_POST['checkbox'];

//$countCheck=count($checkbox);

    if(empty($LoginId)){echo 'Please enter Login Id';}

    elseif(empty($Password1)){echo 'Please enter Password';}

    elseif(empty($Password2)){echo 'Please confirm Password';}

    elseif($Password1!==$Password2){echo 'Password didn\'t match';}

        elseif(empty($Name)){echo 'Please enter Name';}

        elseif(empty($Age)){echo 'Please enter Age';}

        elseif(!isset($_POST['Sex'])){}

        elseif(empty($Qualification)){echo 'Please enter Qualification';}

        elseif(empty($ContactNumber)){echo 'Please enter Contact Number';}

        elseif(empty($Email)){echo 'Please enter Email';}

        elseif(empty($Address)){echo 'Please enter Address';}

        elseif(empty($AboutYourself)){echo 'Please enter About Yourself';}

        elseif(!isset($_POST['checkbox'])){ echo 'You have to register at least one activity.';}

        else

        {

        require_once('database.php');

        $query="select * from registration where LoginId='$LoginId'";

        $result=mysqli_query($dbc,$query);

        if(mysqli_num_rows($result)==0)

        {

        $checkbox=$_POST['checkbox'];

        $countCheck=count($_POST['checkbox']);

        $reg_id=' ';

        for($i=0;$i<$countCheck;$i++)

        {

        $reg_id=$reg_id.$checkbox[$i].',';

        }

        $query="insert into registration (LoginId,Password,Name,Age,BloodGroup,Sex,Qualification,ContactNumber,Email,Address,AboutYourself,Activity)values ('$LoginId',SHA('$Password1'),'$Name','$Age','$BloodGroup','$Sex','$Qualification','$ContactNumber','$Email','$Address','$AboutYourself',',$reg_id')";

        $result=mysqli_query($dbc,$query) or die("Not Connect");



        echo ' Dear '.$Name.'.<br>Your Account is waiting for approval<br>';

        //header('Location: index.php');

        //    header('Location: Registration.php');

        }

        else

        {

        echo 'Dear '.$Name. ', <br> An account already exist with login-id<b> '.$LoginId.'</b> <br>Please try another login-id';

        }}

}

?>

<html>

<body>

<?php

echo $error_msg; ?>

<form action='<?php echo $_SERVER['PHP_SELF'];?>' method='post'>

<div class="registration_and_activity">

<table border="0" width="400">

<tr><td colspan="2">

<h3>New User?</h3></td></tr>

<tr><td width="120">

Enter Login id</td><td><input type='text' name='LoginId' value='<?php if(!empty($LoginId))echo $LoginId;?>' /></td></tr>

<tr><td>

Enter Password</td><td><input type='password' name='Password1' value='<?php if(!empty($Password1))echo $Password1;?>' /></td></tr>

<tr><td>

Confirm Password</td><td><input type='password' name='Password2' value='<?php if(!empty($Password2))echo $Password2;?>' /></td></tr>

<tr><td>

Enter Name</td> <td><input type='text' name='Name' value='<?php if(!empty($Name))echo $Name;?>' /></td></tr>

<tr><td>

Enter Age</td><HEAD>

   <SCRIPT language=Javascript>



      function isNumberKey(evt)

      {

         var charCode = (evt.which) ? evt.which : event.keyCode

         if (charCode > 31 && (charCode < 48 || charCode > 57))

            return false;

         return true;

      }







   </SCRIPT>

   </HEAD>

<td><INPUT onkeypress='return isNumberKey(event)' type='text' name='Age' value='<?php if(!empty($Age))echo $Age;?>'/></td></tr>

<tr><td>

Enter Blood</td><td><input type='text' name='BloodGroup'value='<?php if(!empty($BloodGroup))echo $BloodGroup;?>' /></td></tr>

<tr><td>

Enter Sex</td><td><input type='radio' name='Sex' style='width:16px; border:0;' 'value='Male' />Male   <input type='radio' name='Sex' style='width:16px; border:0;' 'value='Female' />Female</td></tr>

<tr><td>

Enter Qualification</td><td><input type='text' name='Qualification' value='<?php if(!empty($Qualification))echo $Qualification;?>' /></td></tr>

<tr><td>

Enter Contact Number </td><td><input onkeypress='return isNumberKey(event)'type='text' name='ContactNumber' value='<?php if(!empty($ContactNumber))echo $ContactNumber;?>' /></td></tr>

<tr><td>

Enter Email</td><td><input type='text' name='Email' value='<?php if(!empty($Email))echo $Email;?>' /></td></tr>

<tr><td>

Enter Address</td><td><input type='text' name='Address' value='<?php if(!empty($Address))echo $Address;?>' /></td></tr>

<tr><td>

About Yourself :</td></tr>

<tr><td colspan="2"><textarea rows='10' cols='40' name='AboutYourself' value='<?php if(!empty($AboutYourself))echo $AboutYourself;?>' /></textarea></td></tr>

<tr><td>

<?php echo"

<tr><td colspan='2'><b>Select fields for which you want to register</b></td></tr>";

require_once('database.php');

$query="select * from activity";

$result=mysqli_query($dbc,$query);

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

$Title=$row['Title'];

$ActivityId=$row['ActivityId'];

echo "<tr><td>$Title</td>";

//echo $ActivityId;

[B]echo "<td><input type='checkbox' name='checkbox[]' value=$Title [/B]style='width:14px; text-align:right;'/></td></tr>";//value=$ActivityId tells ActivityId variable extracts with name="checkbox"

echo "<br/>";

}

echo "<tr><td colspan='2' align='center'><input type='submit' value='Register' name='submit' style='background:url(./images/button_img2.png) no-repeat 10px 0px; width:100px; padding:3px 0 10px 0; color:#FEFBC4; border:0;'/></td></tr><br>";



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

</div>

</form>

</body>

</html>";

require_once('lower.php');

?>

In above code when $Title="Fire" or any single word, it inserts in database properly but when $Title="Terrist Attack" or any data more than one word it inserts only the first word "Terrist".
I want to insert the whole "Terrist Attack " as it is in database.........
What i should do??????????/
Plzzzzzzzzzzz help Anyone????????????

Unable To Get Insert To Work Correctly?

Similar Tutorials

View Content

MySQL version 5.1.73-cll I can't seem to get the inventory table to insert the information I have stared in an array any help would be appreciated!!

<?php
$username = $_SESSION['username'];
ini_set('display_errors',1); 
error_reporting(E_ALL);
	
	//include "php/db/db_config.php";
	include "php/db/db_config.php";
	include "php/db/item_connect.php";
	
	$id = $items_id['id'];
	$player = $account_info['player_id'];
	
	//Update database
	$sql = mysqli_query($my_database,"INSERT INTO inventory ( player_id, username, id ) VALUES('$player', '$username', '$id')");
				
//echo values of item id		
echo "<div class=\"loot\">";	
echo "<b>Required Level:" . $items_id['requ_level'] . "</b><br />";
echo "<b>Name:" . $items_id['name'] . "</b><br />";
echo "<b>Min Str:" . $items_id['min_str'] . "<br />";
echo "<b>Min Int:" . $items_id['min_int'] . "<br />";
echo "<b>Min Dex:" . $items_id['min_dex'] . "<br />";
echo "<b>Type:" . $items_id['type']. "<br />";
echo "<b>Min Physical Dmg:" . $items_id['min_dmg'] . "<br />";
echo "<b>Max Physical Dmg:" . $items_id['max_dmg'] . "<br />";
echo "<b>Min Magic Dmg:" . $items_id['mag_attk_min'] . "<br />";
echo "<b>Max Magic Dmg:" . $items_id['mag_attk_max'] . "<br />";
echo "<b>Phys Defense:" . $items_id['phy_def'] . "<br />";
echo "<b>Magical Defense:" . $items_id['mag_def'] . "<br />";
echo "</div>";
?>

I get no errors or notices and the info fields show up as being populated.

Unable To Insert Into Table Value From Dropdown List

Similar Tutorials

View Content

Hello everyone !!!

I am sorry if my vocabulary is not exact because english is not my first language. Also i am a newbie at PHP. I am doing this project for myself and if it work might be able to use it at work. But i am doing this to learn. I have been stuck on this problem for 2 weeks and i can t figure it out on my own. Ihave spend many hours searching forums but no success. Oh yeah i almost forgot some part of code are from me, some are scripts from internet i adapted.

I have a form with a dropdown menu and when i submit the form the value selected in the dropdown would be inserted in a table. The problem i have is that whatever the value i select it always inserts the last value of the dropdown in the table???

The form is made with the dropdown as an include. It is populated with values from an another table.
Here is the code for the dropdown list:
Code: [Select]
<form>
<select name="nom_pcu_form" method="post">
<?php
$SQL = "SELECT * FROM pcu ORDER BY nom_pcu";
$res = mysql_query($SQL);
while($val=mysql_fetch_array($res))
{
$nom=$val["nom_pcu"];
$prenom=$val["prenom_pcu"];
$nom_complet = $prenom . $nom;
echo "<option>".$val["nom_pcu"].", ".$val["prenom_pcu"]."</option>\n";

$nom_pcu_form="".$val["nom_pcu"].", ".$val["prenom_pcu"]."";
}
?>
</select>
</form>

Here is the part of the form wich calls the dropdown:

Code: [Select]
<form name="form2" method="post" action="Grille ecoute Permanent.php">

<p>Nom :
<?php include 'liste_deroulante_pcu.php' ;?>
<p>no carte appel
<input name="no_carte_appel" type="text" id="no_carte_appel">
</p>
<?php  echo date("Y/m/d"); ?>

</form>

And this is the part where it is inserted in the table:

Code: [Select]
<?php
  if($_POST['doSubmit'] == 'Create')




mysql_query("INSERT INTO grille_ecoute_pcu_permanent (`user_name`,`nom_pcu`,`no_carte_appel`,`question_1`,`question_2`,`question_3`,`question_4`,
`question_5`,`question_6`,`question_7`,`question_8`,`question_9`,`question_10`,`question_11`,`question_12`,`question_13`,`question_14`,`question_15`,
`question_16`,`question_17`,`question_18`,`question_19`,`question_20`,`question_21`,`question_22`,`question_23`,`question_24`,`question_25`,`question_26`,
`question_27`,`question_28`,`question_29`)
VALUES ('$user_name','$nom_pcu_form','$no_carte_appel','$question_1','$question_2','$question_3','$question_4','$question_5','$question_6',
'$question_7','$question_8','$question_9','$question_10','$question_11','$question_12','$question_13','$question_14','$question_15','$question_16','$question_17',
'$question_18','$question_19','$question_20','$question_21','$question_22','$question_23','$question_24','$question_25','$question_26','$question_27','$question_28',
'$question_29')
") or die(mysql_error());
Note:$user_name and all $question are inserted correctly in the table.
$nom_pcu_form is the dropdown and it only records the last value of the dropdown even if it s not the value selected.
$no_carte_appel are not recorded at all

thanks for your time

Help !! My Database Detail Unable To Display

Similar Tutorials

View Content

This is my code is display my database (member_details) after user sign up but when a user register first name = <script>window.location="google.com"</script> This error occur=(The requested URL /yy2/html/google.com was not found on this server)

Code: [Select]
<?php
  session_start();
  include ('includes/database_connection.inc.php');
$conn = connectDatabase();

  if($_SESSION['uid'] == ''){
    // redirect unauthenticate user to login page.
  header('Location: login.php');
  }

  if($_GET['task'] == 'delete' && $_GET['id'] != ''){
      // delete function here
     $sql="DELETE FROM Newest Where ID='".mysql_real_escape_string($_GET['id'])."'";

     mysql_query($sql,$conn);
     header('Location: member_list.php');
  }

  if($_POST['Logout']){
     session_destroy();
   header('Location: login.php');
}

?>

<html><head><title>Member Details</title>
</head>
<body>
<div style=" margin: 350px ">
<?php

      $sql="SELECT * FROM Newest";
      $rs = mysql_query($sql,$conn)
        or die( mysql_error() );


   $list = "<table border=\"1\" cellpadding= \"2\">";
   $list .= "<tr><th>First Name</th>";
   $list .="<th>Last Name</th>";
   $list .= "<th>User Name</th>";
   $list .= "<th>Email</th>";
   $list .= "<th>Edit User</th>";
   $list .= "<th>Delete User</th>";
    $list .= "<th>Change Password</th>";


While( $row = mysql_fetch_array($rs) ) {

    $list .= "<tr>";
    $list .= "<td>".$row["name"]."</td>";
     $list .= "<td>".$row["last"]."</td>";
    $list .= "<td>".$row["user"]."</td>";
    $list .= "<td>".$row["email"]."</td>";
    $list .= "<td><a href='member_details.php?id=".$row['ID']."'>Edit</a></td>";
    $list .= "<td><a onclick='return confirm(\"Are you sure to delete ".$row["name"]." \")' href='member_list.php?id=".$row["ID"]."&task=delete'>Delete</a></td>";
     $list .= "<td><a  href='Password.php?id=".$row['ID']."'>Click Here</a></td>
     </tr>";

}
   $list .= "</table>";
   echo ( $list );

?>
<form method="post" action="member_list.php"><br>
<div style="margin : 0px 600px">
<style type="text/css">
body {background:#F5F5F5 url('http://images.apple.com/downloads/dashboard/travel/images/traveltodolist_20070724165034.jpg') no-repeat top;;

}</style>

<input type="submit" name="Logout" value="logout" />

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

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

Unable To Delete The Rows From The Database

Similar Tutorials

View Content

Hi,
I have created a table named multipath with database name "mydatabase".. I have created a table to store the data in the tables. Check boxes are created to select one row each to delete. But I am unable to delete the rows. Why??

Here's my PHP code

<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="mydatabase"; // Database name
$tbl_name="multipath"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF"> </td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mysql</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">#</td>
<td align="center" bgcolor="#FFFFFF"><strong>Path ID</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Path</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td bgcolor="#FFFFFF"><?php echo $rows['path_id']; ?></td>
<td bgcolor="#FFFFFF"><?php echo $rows['path']; ?></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
// Check if delete button active, start this
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}

// if successful redirect to delete.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

Please u can reply me at sawyerford007ATgmail DOTcom

Unable To Input Value Into Database Table Using Php Code

Similar Tutorials

View Content

Hi,

I need some help here, the one which I have highlighted in red, 'dob' and 'gender', are not inputting any values into my database table. I'm just wondering did I miss out something important, or should I change the 'type' in my database table? Thanks

<?php

$dob = $_POST['dob'];
$gender = $_POST['gender'];

/**INSERT into tutor_profile table**/
   $query2 = "INSERT INTO tutor_profile (name, nric, dob, gender, race) VALUES ('$name', '$nric', '$dob', '$gender', '$race')";

   $results2 = mysqli_query($dbc, $query2)
   or die(mysqli_error());

?>

<html>
<div>
         <label for="dob" class="label">Date Of Birth</label>
         <input name="dob" type="text" id="dob"/>
      </div>
</html>


      <div>
         <label for="race" class="label">Race</label>

         <?php
         echo '<select name="race" id="race">
         <option value="">--Please select one--</option>';

         $dbc = mysqli_connect('localhost', '111', '111', '111')
         or die(mysqli_error());
         $query = ("SELECT * FROM race ORDER BY race_id ASC");
         $sql = mysqli_query($dbc, $query)
         or die(mysqli_error());

            while($data = mysqli_fetch_array($sql)) {
               echo'<option value="'.$data['race_id'].'">'.$data['race_name'].'</option>';
            }
         echo '</select><br/>';

         mysqli_close($dbc);    ?>

      </div>

Unable To Load Image Data

Similar Tutorials

View Content

I wonder whether someone may be able to help me please.

I'm trying to put together a PHP within Aurigma Image Uploader which will create an image gallery. To do this I need to extract the image from a folder called 'Thumbnails' and image data from a file called 'files.xml'.

The code below is an extract of the default script that performs this functionality and I've tested and it works without any issues.

Code: [Select]
<?php

  //This variable specifies relative path to the folder, where the gallery with uploaded files is located.
  //Do not forget about the slash in the end of the folder name.
  $galleryPath = 'UploadedFiles/';

  $thumbnailsPath = $galleryPath . 'Thumbnails/';

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR;

  $descriptions = new DOMDocument('1.0');
  $descriptions->load($absGalleryPath . 'files.xml');
?>
I have now changed my folder and file structure to the following:

UploadedFiles (Folder)
username (Subfolder containing the 'location' folder) location (Subfolder containing 'Thumbnails folder and image, and 'files.xml') Please note that both the 'username' and 'location' folders are dynamically created when the user initially uploads the images.
To try and accomodate the new file structure I changed my code to:

Code: [Select]
<?php

  //This variable specifies relative path to the folder, where the gallery with uploaded files is located.
  //Do not forget about the slash in the end of the folder name.
  $galleryPath = 'UploadedFiles/';

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $usernamefolder . DIRECTORY_SEPARATOR . $locationfolder . DIRECTORY_SEPARATOR;

  $thumbnailsPath = $galleryPath . 'Thumbnails/';

  $descriptions = new DOMDocument('1.0');
  $descriptions->load($absGalleryPath . 'files.xml');
?>
But when I run this I receive the following error:

Quote

d333603417/htdocs/development/UploadedFiles/files.xml" in /homepages/2/d333603417/htdocs/development/gallery.php on line 14

Line 14 is this line:
Code: [Select]
$descriptions->load($absGalleryPath . 'files.xml');

I've been working on this for days and I just can't seem to find the answer.

I just wondered whether someone could possibly look at this and let me know where I'm going wrong.

If it helps, I've added the upload script below.

Code: [Select]
<?php
require_once 'Includes/gallery_helper.php';
require_once 'ImageUploaderPHP/UploadHandler.class.php';
$galleryPath = 'UploadedFiles/';

function onFileUploaded($uploadedFile) {
  global $galleryPath;

  $packageFields = $uploadedFile->getPackage()->getPackageFields();
  $username=$packageFields["username"];
  $locationid=$packageFields["locationid"];
  $username = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['username']);
  $location = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['locationid']);
  $dirName = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['folder']);

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $username . DIRECTORY_SEPARATOR . $location . DIRECTORY_SEPARATOR;
  $absThumbnailsPath = $absGalleryPath . 'Thumbnails' . DIRECTORY_SEPARATOR;

  if (!is_dir($absGalleryPath)) mkdir($absGalleryPath, 0777, true);
  chmod($absGalleryPath, 0777);
  if (!is_dir($absGalleryPath . $dirName)) mkdir($absGalleryPath . $dirName, 0777, true);
  chmod($absGalleryPath . $dirName, 0777);

  if ($uploadedFile->getPackage()->getPackageIndex() == 0 && $uploadedFile->getIndex() == 0)
    initGallery($absGalleryPath, $absThumbnailsPath, FALSE);

  $originalFileName = $uploadedFile->getSourceName();
  $files = $uploadedFile->getConvertedFiles();
  $sourceFileName = getSafeFileName($absGalleryPath, $originalFileName);
  $sourceFile = $files[0];

  if ($sourceFile) $sourceFile->moveTo($absGalleryPath . $sourceFileName);
  $thumbnailFileName = getSafeFileName($absThumbnailsPath, $originalFileName);
  $thumbnailFile = $files[1];
  if ($thumbnailFile) $thumbnailFile->moveTo($absThumbnailsPath . $thumbnailFileName);

  $descriptions = new DOMDocument('1.0', 'utf-8');
  $descriptions->load($absGalleryPath . 'files.xml');

  $xmlFile = $descriptions->createElement('file');
  // <-- please check the following line
  $xmlFile->setAttribute('name', $_POST['folder'] . '/' . $originalFileName);
  $xmlFile->setAttribute('source', $sourceFileName);
  $xmlFile->setAttribute('size', $uploadedFile->getSourceSize());
  $xmlFile->setAttribute('originalname', $originalFileName);
  $xmlFile->setAttribute('thumbnail', $thumbnailFileName);
  $xmlFile->setAttribute('description', $uploadedFile->getDescription());
  $xmlFile->setAttribute('username', $username);
  $xmlFile->setAttribute('locationid', $locationid);
  $xmlFile->setAttribute('folder', $dirName);

  $descriptions->documentElement->appendChild($xmlFile);
  $descriptions->save($absGalleryPath . 'files.xml');
}

$uh = new UploadHandler();
$uh->setFileUploadedCallback('onFileUploaded');
$uh->processRequest();
?>
Many thanks