Jump to content

form for inserting db info?


derrick1123

Recommended Posts

<?php
$db_host = $_POST['db_host'];
$db_user = $_POST['db_user'];
$db_password = $_POST['db_pass'];
$db_name = $_POST['db_name'];

//database info

$db = mysql_connect($db_host,$db_user,$db_password) or die("Could not connect.");

if(!$db) 

die("no db");

if(!mysql_select_db($db_name,$db))

	die("No database selected.");

//end database info
?>

 

I have the other file that inserts the data...but I don't know to keep the information there. How is this possible?

Link to comment
https://forums.phpfreaks.com/topic/96439-form-for-inserting-db-info/
Share on other sites

A simple example....

 

<?php

  // connect to db.

  if (isset($_POST['submit'])) {
    $data = mysql_real_escape_string($_POST['data']);
    $sql = "INSERT INTO tbl (data) VALUES ('$data')";
    if (mysql_query($sql)) {
      if (mysql_affected_rows()) {
        echo "Data added to the database";
      }
    }
  }

?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.