₦airaland Forum

Those advanced in web designing should please lend their knowledge on this topic,

First question-How to create a table in a database using phpmyadmin?

When you get into the database you want to create tables for, at the botom you will see 2 textfields for creating tables. The first one is for the table name and the second one is for the number of fields.

thanks, I have done that I created a table with 5 fields

How do I insert details into the fields?

Look at the left pane, you should see your database name and the table you have created under it. Click on the table you have created. Then go to the main display area showing the table properties and click "Insert"

I think my table has not been created, I only created the fields. et.c

After filling on what should be in the fields, I clicked go and got the error message below

Error

SQL query:

CREATE TABLE `africadi_banks`.`bankregister` (
`name of bank` VARCHAR( 60 ) NOT NULL AUTO_INCREMENT ,
`address` VARCHAR( 60 ) NOT NULL ,
`phone no` VARCHAR( 60 ) NOT NULL ,
`email address` VARCHAR( 60 ) NOT NULL ,
`website` VARCHAR( 60 ) NOT NULL ,
PRIMARY KEY ( `name of bank` , `address` , `phone no` , `email address` , `website` )
) ENGINE = MYISAM ;

MySQL said: Documentation
#1063 - Incorrect column specifier for column 'name of bank'

Ok. I have finally created my tables and inserted the values.

How do I connect to my database?

What are you connecting from?

from an online guide I was told that before I can do anything with MySQL in PHP. I must first establish a connection to my web host's MySQL database which done with the MySQL connect function.

it is like I have to make a connection from my server to my database, what should I do?

Hi, Click here for a guide

This thing is getting complicated

I entered these input below

<?php
$dbhost = 'localhost';
$dbuser = 'africadi_jmoore';
$dbpass = 'letomeocar';

$conn = mysql_connect(localhost, africadi_jmoore, letomeocar) or die ('Error connecting to mysql');

$dbname = 'africadi_banks';
mysql_select_db($dbname);
?>


AND I GOT THESE ERROR CODE BELOW

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 1
STR: <?
SQL: <?php
$dbhost = 'localhost';<?php
$dbhost = 'localhost';<?php
$dbhost = 'localhost';<?php
$dbhost = 'localhost';<?php
$dbhost = 'localhost';<?php
$dbhost = 'localhost';<?php
$dbhost = 'localhost';<?php
$dbhost = 'localhost';


SQL query:

<?php $dbhost = 'localhost';

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?php
$dbhost = 'localhost'' at line 1