update sql table with php

Question

anojs 0 Newbie Poster

13 Years Ago

insert.php

<?php
$dbun = "$_POST[dbun]";
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$sql="INSERT INTO $dbun (sn, date, particular, dr, cr)
VALUES
('$_POST[sn]','$_POST[date]','$_POST[ptr]','$_POST[dr]','$_POST[cr]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con)
?>

DB name = my_db

user.php

<html>
<body>

<form action="db.php" method="post">
NEW DATA BASE USER: <input type="text" name="snn" />
<input type="submit" />
<br>
<form action="db.php" method="post">
DATA BASE USER NAME: <input type="text" name="dbun" />

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

</body>
</html>

db.php

<?php
$snn = "$_POST[snn]";
		
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// Create table
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE $snn
(
Sn int,
Date int,
Particular varchar(15),
Dr int,
Cr int
)";

// Execute query
mysql_query($sql,$con);

mysql_close($con);
?>

index.php

<form action="insert.php" method="post">
 
      DB User name: 
      <input type="text" name="dbun" />
      <br>
      Sn: 
      <input type="text" name="sn" />
      <br>
      Date: 
      <input type="text" name="date" />
      <br>
      Particurar: 
      <input type="text" name="ptr" />
      <br>
      Dr: 
      <input type="text" name="dr" />
      <br>
      Cr:</span>
      <input type="text" name="cr" />
       <br>
      <br>
      <input type="submit" />
      

</form>
<a href="user.php">USER</a></span>
<a href="output.php">OUT PUT</a>
</body>
</html>

My question is how to edit my sql data that already entered with html post plz help....

mysql php

2 Contributors
6 Replies
258 Views
2 Years Discussion Span
Latest Post 10 Years Ago Latest Post by dono.reseller

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

anojs 0 Newbie Poster · Answer 1 · 2010-10-03T20:54:40+00:00

sorry db.php is this

<?php
$snn = "$_POST[snn]";
		
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// Create table
mysql_select_db("my_db", $con);
$sql = CREATE TABLE $snn
(
Sn int,
Date int,
Particular varchar(15),
Dr int,
Cr int
)";

// Execute query
mysql_query($sql,$con);

mysql_close($con);
?>

anojs 0 Newbie Poster · Answer 2 · 2010-10-03T20:54:55+00:00

sorry db.php is this

<?php
$snn = "$_POST[snn]";
		
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// Create table
mysql_select_db("my_db", $con);
$sql = CREATE TABLE $snn
(
Sn int,
Date int,
Particular varchar(15),
Dr int,
Cr int
)";

// Execute query
mysql_query($sql,$con);

mysql_close($con);
?>

anojs 0 Newbie Poster · Answer 3 · 2010-10-03T20:59:52+00:00

1st new data user to creat new table in index.php

anojs 0 Newbie Poster · Answer 4 · 2010-10-03T21:00:57+00:00

and we have to enter data but how to edit that entered data

anojs 0 Newbie Poster · Answer 5 · 2010-10-03T21:03:23+00:00

sorry db.php is here

<?php
$snn = "$_POST[snn]";
		
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// Create table
mysql_select_db("my_db", $con);
$sql = CREATE TABLE $snn
(
Sn int,
Date int,
Particular varchar(15),
Dr int,
Cr int
)";

// Execute query
mysql_query($sql,$con);

mysql_close($con);
?>

dono.reseller 0 Newbie Poster · Answer 6 · 2013-07-13T02:49:22+00:00

sql please,,,
Because that php cannot use if sql nothing -_-