vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Programming Articles (https://vborg.vbsupport.ru/forumdisplay.php?f=188)
-   -   INSERT INTO database (https://vborg.vbsupport.ru/showthread.php?t=52456)

flup 05-01-2003 10:00 PM
INSERT INTO database
 
In this tuturial a lot of mySQL and PHP will become clear to you.
This tutorial was posted on www.webmeesteres.nl and is very good for the novice (like me, i started yesterday with it, and im now getting the clue of mySQL and PHP together)

__________________________________________________ _

Start:
In this articel, i'll explain how to add text into a database.
The articel is wroten for newbies, and I think you know how to create a table in a database, though, i'm still explaining that part a bit.

The Tutorial:
To put text in a database, first of al you need a database and a tabel, we assume you already have a database, so you have to create your tabel

[sql]CREATE TABLE table (
naam VARCHAR(35) NOT NULL,
email VARCHAR(50) NOT NULL,
titel VARCHAR(30) NOT NULL,
info TEXT NOT NULL
);[/sql]

This table is called: table (woow, how did i get this ;P)
And the fields are called: naam, email, title, info (dutch)

Naam is a regular field to enter your name and may contain various characters (varchar) with 35 chars (35)
For email and titel is the same, but with info, it could be anything, this has been marked with TEXT, text hasn't got any preset length.
This code is easy to add in a database, just copy and paste the code in PHPmyAdmin

ok, second, we are going to make a form wich is called insertcode.php but that could be anything.

PHP Code:
<?php
Add text<br>
<form action="addcode.php" method="post">
Naam:<br><input type="text" name="naam" size="20" maxlength="20"><br>
E-mail:<br><input type="text" name="email" size="30"><br>
Titel:
<input type="text" name="titel" size="30"><br>
Info:<br><textarea rows="7" name="info" cols="39">
</textarea><br>
<input type="submit" name="submit" value="Add"></form>
Ok, now you've got your table we are heading to the next part of this tutorial, because, with only a form you cant add anything.
PHP Code:
<?php

if($submit) {

mysql_connect("localhost","user","paswoord");
mysql_select_db("databasenaam");

$insert = "INSERT INTO tabel (naam,email,titel,info) 
VALUES ('','$naam','$email','$titel','$info')";
$query = mysql_query($insert)or die(mysql_error());
} 
?>
To explain this part, we've to talk a bit weird, but that explains best:

If: Add
Do: Connect Database, Add content of form to database


Just a notice:

Naam:
Code:
<input type="text" name="naam" size="20" maxlength="20">
In this piece of code, it says the name of naam is naam. The content of naam will be put in the table naam.
Is doesn't mather how your form is called, only that everything is put in the right table.
PHP Code:
$query = mysql_query($insert)or die(mysql_error());
} 
In this code, it makes a mysql_query, called $insert, if it can't doe this query it will report an error.

I hope you know now a bit of the working of mySQL;)
Good Luck

flup 05-02-2003 09:02 AM
<a href="https://vborg.vbsupport.ru/showthread.php?s=&postid=390345#post390345" target="_blank">Click here for SELECT FROM database tutorial</a>

vietkieu_cz 06-04-2006 07:40 AM
Could you write a tutorial about "How to Update Database" ?

Bubble #5 06-13-2006 12:16 AM
Joshua good stuff :)

Is there anyway to display the new table data that you've made in a post on the forum? For example; someone sends the data to the table and the forum then creates a new post and displays it. Each time someone sends this data to the table the forum posts a new post. How hard would it be to do this?

Come2Daddy 08-12-2009 12:39 PM
Do we have to use the user and password to connect to the database
this is not vbulletin style of connecting to database
I've seen lots of hacks don't use the user and password

otherwise how could they publish it to share it with others boards

Lynne 08-12-2009 01:56 PM
Quote:
Originally Posted by Come2Daddy (Post 1865785)
Do we have to use the user and password to connect to the database
this is not vbulletin style of connecting to database
I've seen lots of hacks don't use the user and password

otherwise how could they publish it to share it with others boards
This article if from 2003.

No, you don't need to use a user/password to connect to the database.

ragtek 08-13-2009 07:49 AM
Also this article shouldn't be in the vb section because it isn't using vb methods


All times are GMT. The time now is 11:40 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01232 seconds
  • Memory Usage 1,741KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (3)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete