PHP - Insert Data Into Database Without Waiting For It

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

?>

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'],
     ['','','','','','']
];

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

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

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

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

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">
<!--
#Layer1 {
position:absolute;
width:1005px;
height:578px;
z-index:1;
left: 157px;
top: 1px;
background-color: #993399;
}
#Layer2 {
position:absolute;
width:939px;
height:114px;
z-index:1;
left: 35px;
top: 35px;
}
#Layer3 {
position:absolute;
width:451px;
height:169px;
z-index:2;
left: 270px;
top: 296px;
}
#Layer4 {
position:absolute;
width:608px;
height:68px;
z-index:2;
left: 273px;
top: 10px;
}
#Layer5 {
position:absolute;
left:82px;
top:188px;
width:973px;
height:52px;
z-index:2;
}
#Layer6 {
position:absolute;
width:243px;
height:106px;
z-index:2;
left: 68px;
top: 43px;
}
.style1 {
font-size: xx-large;
font-style: italic;
}
.style2 {font-size: 52px}
#Layer7 {
position:absolute;
width:824px;
height:271px;
z-index:2;
left: 44px;
top: 237px;
}
.style4 {
font-size: xx-large;
font-style: italic;
font-weight: bold;
color: #FF9933;
}
#Layer8 {
position:absolute;
width:800px;
height:139px;
z-index:2;
left: 31px;
top: 67px;
}
#Layer9 {
position:absolute;
width:610px;
height:30px;
z-index:2;
left: 34px;
top: 70px;
}
#Layer10 {
position:absolute;
width:611px;
height:25px;
z-index:2;
left: 33px;
top: 110px;
}
#Layer11 {
position:absolute;
width:614px;
height:30px;
z-index:2;
left: 33px;
top: 152px;
}
#Layer12 {
position:absolute;
width:615px;
height:29px;
z-index:2;
left: 32px;
top: 193px;
}
#Layer13 {
position:absolute;
width:187px;
height:35px;
z-index:2;
left: 318px;
top: 239px;
}
-->
</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">&nbsp;</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">
<!--
#Layer1 {
position:absolute;
width:1023px;
height:592px;
z-index:1;
left: 167px;
top: 2px;
background-color: #993399;
}
#Layer2 {
position:absolute;
width:939px;
height:114px;
z-index:1;
left: 59px;
top: 3px;
}
#Layer3 {
position:absolute;
width:451px;
height:169px;
z-index:2;
left: 270px;
top: 296px;
}
#Layer4 {
position:absolute;
width:608px;
height:68px;
z-index:2;
left: 273px;
top: 10px;
}
#Layer5 {
position:absolute;
left:82px;
top:188px;
width:973px;
height:52px;
z-index:2;
}
#Layer6 {
position:absolute;
width:238px;
height:69px;
z-index:2;
left: 68px;
top: 43px;
}
.style1 {
font-size: xx-large;
font-style: italic;
}
.style2 {font-size: 52px}
#Layer7 {
position:absolute;
width:979px;
height:209px;
z-index:2;
left: 32px;
top: 181px;
}
#Layer8 {
position:absolute;
width:194px;
height:36px;
z-index:1;
left: 25px;
top: 15px;
}
#Layer9 {
position:absolute;
width:178px;
height:37px;
z-index:2;
left: 249px;
top: 13px;
}
#Layer10 {
position:absolute;
width:193px;
height:34px;
z-index:3;
left: 443px;
top: 13px;
}
#Layer11 {
position:absolute;
width:204px;
height:32px;
z-index:4;
left: 670px;
top: 15px;
}
#Layer12 {
position:absolute;
width:195px;
height:40px;
z-index:5;
left: 28px;
top: 73px;
}
#Layer13 {
position:absolute;
width:182px;
height:38px;
z-index:6;
left: 250px;
top: 76px;
}
#Layer14 {
position:absolute;
width:197px;
height:36px;
z-index:7;
left: 446px;
top: 77px;
}
#Layer15 {
position:absolute;
width:214px;
height:35px;
z-index:8;
left: 670px;
top: 77px;
}
#Layer16 {
position:absolute;
width:315px;
height:45px;
z-index:9;
left: 16px;
top: 144px;
}
#Layer17 {
position:absolute;
width:343px;
height:43px;
z-index:10;
left: 339px;
top: 145px;
}
#Layer18 {
position:absolute;
width:258px;
height:48px;
z-index:11;
left: 708px;
top: 146px;
}
#Layer19 {
position:absolute;
width:321px;
height:60px;
z-index:3;
left: 59px;
top: 419px;
}
#Layer20 {
position:absolute;
width:197px;
height:41px;
z-index:1;
left: 27px;
top: 6px;
}
#Layer21 {
position:absolute;
width:193px;
height:36px;
z-index:2;
left: 249px;
top: 7px;
}
#Layer22 {
position:absolute;
width:207px;
height:38px;
z-index:3;
left: 453px;
top: 7px;
}
#Layer23 {
position:absolute;
width:237px;
height:36px;
z-index:4;
left: 677px;
top: 9px;
}
#Layer24 {
position:absolute;
width:245px;
height:45px;
z-index:5;
left: 399px;
top: 2px;
}
#Layer25 {
position:absolute;
width:99px;
height:31px;
z-index:6;
left: 288px;
top: 121px;
}
#Layer26 {
position:absolute;
width:87px;
height:29px;
z-index:7;
left: 439px;
top: 123px;
}
-->
</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">&nbsp;</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

