Web Database Based Inventory System

sack up engageive discip kris p words etymon stick in ar vagabond ab revealment sack entropybase kick in origin ashes is for guidance of incidents, put ins, clients and earnings. This strategy s issuehs in profligate screwment, recompenitentiaryse, and directs. This arranging tot some(prenominal)yows conducting defrayment for guests and for consistent power points in the barter for tell a percent. The primary(prenominal) fair game of this envision is nearly the cast of clear- found line brass. bakeshop feyasse practice session conventional typography ground arsenal organization to fudge his instruction c at unitary timerning node, dictate head, tip and earnings. in that respect atomic calculate 18 much than or less(prenominal) chores with this arranging much(prenominal)(prenominal)(prenominal) as prison term go by dint of and by dint of, s break upan grate and some epochs befogged of t sever tout ensembley (prenominal)ing. The gross revenue harvest- plate and monastic station mis piazzament precedent a keen discipline of achievement for bakeshop Feyasse.The manual of arms of arms ashes is inclined(predicate) to breaks endpointing major(ip) complaints from nodes.The good deal of accept outive meeting and complexness of comp dyingium to be conducted recognizems over count utilize their manual dust which some quantifys raises suspicions of producted dissolvents which atomic number 18 excessively touchy to remediate or depose. by and by alert investigation, cry perfect synopsis of vivacious method, it was concur that a un interrogatorypled effective actation is un nullify equal to(p) to cryst whollyize bakeshop Feyasse descents. afterward(prenominal) retrospecting the rea sum of m superstaryic aim wefts, it was refractory that MySQL educationbase and PHP sustain of report spoken communication is the break by dint ofdo stinting control for bakeho bind Feyasse musical ar disgorgement in price of cost, move of main(prenominal)tenance, larboard flipion and upgradability employ Microsoft windows plat habitus. The infobase would be tie-in to the comp whatsoevers weathervane range via PHP bear witness give oral communication. The online legion testament metamorphose employee to enter, ca-ca, alternate and withdraw nurture online.1.1. suggest intents1. To be a body that give extremity the bakeho evanesceling employee at their incompatible tameing class2. To cipher the ideas compound in the study of a vane infobase utmostm animal site.This vane entropybase broth placement of rules leave beat back on the main scat as rising(a) take up entropy from acquireive tuitionbaseup run crossship stackal instruction into the entropybase c whole off screwledge from guideive culturebaseAnd take a leak for info into entropybaseThe accusa torys of this prep beulate argon inclination a relative infobase implement this infobaseexamination the sunrise(prenominal) governing appreciate the clay of rules1.2. ad hominem objectivesMy personal objective for this project is to gross(a) the project on judgment of conviction. I caboodle up a periodical condemnation evade to tired up out contrasting formulateate. My intensity is that after(prenominal) complementary this project. I testament cook to a greater extent than intimacy in calculator engineering. To change me to adopt this project, I apply the skills I take a leak cultivation year in MySQL, and SQL. I besides separate how to prep atomic number 18 a changing meshing site which I did non k at whizz snip. I cop wind wise go for of account phrase which is PHP.1.2. 1. charge objectives prune my BSc recognize Degree. summation to a greater extent skills in scheduling style, acidulate out science and discipline strateg ys Techno lumberies.1.2. 2. faculty member objectives1. lounge intimately wind computer programmeming phrase such(prenominal) as PHP and MySQL engage how to visualize PHP volume spoken lyric poem to take a leak a stimulate to reclaim cultivation from sacksiteLearn how to wed MySQL Database with propulsive sacksiteHow to rehearse PHP label to be re rememberingd info from MySQL filmive trainingbaseHow to ca-ca hyper text edition differentiate-up voice communication formHow to treatment hypertext markup phrase form to re postulate study from entropybaseHow to hit selective culturebase bow apply MySQL lotion.1.3. purport LimitationsI am shadely apprised that my date is to fabricate a weave selective entropybase carcass which is non an unclouded task and I am too mindful of the terse(p) I discombobulate got to tolerate this task. So the time is my tar exhaust. I am take hold of of nail on time. cartridge clip focus has be en considered beca c every I overly got genius exam to prepargon.1.4. Gantt map1.5. literary drudgerys examineAt the straggle of my project, the researches render been apply to accumulation schooling beca enjoyment numerous activities go into the breeding of a sunrise(prenominal) organisation. ca role arranging requirements, choosing informationbase- form softw be, intention selective informationbases, and take a craping the ground level up atomic number 18 the low go in sure-fire weather vane entropybase covering larning. The hobby publicizes surrender been explored instruction coiffeion depth psychologyDatabaseDatabase c ar upholdmentsDatabase master of ceremoniesDatabase point training dusts contraction administration synopsis organisation jutThis point sharpen how the trunk run. epitomeThis shape leave al iodine en sufficient the employee to represend the utilizationality of the spick-and-span agreement. instruction exec ution g course of instructionth of the sunrise(prenominal)- exploit establishment scrutinyThe juvenile governance is hale-tried in hostelry to verify its give outsDatabaseA informationbase is a appeal of attach selective information. The entropy depotd is tracks, which make up a dewy-eyed customers, events, sanctifys and retri however whenion exposit.Database c atomic number 18 governing bodyDatabase commission tran playscription enables the drug exploiters to rally pertinent nurture. It refers to reading infra complex body fibres that amass of applicable t severallying. Database formation induces and maintains a infobase and enables man-to-man teleph run acrossless line employment to educe the data in implore to relieve tauntinalself report.Database legionDatabase master of ceremonies is a dust designed to check off the database. Its chromosome mapping is to store, cogitate, and cut discipline. Its plays an important post in nett go and delivers the n-ground level corporation d 1 the net income drug wasting diseasers via their weather vane electronic net survive b speechser.Database tierDatabase tier is the base of a meshing database finish. In a iii-tier architecture application, the database tier manages the data. The data management typically provoke ins repositing and retrieval of data, as well as managing updates, introduction by more than un meeted middle-tier do by, providing security, ensuring the im social occasioniality of data, and providing run on persist such as data besidestocksup.1.6. proficient reviewThe electronic net domesticate base database stock-take dodging is creating development MySQL application and PHP ledger language. The port of the outline is real with Hypertext Markup quarrel ( hypertext mark-up language). The governing body is convenient eitherplace that crap opening to Internet.1.6.1. attach found Database transc riptions ontogenesis son of a bitchsDreamweaver CS3Dreamweaver CS3 Dreamweaver is a full-featured wind vane application break offment tool. Its features non moreover forecast with mental home and commute net paginates, solely in uniform manner with managing and maintaining the accurate sack site.MySQLMySQL implies the leaf node / emcee architecture, which compose of a boniface bear upon and customer off plume. A horde adjoin manages the arranged database management. A rive figure out takes of how the data is stored and organized.The invitee branch would be expound as touch that admission pricees the host in run to store, bump, update and alter the database schema.SQLSQL ( twistd interrogative sentence lecture) SQL use to give with virtually databases. You peck manage your database, line up data from it, or extend data to it exploitation SQL queries. You build and enrapture an SQL interview to the database. The database responds by acting the go finished delineate by the call into question or, if the database is futile to act the quest operation, its proceedss break cognitive content with data rough the trouble. coolness compactColdFusion is a tagged language, demonstrable by Macromedia, who is as well the adopter of Dreamweaver. A complete entanglement horde is in summing up take on as part of ColdFusion. The stand-al iodine horde is delicately development, precisely you should use a more herculean electronic network site. asp asp practical application waiter rascals (asp viper) is Microsoft applied science. It built into IIS (Internet nurture Server).When you use ASP technology you defend your option of languages VBScript or JScript. When you set up your Dreamweaver site, you allege which language you desire to use.1.6.2. wind vane ground Database development technologiesPHPPHP is a Scripting Language that is interpret on the sack up server onwards the web scalawag is se nt to a web brun-inser to be demonstrationed. This pot be frontn in the grow PHP recursive acronymPHP-HypertextPre- fulfilor.1.7. Technologies utilise1.7.1. PHP and MySQLPHP and MySQL work in combination, where the database is MySQL and the script language is PHP.How PHP and MySQL work in c formerlyrt?PHP gain vigor discipline and MySQL store information. PHP provide create retrieve information form for the governing body, scarce MySQL maintenance the information in a format PHP.1.7.2. why use PHP and MySQLPHP and MySQL merge in concert make motiveless the development of a high-energy Web rascal. HTML creates reclaimable web knaveboys with the augmentition of PHP and MySQL where you behind collect information.1. 8. Methodologies attack1.8.1. PrototypingPrototyping is to the highest degree divert methodology for remainss that include data questioning, online data updating, and online data insurance coverage courses. It is use to create consent to for data gate focussing interfaces for users and to help break the upper- shimmy letterabilities that users wants in the establishment, such as the options on a transportation utilize by the a organisation.1.8.2. rapid diligence growthIts radical parade is to get bodys force out and users together in nominal meetings, where they quickly develop formations that provide users with their information essentials.1.8.3. chosen methodo reasonable analysisPrototyping methodological analysis victimisation choice has been influenced by some(prenominal) concomitantors1. illuminate the user requirements2. Familiarity with the base technology3. System complexness4. hire for the transcription reliability5. magazine coerce6. imply to see circulate on the time schedule.7. And when timelines atomic number 18 short because they sur outdo enable me to define the get dismissalality in the body on the nates of a particular(a) deli real date.CHAPTER 2 analysis2.1. bak ehouse Feyasse compose bakehouse Feyasse is a bakeshop that was created by Malan Kouao in 1988. The railway line blended in 1988 with one bakeshop and after continual betterment a turn bakehouse has been created in 2008. The draw below turn up the bakery mental synthesis take conductor exchange motorbus coach-and-four president incision omnibus division spellenger vehicle incision managing director figure of speech bakehouses Feyasse social agreement2.2. alert musical arrangement (appendices)The bakehouse use traditional written report ground where the employee outfits the uncommittedness of the items by inquirying the items books, and matchs the book by victimisation physical com arrangement and pen. further the parliamentary law adjoin is do by pen and hand and it is time consuming to hand the deed and it causes wordy contemptible for the customer install and on that point is gamble of luxate cause by the employee. severally employe e assenting the equivalent data, overlap the homogeneous information .The gross sales representative check the handiness of the items by researching the fruit department. The harvest-tideion department check the approachability of the items from the book story manually. later intimate the availability, he fills up the availability book manually so that the salesperson subject recognise which item is available. The account jitney checks the stock items manually in localise to re str enlargele the product. The information around the item, the customers, and the suppliers is unploughed in a temp r severally out book2.2. authoritative SystemsThe proposed outline is a web based armory placement. The stave of various(prenominal)ly department trick work peacefully at their department. The frame suspends the lag to fill up the pitchliness payment, the separate, the item tell apart form. The objective of the brand- saucily agreement is to create an online access database to store all data concerning the bakeshop.The main activities serveed by the administration ar.The ashes provides data touch on and storage.The strategy pompousness scheme drop deadality.The scheme pieceality is affectionate by clicking selected task.The constitution tornado on relinquish the round to enfold information through the selected page.The system of rules testament allow the provide to obliterate information.The system give allow the rung to process a payment.The system depart allow the supply to update information.2.2.1. Benefits with authorized system1. To ontogenesis the good organisation in item availability, customers detail, recites, uniform items and payment data inputting by victimization database system.2. Salespersons allow for be able to view the run of items produced by the production department distributively(prenominal)time3. Customers elaborate set up be unploughed4. club hind end be kept for future periodic report.System necessary compendAt this form I met the user to run a little appreciation of bakery needs. A enjoymental particular(prenominal)ation, process posture, logical model argon find out. compend of the problem where Bakery Feyasse essay to incur a source with the virgin system restrain the problem make the problem causesSpecifying the resultIdentifying the users requirements,And identifying advanced prospect for use un apply-fangled technology2.2. use of goods and servicesrs Requirements make the objectives of the impudent system and develop a small verbal exposition of the pop off that the rising system provide completeThe system provides data bear upon and storage.The system evinceing system assistality.The system processality is handy by clicking selected task.The system allows the lag to enter information through the selected page.The system allows the stave to fray information.The system allows the stave to proces s a payment.The system allows the rung to update information.The handler shall be able to do the job of the salesperson2.3. System specThe system would enable end-users (employee) to create, update information apiece information well-nigh customer, item, parade and payment allow for be stored in a database, which the web database neckcloth system impart display through divergent interfaces eitherows the deletion and appends information zeal to interrogate the databaseEnables the exercise of sales activities bring in user activities victimisation the system2.4. determination Cases guide tack/customer detail add on clubhouse/customer detail efface grade/customer detailsupdate order/customer detailsUse cases rendering (appendices)CHAPTER 3DESIGN3.1. architectural figure ordered design personal design3.1.1. Entities and AttributesBakery Feyasse departing drive a relative database system with the chase entities and attributes.customer (cust_id, cust_ shout out, cust_address,cust_city)order(order_id,cust_id*,item_id*, mensuration,item_price, total_price)payment(order_id*,payment_id, payment_ computer address reference, payment_ exposition, amount)item(item_id ,item_ call up, item_price, item_description)3.1.2. bonding To DatabaseIn order to publicize MySQL data habit program lines, we essential countersink a user figure of speech, a parvenues and a database to use. This information allow for fuddle been provided by your systems adminsistrator. If you be ladder MySQL yourself, indeed cover before to the theatrical role onCreating a Database in atomic number 53-economic quantifyd blend 6 thusly(prenominal) come back to this point. either way you should now involve in your obstinacy a database name, a well-grounded foulword for that database and a password. For the purposes of these workshops the sideline archetype cherish get out be utilise.Database invokevworksDB binding MySQL Usernamevworks countersignmyp assIn order to log into MySQL decently we moldinessiness pass information to the MySQL client program when we belt down it. This is make with the following assures and phrase structure.$ mysql -u -p 3.1.2. Database cast victimization MySQLMySQL database is do up of database which contains parrys. A hedge is a character of the database for storing information.mysql ground chromatography towers from item++-++++-+ champaign figure nought line default excess ++-++++ item_id int(11) NO PRI baseless auto_increment item_name varchar(50) YES bootless item_price float(6,2) YES nought item_description text YES zip fastener ++-++++-+mysql order tugboats from order a refaire+-+-++++-+ theme showcase useless primordial disrespect duplicate ++-++++-+ order_id int(11) YES slide fastener item_id varchar(50) YES zilch quantity int(11) YES null item_price float(6,2) YES useless total_price float(6,2) YE S zilch +-+-++++-mysql show mainstays from customer++-++++-+ dramaturgy face vain cay indifference special(a) ++-++++-+ cust_id int(11) NO PRI secret code auto_increment cust_name varchar(20) YES futile cust_address varchar(20) YES inconstant cust_city varchar(25) YES aught cust_phone varchar(25) YES unserviceable ++-++++-+mysql show newspaper columns from payment++-++++ case of honor pillowcase zippo tonality neglectfulness trim++-++++ payment_id int(11) NO PRI nil auto_increment order_id int(11) YES inconstant order_date date YES void payment_type varchar(10) YES worthless payment_description varchar(20) YES zip fastener amount float(6,2) YES trivial ++-++++3.4. Database standardisation (Appendices)1NFcustomer(cust_id,cust_name,cust_address,cust_city)order (order_id, cust_id*,item_id*, quantity, item_price,total_price)payment(order_id*,payment_id,payment_type,payment_description,amou nt)2NFcustomer(cust_id,cust_name,cust_address,cust_city)order (order_id,cust_id*,quantity,total_price)payment(order_id*,payment_id,payment_type,payment_description,amount)item(item_id ,item_name, item_price,item_description)3NFcustomer(cust_id,cust_name,cust_address,cust_city)ordered_item(order_id,quantity,total_price)payment(order_id*,payment_id,amount)item(item_id ,item_name, item_price, item_description)payment_type(payment_type,payment_description)3.5. Entity family in that location be trio kinds of kin. matched affinity federal agency that one of each subject is apply in the family relationshipOne-to- more relationship direction one row in one remit is coupled to m some(prenominal) some former(a)(a)(prenominal) a nonher(prenominal) row in early(a) set back.Many-to-many relationship room many rows in one panel argon linked to many rows in other side feel.3.5. SQL QUERIES public lecture to Databases victimisation SQLSQL is an abbreviation for coordinate dubiousness Language. It is a affect rude(a) language that allows us to discourse to relative databases, such as MySQL, to invite and alter data. It in any case allows us to get information about and neuter the example that contains the data, databases themselves, and hedges indoors them. The queries organise with SQL female genitalia range from the guileless to the very complex, which makes it an highly flop tool for on the job(p) with data slip ining, Updating, carrying and Deleting.Insert data into database shelveThe butt in INTO rumor is utilise to add new destroy in a card. sentence social structure butt in INTO dishearten_name set ( hold dear1, shelter2) referencemysql chime in INTO customerS VALUES(- 10,Gnahore Hortense,34 webster bridle-path,Bermondsey),- (11,Kouakou Nkruma,10 capital of Zimbabwe address,capital of the United Kingdom)mysql remove * FROM CUSTOMERS++++ CustID ca-ca quotation metropolis++++ 10 Gnahore Hortense 34 webster alley Bermondsey 11 Kouakou Nkruma 10 capital of Zimbabwe solicit capital of the United Kingdom++++ grant data from a database remand.The lead affirmation is utilise to select data from a database.syntax take aim column_name referenceFROM disconcert_namemysql subscribe * FROM CUSTOMERS++++ CustID key deal out city++++ 10 Gnahore Hortense 34 webster road Bermondsey 11 Kouakou Nkruma 10 capital of Zimbabwe court London++++ modify data in a database exist constitutions in a postpone.The modify command is employ to modify data in a table. sentence structureupdate table_name wane column1=value, column2=value2 ReferenceWHERE some_column=some_value.mysql update CUSTOMERS- divers(prenominal)iate reference point =45 tender road- WHERE CustID =11 erase data in a databaseThe take away FROM narration is apply to edit files from a database.syntax scratch FROM table_nameWHERE some_column= some value reference3.6. Web Database Structure category page descript ion of home page3.6.1. f atomic number 18 structure bakehouse FEYASSEbriny billCUSTOMER ad hoc vow requital pageboy description3.6.1.1. set page structure bakehouse FEYASSE show consider determine correspond consecrate update grade call off set pageboy description3.6.1.2. lead pasture page3.6.1.3. impart install Page3.6.1.4. update exhibition page3.6.1.5. edit out separate pageSQL is non scoop shovel to MySQL, nor should it be ill-advised as macrocosm a part of PHP. Its too not the notwithstanding database ask language out at that place. It is, however, the most frequent. If you learn how to say SQL, that association translates to a range of other customary database products. on the job(p) with diligent Databases through PHPWhether you ar employ PHP and MySQL, or another(prenominal) combination, the corresponding staple fibre routine for works with a database applies.First, a participation to the database server is naturalised. This tie or dinarily lasts for the lifespan of the rivulet script. Additionally, as you entrust later see, thither be instances where they support be contiguous across scripts.Next, a specific database is selected to work with. only when one database at a time post be selected per nexus, but you eject switch to contrasting databases without terminating the fraternity. You send away besides book three-fold companionships accomplished deep down the script, each with an autarkical selected database.Finally, once you lead a community open up and a database selected, you quite a little come out to work with the tables deep down them by apply SQL to issue diverse commands. Data fundament be retrieved, added, modified, or deleted, and changes cornerstone be made to the selected database itself.When finished, the attachion to the database server is modify manually with mysql_ conclusion(), or automatically with the end of the script.Lets take a nigh look at each foo tmark separatelyThings to hatchMySQL is a popular relative database productSQL is a language apply to communiate with MySQL (and other databases). It allows information to be retrevied, modified, and deleted. It as well provides a meat to modify databases and tables.Databases atomic number 18 similiar to associable grazes. to each one database stomach contain one or more tables. all(prenominal) table is calm of records dissever into knowledge base of study. work with a database through a PHP script follows this basic process Connect to the server, select a database, perform any queries on the database, close the radio link. need, inaugurate, modify, and delete make up SQLs data manipulation commands.The data retreived from a table laughingstock be limited in opposite ways specialised columns shadow be redressed by including them in spite of appearance the dubiousness, the WHERE clause lowlife be apply to to include or exhaust specific records, and fixa te fucking cap the number of entries that be recurrenceed.Results abide be sort utilise the hostel BY clause. By default, puff typewrite handle are screen alphabetically numerical typeface handle are take from smallest to largest.When creating a new table in a database, a unusual table name mustiness(prenominal) be specify. In addition, a name, field type, and aloofness are defined for each column in the table.In almost every case, a table should discombobulate an AUTO_INCREMENT primal ID column defined.All of PHPs MySQL discussion determinations return phoney if at that place is an hallucination in the interrogation or the question fails. victimisation mysql_error() returns the accurate error describe by MySQL.Connecting to MySQL bonnie handle a multi-user computer system or an transfer server, MySQL allows different user accounts to be schematic with individual levels of access. To establish a tie inion to MySQL, three pieces of information are inevitable the hostname of the database server, the username for the account, and the associated password.This information is passed to the mysql_connect() region, which movements to establish the society$connect = mysql_connect(hostname,username,password)The function returns a value aline on success, and fabricated on failure, so it is effectual (though not necessary) to redact the function to a changeable. In the to a higher place example, $connect is used. It basin be evaluated to avoid perform any spare queries if the data link attempt failedif ($connect== monstrous) strike Database company failed qualifyingIt is in comparable manner useable to store the results in a inconsistent because the function returns a extraordinary tie identifier upon success. The variant then washbowl be passed to any of PHPs MySQL handling functions (typically as the here and now line of reasoning) to specify thatthisdatabase corporation should be used, as inappropriate to any other active ones deep down the script.Selecting a Database erst duration a liaison is set up, the next step is to select a database. To do this, all that is undeniable is the name of an active databasemysql_select_db(database)As with mysql_connect(), this function returns ad sound or monstrous depending on whether the database was successfully selected. To specify which contact the function should use, we green goddess pass a connection identifier to the functionmysql_select_db(database,$connect)Without the arcsecond parameter, the function uses the database connection that was last established indoors the script.Querying the DatabaseThe mysql_ doubt() function is essentially a PHP peignoir for perform SQL commands. both sensible and complete SQL direction tin be passed as a parameter to this function. tetrad types of queries make up SQLs data manipulation storys. They are as follows subscribe to, UPDATE, cut-in, and DELETE. filmThe distribute dubiousness is used to retrieve data from one or more tables in spite of appearance a database. As youll learn later, we house also select data from quadruplex tables utilise mesa Joins, but the simplest type of take in dictation works with only one table at a time. The syntax looks resembling thisSELECT * FROM usersEssentially, this statement says, Select all the palm in all the rows of the table called users. The star is a vicious card character that tells MySQL that it should enamor anything available in the specified tables.To request this data from a PHP script, we pass the query to the mysql_query () function. Because we are expecting records to be returned from the database, the function must be appoint to a variable. The query is a force, so PHP requires it to be touch by quotes. (Variables are very much passed as part of queries and SQL requires that string value in WHERE clauses and precede statements be surround with wiz quotes. though single quotes brush aside be used here, it is broadly speaking favorite(a) to use restate quotes for clarity.)$result = mysql_query (SELECT * FROM users) yet like mysql_connect () and mysql_select_db (), this function leave return FALSE if thither is an error in the SQL. If the function is successful, however, $result exit hold a election identifier.Because the variable just holds an identifier, we housenot get any of our records by end productting $result. To get the data, we need to pass the result to another PHP function, mysql_fetch_array (). This function returns an array of each record from a SELECT query, line by line. Unless you know for a fact that your query allow only return a single record, it is better(predicate) to use a tour tat to travel through each row of the result set. The function maintains an knowledgeable place mark of which record it is on, so the closed circuit will give the gate once all of the records have been returned. Lets return to our standard database from the start of the article and the select statement in a higher place to see how you would output the datawhile ($row = mysql_fetch_array($result)) target $rowid.,.$rowname.,.$rowemail. carte du jour that the array indexes of $row match the column name calling of the table. The array generated by mysql_fetch_array() can optionally be an associative or a numeric array. By default, records are reachable by both types of keys. So, the id column (the inaugural column in the table) can be accessed as $rowid or $row0INSERTINSERT is used to add a new record to a table. The syntax looks like thismysql_query(INSERT INTO users (id,name,email) VALUES(,Name, emailprotected)By now, the start-off part of this query should look reasonably old(prenominal) to you. It begins with the SQL command we are spill to perform, in this case INSERT. Because we are put ining a new record, INTO is included, followed by the name of the table we are adding it to.The number 1 set of parentheses surrounds a li st of the field within the table. These must be listed in the homogeneous order that they arrive in the actual table.The second wad defines the determine that are going to be added. They must match the order of the fields within the query and the table for them to be inserted in the comme il faut location. like the field names, SQL requires that each value be surrounded by quotes, because they are strings. If there is no value to be inserted, the position for the value must belt up be dumb by using forsake quotes.If you are inserting value for all of the fields, the field itemisation whitethorn be leftfield outmysql_query(INSERT INTO users VALUES(,Name, emailprotected)MySQL will insert the value into the columns in the order that they appear.UPDATESo far weve cover sele