fordev22.com รับพัฒนาระบบ รับพัฒนาเว็บแอพพลิเคชั่น รับพัฒนาเว็บไซต์ รับเขียนโปรแกรม สอนทำเว็บ สอนเขียนเว็บ สอนทำเว็บ php สอนBootstrap สอนทำเว็บราคาถูก รับทำเว็บไซต์ราคาถูก โปรเจ็คจบ ทำเว็บแบบง่าย ๆ สอนทำเว็บรองรับมือถือ สอนทำเว็บรองรับทุกอุปกรณ์ สอนคอมพิวเตอร์ html php css web app sql Bootstrap Mysql XAMPP

PHP+MySqli EP.38 Code Ajax multipart insert

ระบบ ตระกร้าสินค้า แบบไม่สมัครสมาชิกสั่งซื้อได้

ระบบ ตระกร้าสินค้าแบบสมัครสมาชิก

ระบบ ตระกร้าสินค้า ADVANCE แจ้งเตือนชำระเงินผ่านไลน์

ระบบ เช่าชุดออนไลน์

ระบบ บริหารจัดการห้องพัก

Code หน้า aj_f.php

<!doctype html>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">
     <link href=" https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">

   

    <title>Hello, world!</title>
  </head>
  <body>
    <h1></h1>



    <script language="javascript">
	function CreateNewRow()
	{
		var intLine = parseInt(document.frmMain.hdnMaxLine.value);
		intLine++;
			
		var theTable = document.all.tbExp
		var newRow = theTable.insertRow(theTable.rows.length)
		newRow.id = newRow.uniqueID
		
		var item1 = 1
		var newCell
		
		//*** Column 1 ***//
		newCell = newRow.insertCell(0)
		newCell.id = newCell.uniqueID
		newCell.setAttribute("className", "css-name");
		// newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" SIZE=\"5\" NAME=\"Column1_"+intLine+"\" VALUE=\"\"></center>"
		newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" CLASS=\"form-control\" SIZE=\"5\" NAME=\"Column1["+intLine+"]\" VALUE=\"\"></center>"

		
		document.frmMain.hdnMaxLine.value = intLine;
	}
	
	function RemoveRow()
	{
		intLine = parseInt(document.frmMain.hdnMaxLine.value);
		if(parseInt(intLine) > 0)
		{
				theTable = (document.all) ? document.all.tbExp : 
				document.getElementById("tbExp")
				theTableBody = theTable.tBodies[0];
				theTableBody.deleteRow(intLine);
				intLine--;
				document.frmMain.hdnMaxLine.value = intLine;
		}	
	}	
</script>
<body>

<div class="container">
	<div class="row">
	<div class="col-md-3">
	</div>
	<div class="col-md-6">	
		<br>
		<br>
		<center><img src="logo_fordev22_2.png" width="60%" alt=""></center>
		<br>
		<form name="frmMain" method="post" action="aj_s.php">
		<table class="table table-striped" width="445" border="1" id="tbExp">

		  <tr>
		    <td><div align="center"><h3>Ajax multipart insert By fordev22</h3></div></td>
		    
		  </tr>
		 
		</table>
		<center>

		<input type="hidden"  name="hdnMaxLine" value="0">
		<div class="btn-group" role="group" aria-label="Basic mixed styles example">
		<input name="btnAdd" class="btn btn-primary btn-md" type="button" id="btnAdd" value="Add" onClick="CreateNewRow();">
		<input name="btnDel" type="button" class="btn btn-danger btn-md" id="btnDel" value="Del" onClick="RemoveRow();">
		<button type="submit" class="btn btn-secondary btn-md">Save</button>
		</div>
		</center>

		</form>
	</div>
	<div class="col-md-3">
	</div>	
	</div>
</div>
    <!-- Optional JavaScript; choose one of the two! -->

    <!-- Option 1: Bootstrap Bundle with Popper -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>

    <!-- Option 2: Separate Popper and Bootstrap JS -->
    <!--
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>
    -->
  </body>

</html>

100

101

102

103

104

105

106

107

<!doctype html>

<head>

<title>Hello, world!</title>

</head>

<body>

function CreateNewRow()

{

var intLine = parseInt(document.frmMain.hdnMaxLine.value);

intLine++;

var theTable = document.all.tbExp

var newRow = theTable.insertRow(theTable.rows.length)

newRow.id = newRow.uniqueID

var item1 = 1

var newCell

//*** Column 1 ***//

newCell = newRow.insertCell(0)

newCell.id = newCell.uniqueID

newCell.setAttribute("className", "css-name");

// newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" SIZE=\"5\" NAME=\"Column1_"+intLine+"\" VALUE=\"\"></center>"

newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" CLASS=\"form-control\" SIZE=\"5\" NAME=\"Column1["+intLine+"]\" VALUE=\"\"></center>"

document.frmMain.hdnMaxLine.value = intLine;

}

function RemoveRow()