hello
I want query from one table and insert in another table on another domain .
each database on one domain name.
for example http://www.site.com $con1
and http://www.site1.com $con.

can anyone help me?
my code is :
<?php



$dbuser1 = "insert in this database";
$dbpass1 = "insert in this database";
$dbhost1 = "localhost";
$dbname1 = "insert in this database";

// Connecting, selecting database

$con1 = mysql_connect($dbhost1, $dbuser1, $dbpass1)
   or die('Could not connect: ' . mysql_error());



mysql_select_db($dbname1) or die('Could not select database');


$dbuser = "query from this database";
$dbpass = "query from this database";
$dbhost = "localhost";
$dbname = "query from this database";

// Connecting, selecting database

$con = mysql_connect($dbhost, $dbuser, $dbpass)
   or die('Could not connect: ' . mysql_error());

mysql_select_db($dbname) or die('Could not select database');

//query from database
$query = mysql_query("SELECT * FROM `second_content` WHERE CHANGED =0 limit 0,1");
    while($row=mysql_fetch_array($query)){
$result=$row[0];
$text=$row[1]."</br>Size:(".$row[4].")";
$alias=$row[2];
$link = '<a target="_blank" href='.$row[3].'>Download</a>';
echo $result;
}  
//insert into  database
mysql_query("SET NAMES 'utf8'", $con1); 
$query3= " INSERT INTO `jos_content`
 (`id`,
  `title`,
   `alias`,
    `) VALUES 
                        (NULL, 
                        '".$result."', 
                        '".$alias."', 
                       '')";
if (!mysql_query($query3,$con1))
  {
  die('Error: text add' . mysql_error());
  }


            mysql_close($con);
                        mysql_close($con1);
             


?>

Hello to all,

I have problem figuring out how to properly display data fetched from MySQL database in a HTML table.

In the below example I am using two while loops, where the second one is nested inside first one, that check two different expressions fetching data from tables found in a MySQL database. The second expression compares the two tables IDs and after their match it displays the email of the account holder in each column in the HTML table.

The main problem is that the 'email' row is displayed properly while its while expression is not nested and alone(meaning the other data is omitted or commented out), but either nested or neighbored to the first while loop, it is displayed horizontally and the other data ('validity', 'valid_from', 'valid_to') is not displayed.'

Can someone help me on this, I guess the problem lies in the while loop?
Here is part of the HTML code:

<thead>
 <tr>
 <th data-column-id="id" data-type="numeric">ID</th>
 <th data-column-id="email">Subscriber's Email</th>
 <th data-column-id="validity">Validity</th>
<th data-column-id="valid_from">Valid From</th>
 <th data-column-id="valid_to">Valid To</th>
</tr>
</thead>

Here is part of the PHP code:

 

    <?php
    while($row = $stmt->fetch(PDO::FETCH_ASSOC))
    {
        echo '
            <tr>
                <td>'.$row["id"].'</td>
        ';
        while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)) {
        echo '
                <td>'.$row1["email"].'</td>
        ';
        }
        if($row["validity"] == 1) {
            echo '<td>'.$row["validity"].' month</td>';
        }else{
            echo '<td>'.$row["validity"].' months</td>';
        }
        echo '  <td>'.$row["valid_from"].'</td>
                <td>'.$row["valid_to"].'</td>
        </tr>';
    }
    ?>

P.S. Please know that I have purposely omitted the connection part and the methods in the class that are used in this code to keep the spot of the problem as clean as possible. If you need me to rephrase the question, please ask.

Thank you.

hi guys, im new to this forum

I'm new also to php, I need help from you guys:

I want to display personal information from a certain person (the data is on the mysql database) using his name as a link:

example:
               (index.php)
               names
                          1. Bill Gates
                          2. Mr. nice Guy
           
i want to click Bill Gates
 
   (output.php)
     Name: Bill Gates
     Country:xxxx
     Age: xx   
                 etc.

How can i make this or how to learn this?
   
                 

             
               

   
       

Hi, I've currently started to modify a chat script of mine to output a moderation panel but the moderation page seems empty(blank) every time I load it. What im trying to do is to take the ID part in my URL via the $_GET and look it up in my database table in the column named id, then select that specific row to be able to retrieve the StringyChat_ip and place it into another table to ban the IP and the second thing im trying to do is to be able to delete the specific row from my table.   My Http link look something like    http://imagecrab.fre.../ban.php?id=159   and my ban.php page where I want to lookup the 159 part and do the banning etc looks like

<?
include("admin_code_header.php");


if ($_POST["DeletePost"]) {
    $id = $_POST['id'];
    $query = "DELETE FROM ".$dbTable." WHERE id='".$id."'"; 
    mysql_query($query);
    echo "ID removed from system: ".$id;
  }


if ($_POST["BanIP"]) {
    $IP_To_Add = $_POST["ip"];
    
      $sql = "INSERT INTO ".$IPBanTable." (ip) VALUES (\"$IP_To_Add\")";
      $result = mysql_query($sql);
  }
$result = mysql_query("SELECT * FROM ".$dbTable." WHERE id='".$id."'",$db);

  while ($myrow = mysql_fetch_array($result)) {
    $msg = $myrow["StringyChat_message"];
$idm = $myrow["id"];



?>
<html>
<form name="form<? echo $myrow["id"];?>" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">

<input name="DeletePost" type="submit" id="DeletePost" value="Delete">

<input name="BanIP" type="submit" id="BanIP" value="Ban <? echo $myrow["StringyChat_ip"];?>">
    </form>
</html>
<?
}
?>

Hi guys,
I have a table that i want all the entries to be inserted all at once.
Mine is just inserting only one of the item, how can i get it to work? I also attached a sample table.

Thanks

	if(isset($_POST['send'])){
    
    $category = $_POST['category'];
    $item_type = $_POST['item_type'];
    $item_size = $_POST['item_size'];
    $product_name = $_POST['product_name'];
    $item_qty = $_POST['item_qty'];
    $price = $_POST['price'];
    $total_price = $_POST['total_price'];
    $item_price = $_POST['item_price'];
    
$sql = "
INSERT INTO shopping(
trans_ref,
category,
product_name,
item_type,
item_size,
item_qty,
item_price,
price,
date
)
	VALUES(
:trans_ref,
:category,
:product_name,
:item_type,
:item_size,
:item_qty,
:item_price,
:price,
NOW()
)
";
$stmt = $pdo->prepare($sql);
$stmt->execute(array(
':trans_ref' => $_SESSION['trans_ref'],
':category' => $category,
':product_name' => $product_name,
':item_type' => $item_type,
':item_size' => $item_size,
':item_qty' => $item_qty,
':item_price' => $item_price,
':price' => $price
));
	
if ( $stmt->rowCount()){    
    echo '<div class="alert bg-success text-center">SHOPPING COMPLETED</div>';
}else{
    echo '<div class="alert bg-danger text-center">SHOPPING NOT COMPLETED. A PROBLE OCCURED</div>';
}
	
}
	

how do I make the $image piece so that it inserts "images/$image.php" into the database?

   VALUES('$name', '$id', '$image','$event')";

I've begun to play around with object oriented php and I was wondering how I would go about writing a method that inserts values into a table.    I have a class, called queries, and I made this very simple function:

class queries {

    public function insert($table, $field, $value){

    global $dbh;
 
    $stmt = $dbh->prepare("INSERT INTO $table ($field) VALUES (:value)");
    $stmt->bindParam(":value", $value);
    $stmt->execute();
    }

}

$queries = new queries();

I am having an issue trying to get products that I am entering through my admin panel to go into my database. I am thinking that the programmer of the script might have forgot some code possibly, but everything else does get inserted into the database regarding categories, manufactures etc. Here is the insert product php script. My db and functions are set to go to my database with website name/password etc.

 

<?php

if(!isset($_SESSION['customer_email'])){

echo "<script> window.open('../checkout.php','_self'); </script>";

}

$customer_email = $_SESSION['customer_email'];

$get_customer = "select * from customers where customer_email='$customer_email'";

$run_customer = mysqli_query($con,$get_customer);

$row_customer = mysqli_fetch_array($run_customer);

$customer_id = $row_customer['customer_id'];

$select_general_settings = "select * from general_settings";

$run_general_settings = mysqli_query($con,$select_general_settings);

$row_general_settings = mysqli_fetch_array($run_general_settings);

$product_vendor_status = $row_general_settings["new_product_status"];

?>

<script src="//cdn.tinymce.com/4/tinymce.min.js"></script>

<script>tinymce.init({ selector:'#product_desc,#product_features' });</script>

<div class="row"><!-- 2 row Starts --> 

<div class="col-lg-12"><!-- col-lg-12 Starts -->

<div class="panel panel-default"><!-- panel panel-default Starts -->

<div class="panel-heading"><!-- panel-heading Starts -->

<h3 class="panel-title">

<i class="fa fa-money fa-fw"></i> Insert Product

</h3>

</div><!-- panel-heading Ends -->

<div class="panel-body"><!-- panel-body Starts -->

<form id="insert_product_form" method="post" enctype="multipart/form-data"><!-- form-horizontal Starts -->

<div class="row"><!-- 2 row Starts -->

<div class="col-md-9"><!-- col-md-9 Starts -->

<div class="form-group" ><!-- form-group Starts -->

<label> Product Title </label>

<input type="text" name="product_title" class="form-control" required >

</div><!-- form-group Ends -->

<div class="form-group" ><!-- form-group Starts -->

<label> Product Seo Description </label>

<textarea name="product_seo_desc" class="form-control" maxlength="230" placeholder="Most search engines use a maximum of 230 chars for the description."></textarea>

</div><!-- form-group Ends -->

<div class="form-group" ><!-- form-group Starts -->

<label> Product Url </label>

<input type="text" name="product_url" class="form-control" required >

<br>

<p style="font-size:15px; font-weight:bold;">
Product Url Example : navy-blue-t-shirt
</p>

</div><!-- form-group Ends -->

<div class="form-group"><!-- form-group Starts -->

<label> Product Tabs </label>

<ul class="nav nav-tabs"><!-- nav nav-tabs Starts -->

<li class="active">

<a data-toggle="tab" href="#description"> Product Description </a>

</li>

<li>

<a data-toggle="tab" href="#features"> Product Features </a>

</li>

<li>

<a data-toggle="tab" href="#video"> Sounds And Videos </a>

</li>

</ul><!-- nav nav-tabs Ends -->

<div class="tab-content"><!-- tab-content Starts -->

<div id="description" class="tab-pane fade in active"><!-- description tab-pane fade in active Starts -->

<br>
<textarea name="product_desc" class="form-control" rows="15" id="product_desc"></textarea>

</div><!-- description tab-pane fade in active Ends -->

<div id="features" class="tab-pane fade in"><!-- features tab-pane fade in Starts -->

<br>
<textarea name="product_features" class="form-control" rows="15" id="product_features"></textarea>

</div><!-- features tab-pane fade in Ends -->

<div id="video" class="tab-pane fade in"><!-- video tab-pane fade in Starts -->

<br>
<textarea name="product_video" class="form-control" rows="15"></textarea>

</div><!-- video tab-pane fade in Ends -->

</div><!-- tab-content Ends -->

</div><!-- form-group Ends -->

<div class="form-group" id="product_weight"><!-- form-group Starts -->

<label> Product Weight <small> (kg)</small> </label>

<input type="text" name="product_weight" class="form-control">

</div><!-- form-group Ends -->

<div class="form-group" id="product_price"><!-- form-group Starts -->

<label> Product Price </label>

<input type="text" name="product_price" class="form-control" required>

</div><!-- form-group Ends -->

<div class="form-group" id="product_psp_price"><!-- form-group Starts -->

<label> Product Sale Price </label>

<input type="text" name="psp_price" class="form-control">

</div><!-- form-group Ends -->

</div><!-- col-md-9 Ends -->

<div class="col-md-3"><!-- col-md-3 Starts -->

<div class="form-group"><!-- form-group Starts -->

<label> Select A Product Type </label>

<select class="form-control" name="product_type"><!-- select manufacturer Starts -->

<option value="physical_product"> (Physical Product) Simple Product </option>

<option value="digital_product"> (Digital Product) Downloadable Product </option>

<option value="variable_product"> (Variable Product) Advanced Product </option>

</select><!-- select manufacturer Ends -->

</div><!-- form-group Ends -->

<div class="form-group"><!-- form-group Starts -->

<label> Select A Manufacturer </label>

<select class="form-control" name="manufacturer"><!-- select manufacturer Starts -->

<option> Select A Manufacturer </option>

<?php

$get_manufacturer = "select * from manufacturers";
$run_manufacturer = mysqli_query($con,$get_manufacturer);
while($row_manufacturer= mysqli_fetch_array($run_manufacturer)){
$manufacturer_id = $row_manufacturer['manufacturer_id'];
$manufacturer_title = $row_manufacturer['manufacturer_title'];

echo "<option value='$manufacturer_id'>
$manufacturer_title
</option>";

}

?>

</select><!-- select manufacturer Ends -->

</div><!-- form-group Ends -->

<div class="form-group"><!-- form-group Starts -->

<label> Product Category </label>

<select name="product_cat" class="form-control" >

<option> Select  a Product Category </option>

<?php

$get_p_cats = "select * from product_categories";

$run_p_cats = mysqli_query($con,$get_p_cats);

while ($row_p_cats=mysqli_fetch_array($run_p_cats)) {

$p_cat_id = $row_p_cats['p_cat_id'];

$p_cat_title = $row_p_cats['p_cat_title'];

echo "<option value='$p_cat_id' >$p_cat_title</option>";

}

?>

</select>

</div><!-- form-group Ends -->

<div class="form-group" ><!-- form-group Starts -->

<label> Category </label>

<select name="cat" class="form-control" >

<option> Select a Category </option>

<?php

$get_cat = "select * from categories";

$run_cat = mysqli_query($con,$get_cat);

while ($row_cat=mysqli_fetch_array($run_cat)) {

$cat_id = $row_cat['cat_id'];

$cat_title = $row_cat['cat_title'];

echo "<option value='$cat_id'>$cat_title</option>";

}

?>

</select>

</div><!-- form-group Ends -->

<div class="form-group" ><!-- form-group Starts -->

<label> Product Image 1 </label>

<input type="file" name="product_img1" class="form-control" required >

</div><!-- form-group Ends -->

<div class="form-group" ><!-- form-group Starts -->

<label> Product Image 2 </label>

<input type="file" name="product_img2" class="form-control">

</div><!-- form-group Ends -->

<div class="form-group" ><!-- form-group Starts -->

<label> Product Image 3 </label>

<input type="file" name="product_img3" class="form-control">

</div><!-- form-group Ends -->

<div class="form-group" ><!-- form-group Starts -->

<label> Product Keywords </label>

<input type="text" name="product_keywords" class="form-control">

</div><!-- form-group Ends -->

<div class="form-group" ><!-- form-group Starts -->

<label> Product Label </label>

<input type="text" name="product_label" class="form-control">

</div><!-- form-group Ends -->

</div><!-- col-md-3 Ends -->

</div><!-- 2 row Ends -->

<div class="form-group" id="product-stock-management"><!-- form-group Starts -->

<label> Product Inventory Stock Management </label>

<div class="panel panel-default"><!-- panel panel-default Starts -->

<div class="panel-heading"><!-- panel-heading Starts -->

<strong> Inventory - Stock Options </strong>

</div><!-- panel-heading Ends -->

<div class="panel-body"><!--panel-body Starts -->

<div class="row"><!-- row Starts -->

<div class="col-sm-6" id="stock-status"><!-- col-sm-6 Starts -->

<div class="form-group"><!-- form-group Starts -->

<label> Stock Status </label>

<select class="form-control" name="stock_status" required><!-- select manufacturer Starts -->

<option value="instock">In stock</option>

<option value="outofstock">Out of stock</option>

<option value="onbackorder">On backorder</option>

</select><!-- select manufacturer Ends -->

</div><!-- form-group Ends -->

</div><!-- col-sm-6 Ends -->

<div class="col-sm-6"><!-- col-sm-6 Starts -->

<div class="form-group"><!-- form-group Starts -->

<label> Enable stock management at product level? </label>

<div class="radio">

<label>
  <input type="radio" name="enable_stock" value="yes" required> Yes
</label>

<label>
  <input type="radio" name="enable_stock" value="no" checked required> No
</label>

</div>

</div><!-- form-group Ends -->

</div><!-- col-sm-6 Ends -->

</div><!-- row Ends -->

<div class="row" id="stock-management-row"><!-- row Starts -->

<div class="col-sm-6"><!-- col-sm-6 Starts -->

<div class="form-group"><!-- form-group Starts -->

<label> Stock Quantity </label>

<input type="number" name="stock_quantity" value="0" class="form-control" required>

</div><!-- form-group Ends -->

</div><!-- col-sm-6 Ends -->

<div class="col-sm-6"><!-- col-sm-6 Starts -->

<div class="form-group"><!-- form-group Starts -->

<label> Allow backorders? </label>

<select class="form-control" name="allow_backorders" required><!-- select manufacturer Starts -->

<option value="no">Do not allow</option>

<option value="notify">Allow, but notify customer</option>

<option value="yes">Allow</option>

</select><!-- select manufacturer Ends -->

</div><!-- form-group Ends -->

</div><!-- col-sm-6 Ends -->

</div><!-- row Ends -->

</div><!--panel-body Ends -->

</div><!-- panel panel-default Ends -->

</div><!-- form-group Ends -->


</form><!-- form-horizontal Ends -->

<div class="form-group" id="variable_product_options"><!-- form-group Starts -->

<label> Variable Product Options </label>

<div class="panel panel-default"><!-- panel panel-default Starts -->

<div class="panel-heading"><!-- panel-heading Starts -->

<ul class="nav nav-tabs"><!-- nav nav-tabs Starts -->

<li class="active">

<a data-toggle="tab" href="#product_attributes"> Product Attributes </a>

</li>

<li>

<a data-toggle="tab" href="#product_variations"> Product Variations </a>

</li>

</ul><!-- nav nav-tabs Ends -->

</div><!-- panel-heading Ends -->

<div class="panel-body"><!--panel-body Starts -->

<div class="tab-content"><!-- tab-content Starts -->

<div id="product_attributes" class="tab-pane fade in active"><!-- product_attributes tab-pane fade in active Starts -->

<form id="insert_attribute_form" method="post"><!-- form Starts -->

<div class="row"><!-- row Starts -->

<div class="col-sm-4"><!-- col-sm-4 Starts -->

<div class="form-group"><!-- form-group Starts -->

<label> Name: </label>

<input type="text" name="attribute_name" class="form-control" required>

</div><!-- form-group Ends -->

</div><!-- col-sm-4 Ends -->

<div class="col-sm-8"><!-- col-sm-8 Starts -->

<div class="form-group"><!-- form-group Starts -->

<label> Value(s): </label>

<textarea name="attribute_values" class="form-control" placeholder="Enter some attributes by '|' separating values." required></textarea>

</div><!-- form-group Ends -->

</div><!-- col-sm-8 Ends -->

</div><!-- row Ends -->

<div class="form-group"><!-- form-group Starts -->

<input type="submit" value="Insert Product Attribute" class="btn btn btn-primary">

</div><!-- form-group Ends -->

</form><!-- form Ends -->

<table class="table table-hover table-bordered table-striped"><!-- table table-hover table-bordered table-striped Starts -->

<thead><!-- thead Starts -->

<tr>

<th>Attribute Name:</th>
<th>Attribute Value(s):</th>
<th>Actions:</th>

</tr>

</thead><!-- thead Ends -->

<tbody><!-- tbody Starts -->

<?php

$random_id = 152;

$select_product_attributes = "select * from product_attributes where product_id='$random_id'";

$run_product_attributes = mysqli_query($con,$select_product_attributes);

while($row_product_attributes = mysqli_fetch_array($run_product_attributes)){
	
$attribute_id = $row_product_attributes["attribute_id"];

$attribute_name = $row_product_attributes["attribute_name"];

$attribute_values = $row_product_attributes["attribute_values"];

?>

<tr id="tr-attribute-<?php echo $attribute_id; ?>">

<td> 

<div class="edit" data-attribute="<?php echo $attribute_id; ?>"><?php echo $attribute_name; ?></div>

<input type="text" id="attribute-name" class="input-edit form-control" data-attribute="<?php echo $attribute_id; ?>" value="<?php echo $attribute_name; ?>">

</td>

<td>

<div class="edit" data-attribute="<?php echo $attribute_id; ?>"><?php echo $attribute_values; ?></div>

<input type="text" id="attribute-values" class="input-edit form-control" data-attribute="<?php echo $attribute_id; ?>" value="<?php echo $attribute_values; ?>">

</td>

<td>

<div class="btn-group">

<a href="#" class="edit-product-attribute btn btn-primary btn-sm" data-attribute="<?php echo $attribute_id; ?>">

<i class="fa fa-pencil"></i> Edit

</a>

<a href="#" class="save-product-attribute btn btn-success btn-sm" data-attribute="<?php echo $attribute_id; ?>">

<i class="fa fa-floppy-o"></i> Save

</a>

<a href="#" class="delete-product-attribute btn btn-danger btn-sm" data-attribute="<?php echo $attribute_id; ?>">

<i class="fa fa-trash-o"></i> Delete

</a>

</div>

</td>

</tr>

<?php } ?>

</tbody><!-- tbody Ends -->

</table><!-- table table-hover table-bordered table-striped Ends -->

</div><!-- product_attributes tab-pane fade in active Ends -->

<div id="product_variations" class="tab-pane fade in"><!-- product_variations tab-pane fade in Starts -->

<form id="product-variations-form" method="post" enctype="multipart/form-data"><!-- form Starts -->

<div class="form-group row"><!-- form-group Starts -->

<label class="col-sm-3 control-label"> Default Form Values: </label>

<div class="col-sm-9"><!-- col-sm-10 Starts -->

<div class="row" id="default_form_values"><!-- row default_form_values Starts -->


</div><!-- row default_form_values Ends -->

<span class="help-block">

These are the product attributes that will be pre-selected on the frontend.

</span>

</div><!-- col-sm-9 Ends -->

</div><!-- form-group Ends -->

<hr class="variation-hr">

<div class="form-group row"><!-- form-group Starts -->

<label class="col-sm-1 control-label"> Actions: </label>

<div class="col-sm-10"><!-- col-sm-10 Starts -->

<select class="form-control" id="action_select"><!-- select manufacturer Starts -->

<option value="add_variation"> Add A New Variation </option>

<option value="create_variations_from_attributes"> Create New Variations From All Attributes </option>

<option value="delete_all_variations"> Delete All Variations </option>

</select><!-- select manufacturer Ends -->

</div><!-- col-sm-10 Ends -->

<div class="col-sm-1"><!-- col-sm-1 Starts -->

<button type="button" id="go_button" class="btn btn-success form-control"> Go </button>

</div><!-- col-sm-1 Ends -->

</div><!-- form-group Ends -->

<div class="product-variations-div"><!-- product-variations-div Starts -->


</div><!-- product-variations-div Ends -->

<hr class="variation-hr">

<div class="form-group"><!-- form-group Starts -->

<input type="submit" value="Save Product Variations" class="btn btn btn-success">

</div><!-- form-group Ends -->

</form><!-- form Ends -->

<div class="ajax-response-div"></div>

</div><!-- product_variations tab-pane fade in Ends -->

</div><!-- tab-content Ends -->

</div><!--panel-body Ends -->

</div><!-- panel panel-default Ends -->

</div><!-- form-group Ends -->

<div class="form-group"><!-- form-group Starts -->

<input type="submit" name="submit" value="Insert Product" form="insert_product_form" class="btn btn-primary form-control">

</div><!-- form-group Ends -->

</div><!-- panel-body Ends -->

</div><!-- panel panel-default Ends -->

</div><!-- col-lg-12 Ends -->

</div><!-- 2 row Ends --> 

<script>

$(document).ready(function(){

//Product Stock Management Code Starts

$("#stock-management-row").hide();

$("input[name='enable_stock']").click(function(){
	
var radio_value = $(this).val();

if(radio_value == "yes"){

$("#stock-status").hide();

$("#stock-management-row").show();
	
}else if(radio_value == "no"){
	
$("#stock-status").show();

$("#stock-management-row").hide();
	
}
	
});

//Product Stock Management Code Ends

//Change Product Type Function Code Starts

function change_product_type(){

var product_type = $("select[name='product_type']").val();

if(product_type == "physical_product"){
	
$("#product_weight").show();

$("#product_price").show();

$("#product_psp_price").show();

$('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", false);

$("#product-stock-management").show();

$('#product-stock-management input,#product-stock-management select').prop("disabled", false);

$("#variable_product_options").hide();
	
}else if(product_type == "digital_product"){

$("#product_weight").hide();

$("#product_price").show();

$("#product_psp_price").show();

$('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", false);

$("#product-stock-management").show();

$('#product-stock-management input,#product-stock-management select').prop("disabled", false);

$("#variable_product_options").hide();
	
}else if(product_type == "variable_product"){

$("#product_weight").hide();

$("#product_price").hide();

$("#product_psp_price").hide();

$('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", true);

$("#product-stock-management").hide();

$('#product-stock-management input,#product-stock-management select').prop("disabled", true);

$("#variable_product_options").show();
	
}
	
}

//Change Product Type Function Code Ends

change_product_type();
 
$("select[name='product_type']").change(function(){
	
change_product_type();
  
});

//Load Product Attributes Function Code Starts

function load_product_attributes(){

$.ajax({
	
method: "POST",

url: "variable_product/load_product_attributes.php",

data: { random_id: <?php echo $random_id; ?> },

success:function(data){
	
$("table tbody").html(data);

$("table").removeClass("wait-loader");
	
}	

});
	
}

//Load Product Attributes Function Code Ends

//Insert New Product Attribute Code Starts

$("#insert_attribute_form").submit(function(event){
	
event.preventDefault();	

$("table").addClass("wait-loader");

$.ajax({
	
method: "POST",

url: "variable_product/insert_product_attribute.php",

data: $('#insert_attribute_form').serialize() + "&random_id=<?php echo $random_id; ?>",

success: function(){
	
$("#insert_attribute_form").find("input[type=text],textarea").val("");

load_product_attributes();
	
}

});

});

//Insert New Product Attribute Code Ends

//Edit Product Attribute Code Starts

$(".input-edit").hide();

$(".save-product-attribute").hide();

$(".edit-product-attribute").on('click', function(event){
	
event.preventDefault();

var attribute_id = $(this).data("attribute");
	
$(".edit").show();
	
$(".input-edit").hide();

$(".edit[data-attribute='" + attribute_id +"']").hide();

$(".input-edit[data-attribute='" + attribute_id +"']").show().focus();

$(".edit-product-attribute[data-attribute='" + attribute_id +"']").hide();

$(".save-product-attribute[data-attribute='" + attribute_id +"']").show();
	
});

//Edit Product Attribute Code Ends

//Update Save Product Attribute Code Starts

$(".save-product-attribute").on('click', function(event){
	
event.preventDefault();

var attribute_id = $(this).data("attribute");

$(".edit[data-attribute='" + attribute_id +"']").show();

$(".input-edit[data-attribute='" + attribute_id +"']").hide();

$(".edit-product-attribute[data-attribute='" + attribute_id +"']").show();

$(".save-product-attribute[data-attribute='" + attribute_id +"']").hide();
	
var attribute_name = $("#attribute-name[data-attribute='" + attribute_id +"']").val();

var attribute_values = $("#attribute-values[data-attribute='" + attribute_id +"']").val();

$("#attribute-name[data-attribute='" + attribute_id +"']").prev(".edit").text(attribute_name);

$("#attribute-values[data-attribute='" + attribute_id +"']").prev(".edit").text(attribute_values);

var random_id = <?php echo $random_id; ?>;

$.ajax({
	
method: "POST",

url: "variable_product/update_product_attribute.php",

data: { random_id: random_id, attribute_id: attribute_id, attribute_name: attribute_name, attribute_values: attribute_values } 
      
});

});

//Update Save Product Attribute Code Ends

//Delete Product Attribute Code Starts
	
$(".delete-product-attribute").on('click', function(event){
	
event.preventDefault();

var attribute_id = $(this).data("attribute");

$("#tr-attribute-" + attribute_id).remove();	
	
var random_id = <?php echo $random_id; ?>;

$.ajax({
	
method: "POST",

url: "variable_product/delete_product_attribute.php",

data: { random_id: random_id, attribute_id: attribute_id }
      
});

});

//Delete Product Attribute Code Ends

//Load Product Variations Default Form Values Function Code Starts

function load_variations_default_form_values(){

$.ajax({
	
method: "POST",

url: "variable_product/load_default_form_values.php",

data: { random_id: <?php echo $random_id; ?> },

success:function(data){
	
$("#default_form_values").html(data);

}	

});
	
}

//Load Product Variations Default Form Values Function Code Ends

//Load Product Variations Function Code Starts

function load_product_variations(){

$.ajax({
	
method: "POST",

url: "variable_product/load_product_variations.php",

data: { random_id: <?php echo $random_id; ?> },

success:function(data){
	
$(".product-variations-div").html(data);

$(".product-variations-div").removeClass("wait-loader");

}	

});
	
}

//Load Product Variations Function Code Ends

//Click Product Variations Tab Code Starts

$("a[href='#product_variations']").click(function(){
	
$(".product-variations-div").addClass("wait-loader");
	
load_variations_default_form_values();

load_product_variations();

});

//Click Product Variations Tab Code Ends

//Save Update Product Variations Function Code Starts

function save_update_product_variations(){

var form = document.getElementById("product-variations-form");

var form_data = new FormData(form);

form_data.append("random_id", <?php echo $random_id; ?>);

$.ajax({
	
method: "POST",

url: "variable_product/update_all_variations.php",

data:form_data,

contentType: false,

cache: false,

processData:false,

success: function(data){
	
$(".ajax-response-div").html(data);
	
$(".product-variations-div").removeClass("wait-loader");
	
}

});

	
}

//Save Update Product Variations Function Code Ends

//Product Variations Actions Go Button Code Starts

$("#go_button").click(function(){
	
var action_select = $("#action_select").val();

if(action_select == "add_variation"){
	
$(".product-variations-div").addClass("wait-loader");

save_update_product_variations();

$(".product-variations-div").addClass("wait-loader");
	
$.ajax({
	
method: "POST",

url: "variable_product/insert_product_variation.php",

data: { random_id: <?php echo $random_id; ?> },

success: function(){
	
load_product_variations();
	
}

});
	
}else if(action_select == "create_variations_from_attributes"){
	
var confirm_action = confirm("Are you sure you want to link all variations? This will create a new variation for each and every possible combination of variation attributes (max 50 per run).");

if(confirm_action == true){

$(".product-variations-div").addClass("wait-loader");

save_update_product_variations();

$(".product-variations-div").addClass("wait-loader");
		
$.ajax({
	
method: "POST",

url: "variable_product/create_variations_from_attributes.php",

data: { random_id: <?php echo $random_id; ?> },

success: function(data){
	
$(".ajax-response-div").html(data);
	
load_product_variations();

load_variations_default_form_values();
	
}

});

}
	
}else if(action_select == "delete_all_variations"){
	
var confirm_action = confirm("Are you sure you want to delete all variations? This cannot be undone.");

if(confirm_action == true){
	
$(".product-variations-div").addClass("wait-loader");

$.ajax({
	
method: "POST",

url: "variable_product/delete_all_variations.php",

data: { random_id: <?php echo $random_id; ?> },

success: function(){
	
load_product_variations();

load_variations_default_form_values();
	
}

});
	
}

}

});

//Product Variations Actions Go Button Code Ends

//Save Update Submit From Of Product Variations Code Starts

$("#product-variations-form").submit(function(event){

event.preventDefault();

$(".product-variations-div").addClass("wait-loader");

save_update_product_variations();

load_variations_default_form_values();
	
});

//Save Update Submit From Of Product Variations Code Ends
 
});

</script>

<?php

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

$product_title = mysqli_real_escape_string($con, $_POST['product_title']);

$product_seo_desc = mysqli_real_escape_string($con, $_POST['product_seo_desc']);

$product_url = mysqli_real_escape_string($con, $_POST['product_url']);

$product_cat = mysqli_real_escape_string($con, $_POST['product_cat']);

$cat = mysqli_real_escape_string($con, $_POST['cat']);

$manufacturer_id = mysqli_real_escape_string($con, $_POST['manufacturer']);

$product_price = mysqli_real_escape_string($con, $_POST['product_price']);

$product_desc = mysqli_real_escape_string($con, $_POST['product_desc']);

$product_keywords = mysqli_real_escape_string($con, $_POST['product_keywords']);

$psp_price = mysqli_real_escape_string($con, $_POST['psp_price']);

$product_label = mysqli_real_escape_string($con, $_POST['product_label']);

$product_type = mysqli_real_escape_string($con, $_POST['product_type']);

$product_features = mysqli_real_escape_string($con, $_POST['product_features']);

$product_video = mysqli_real_escape_string($con, $_POST['product_video']);

$product_weight = mysqli_real_escape_string($con, $_POST['product_weight']);

$stock_status = mysqli_real_escape_string($con, $_POST['stock_status']);

$enable_stock = mysqli_real_escape_string($con, $_POST['enable_stock']);

$stock_quantity = mysqli_real_escape_string($con, $_POST['stock_quantity']);

$allow_backorders = mysqli_real_escape_string($con, $_POST['allow_backorders']);

$status = "product";

$product_img1 = $_FILES['product_img1']['name'];
$product_img2 = $_FILES['product_img2']['name'];
$product_img3 = $_FILES['product_img3']['name'];

$temp_name1 = $_FILES['product_img1']['tmp_name'];
$temp_name2 = $_FILES['product_img2']['tmp_name'];
$temp_name3 = $_FILES['product_img3']['tmp_name'];

$allowed = array('jpeg','jpg','gif','png');

$product_img1_extension = pathinfo($product_img1, PATHINFO_EXTENSION);

$product_img2_extension = pathinfo($product_img2, PATHINFO_EXTENSION);

$product_img3_extension = pathinfo($product_img3, PATHINFO_EXTENSION);

if(!in_array($product_img1_extension,$allowed)){
 
echo "<script> alert('Your Product Image 1 File Extension Is Not Supported.'); </script>";

$product_img1 = "";

}else{

move_uploaded_file($temp_name1,"../admin_area/product_images/$product_img1");

}

if(!empty($product_img2)){

if(!in_array($product_img2_extension,$allowed)){
 
echo "<script> alert('Your Product Image 2 File Extension Is Not Supported.'); </script>";

$product_img2 = "";

}else{

move_uploaded_file($temp_name2,"../admin_area/product_images/$product_img2");

}

}

if(!empty($product_img3)){

if(!in_array($product_img3_extension,$allowed)){
 
echo "<script> alert('Your Product Image 3 File Extension Is Not Supported.'); </script>";

$product_img3 = "";

}else{

move_uploaded_file($temp_name3,"../admin_area/product_images/$product_img3");

}

}

$insert_product = "insert into products (vendor_id,p_cat_id,cat_id,manufacturer_id,date,product_title,product_seo_desc,product_url,product_img1,product_img2,product_img3,product_price,product_psp_price,product_desc,product_features,product_video,product_keywords,product_label,product_type,product_weight,product_vendor_status,status) values ('$customer_id','$product_cat','$cat','$manufacturer_id',NOW(),'$product_title','$product_seo_desc','$product_url','$product_img1','$product_img2','$product_img3','$product_price','$psp_price','$product_desc','$product_features','$product_video','$product_keywords','$product_label','$product_type','$product_weight','$product_vendor_status','$status')";

$run_product = mysqli_query($con,$insert_product);

$product_id = mysqli_insert_id($con); 

if($run_product){
	
if($product_type != "variable_product"){
	
if($enable_stock == "yes" and $stock_quantity > 0){

$stock_status = "instock";
	
}elseif($enable_stock == "yes" and $allow_backorders == "no" and $stock_quantity < 1){

$stock_status = "outofstock";
	
}elseif($enable_stock == "yes" and ($allow_backorders == "yes" or $allow_backorders == "notify") and $stock_quantity < 1){

$stock_status = "onbackorder";
	
}
	
$insert_product_stock = "insert into products_stock (product_id,enable_stock,stock_status,stock_quantity,allow_backorders) values ('$product_id','$enable_stock','$stock_status','$stock_quantity','$allow_backorders')";
	
$run_insert_product_stock = mysqli_query($con,$insert_product_stock);

}

$update_product_stock = "update products_stock set product_id='$product_id' where product_id='$random_id'";
	
$run_update_product_stock = mysqli_query($con,$update_product_stock);

$update_product_attributes = "update product_attributes set product_id='$product_id' where product_id='$random_id'";

$run_product_attributes = mysqli_query($con, $update_product_attributes);

$update_product_variations = "update product_variations set product_id='$product_id' where product_id='$random_id'";

$run_product_variations = mysqli_query($con, $update_product_variations);

echo "

<script>

alert(' Your Product Has Been Inserted Successfully. ');

window.open('index.php?products','_self');

</script>

";

}

}

?>