vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=52456

INSERT INTO database
by flup
02 May 2003 10:50

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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


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.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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.

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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.

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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 02 May 2003 11:02

Click here for SELECT FROM database tutorial

vietkieu_cz 04 Jun 2006 09:40

Could you write a tutorial about "How to Update Database" ?

Bubble #5 13 Jun 2006 02:16

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 12 Aug 2009 14:39

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 12 Aug 2009 15:56

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 13 Aug 2009 09:49

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 15:10.

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.