{

intLine = parseInt(document.frmMain.hdnMaxLine.value);

if(parseInt(intLine) > 0)

{

theTable = (document.all) ? document.all.tbExp :

document.getElementById("tbExp")

theTableBody = theTable.tBodies[0];

theTableBody.deleteRow(intLine);

intLine--;

document.frmMain.hdnMaxLine.value = intLine;

}

</script>

<body>

</div>

<br>

<br>

<tr>

<td><div align="center"><h3>Ajax multipart insert By fordev22</h3></div></td>

</tr>

</table>

</div>

</center>

</form>

</div>

</div>

<!--

-->

</body>

</html>

Code หน้า aj_s.php

<?php 
echo "<pre>";
print_r($_POST);
echo "</pre>";
// foreach($_POST['Column1'] as $key => $value){
// 	// print_r($key);
// 	echo $_POST['Column1'][$key].'<br>';

// }
 exit();
	
	include('condb.php');

	foreach($_POST['Column1'] as $key => $value){
		
		$sql4	= sprintf("INSERT INTO t_aj (column1,column2,column3,column4,column5) VALUES ('%s','%s','%s','%s','%s')",
			$_POST['Column1'][$key],
			$_POST['Column2'][$key],
			$_POST['Column3'][$key],
			$_POST['Column4'][$key],
			$_POST['Column5'][$key]
			);
		$query4	= mysqli_query($con, $sql4) or die ("Error in query: $sql4 " . mysqli_error());
	}

?>

<?php

echo "<pre>";

print_r($_POST);

echo "</pre>";

// foreach($_POST['Column1'] as $key => $value){

// // print_r($key);

// echo $_POST['Column1'][$key].'<br>';

// }

exit();

include('condb.php');

foreach($_POST['Column1'] as $key => $value){

$sql4 = sprintf("INSERT INTO t_aj (column1,column2,column3,column4,column5) VALUES ('%s','%s','%s','%s','%s')",

$_POST['Column1'][$key],

$_POST['Column2'][$key],

$_POST['Column3'][$key],

$_POST['Column4'][$key],

$_POST['Column5'][$key]

);

$query4 = mysqli_query($con, $sql4) or die ("Error in query: $sql4 " . mysqli_error());

}

con_db.php

<?php
$con= mysqli_connect("localhost","root","","ชื่อDatabase") or die("Error: " . mysqli_error($con));
mysqli_query($con, "SET NAMES 'utf8' ");
error_reporting( error_reporting() & ~E_NOTICE );
date_default_timezone_set('Asia/Bangkok');
?>

<?php

$con= mysqli_connect("localhost","root","","ชื่อDatabase") or die("Error: " . mysqli_error($con));

mysqli_query($con, "SET NAMES 'utf8' ");

error_reporting( error_reporting() & ~E_NOTICE );

date_default_timezone_set('Asia/Bangkok');

sql

-- phpMyAdmin SQL Dump
-- version --
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 30, 2022 at 11:10 AM
-- Server version: 10.4.14-MariaDB
-- PHP Version: 7.4.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `food_db`
--

-- --------------------------------------------------------

--
-- Table structure for table `t_aj`
--

CREATE TABLE `t_aj` (
  `pk` int(11) NOT NULL,
  `Column1` text DEFAULT NULL,
  `Column2` text DEFAULT NULL,
  `Column3` text DEFAULT NULL,
  `Column4` text DEFAULT NULL,
  `Column5` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `t_aj`
--

INSERT INTO `t_aj` (`pk`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES
(3, 'fordev22', '', '', '', ''),
(4, 'fordev22', '', '', '', ''),
(5, 'fordev22', '', '', '', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `t_aj`
--
ALTER TABLE `t_aj`
  ADD PRIMARY KEY (`pk`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `t_aj`
--
ALTER TABLE `t_aj`
  MODIFY `pk` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

-- phpMyAdmin SQL Dump

-- version --

-- https://www.phpmyadmin.net/

-- Host: 127.0.0.1

-- Generation Time: Jun 30, 2022 at 11:10 AM

-- Server version: 10.4.14-MariaDB

-- PHP Version: 7.4.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

START TRANSACTION;

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;

-- Database: `food_db`

-- --------------------------------------------------------

-- Table structure for table `t_aj`

CREATE TABLE `t_aj` (

`pk` int(11) NOT NULL,

`Column1` text DEFAULT NULL,

`Column2` text DEFAULT NULL,

`Column3` text DEFAULT NULL,

`Column4` text DEFAULT NULL,

`Column5` text DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table `t_aj`

INSERT INTO `t_aj` (`pk`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES

(3, 'fordev22', '', '', '', ''),

(4, 'fordev22', '', '', '', ''),

(5, 'fordev22', '', '', '', '');

-- Indexes for dumped tables

-- Indexes for table `t_aj`

ALTER TABLE `t_aj`

ADD PRIMARY KEY (`pk`);

-- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table `t_aj`

ALTER TABLE `t_aj`

MODIFY `pk` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

ระบบ ตระกร้าสินค้า แบบไม่สมัครสมาชิกสั่งซื้อได้

ระบบ ตระกร้าสินค้าแบบสมัครสมาชิก

ระบบ ตระกร้าสินค้า ADVANCE แจ้งเตือนชำระเงินผ่านไลน์

ระบบ เช่าชุดออนไลน์

ระบบ บริหารจัดการห้องพัก

You might also like