Premium Essay

Php My Sql

In: Computers and Technology

Submitted By Gahoola
Words 999
Pages 4
phpMyAdmin www.phpmyadmin.net phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

Loading phpMyAdmin * Start the XAMPP Control Panel and start Apache and MySQL * Open your browser (Firefox or chrome) and type http://localhost/ * You may have to choose your language * On the left click phpMyAdmin under the Tools section * The direct path is: http://localhost/phpmyadmin
Using mySQL
Task- Create a database and a table to store employee data 1- Create the Database * Click the Databases tab at the top and type the name of a new database. (webapps) * Do not enter any collation.
(Collation refers to the character set used to store data in text fields and is necessary to provide support for all of the many written languages of the world. MySQL 4.1 added the ability to override the default system collation at the database, table, and field level.
The default collation in MySQL, latin1_swedish_ci, works fine for English because English contains no special characters such as accents. phpMyAdmin allows you to edit the collations of your database, tables, and fields if you desire to support languages other than or in addition to English.) 2- Create a table with fields (data types) * Click on the webapps database on the left * Enter the table name and number of columns – employees, 6 * Click Go * Enter the field information below:

Name Type(Length) Index id varchar(5) Primary firstname varchar(20) lastname varchar(30) age int
position

Similar Documents

Free Essay

Hmrc Confirms Reporting Obligations for Recruiters

...“Manager” and (“asses” or “Assessor” or “assessment”) and (“refer” or “referral” or “referring”) and (“Learning disabilities” or “LD” or “mental health” or “learning disability”) and (NVQ4 or “NVQ 4” or “NVQ level 4” or “NVQ IV” or NVQ3 or “NVQ 3” or “NVQ level 3” or “NVQ III” or QCF4 or “QCF 4” or “QCF level 4” or “QCF IV” or QCF3 or “QCF 3” or “QCF level 3” or “QCF III” or “Registered manager award” or RMA) and (care or “social care” or “health care” or “home care” or “care home” or “residential care”) (“referral manager” or “assessment manager” or “referral and assessment manager” or “referral and assessment manager”) and (“Learning disabilities” or “LD” or “mental health” or “learning disability”) and (NVQ4 or “NVQ 4” or “NVQ level 4” or “NVQ IV” or NVQ3 or “NVQ 3” or “NVQ level 3” or “NVQ III” or QCF4 or “QCF 4” or “QCF level 4” or “QCF IV” or QCF3 or “QCF 3” or “QCF level 3” or “QCF III” or “Registered manager award” or RMA) (“care manager” or “home manager” or “registered manager” or “branch manager” or “home care manager” or “service manager” or “domiciliary manager” or “dom manager”) and (domiciliary or “dom care” or “homecare” or “home care” or “care agency” or “community care”) and (NVQ4 or “NVQ 4” or “NVQ level 4” or “NVQ IV” or NVQ5 or “NVQ 5” or “NVQ level 5” or “NVQ V” or QCF4 or “QCF 4” or “QCF level 4” or “QCF IV” or QCF5 or “QCF 5” or “QCF level 5” or “QCF V” or “Registered manager award” or RMA) (“live in carer” or “live in manager” or “live-in manager”...

Words: 2489 - Pages: 10

Free Essay

Haha

...Chapter 1 THE PROBLEM AND ITS BACKGROUND Introduction Now a day, computer is one of the technologies that most people use in their everyday lives. The use of computer is one of the fastest growing and most important developments in our time. People used computers to give easiest and fastest method of finding information. Most students used computers to their research work, assignments, projects, thesis and it is most effective technology because it gives us more knowledge and we can learn something from it. Computers are just known as a piece of equipment where awesome package of glass, plastic, metal and wires- use to make our work easier. It is one way to achieve changes, which we can create different things through using its features. Computers have actually transformed our lives- how we communicate, how we could work and learn things and even how we play. Computers are efficient tools in processing data into useful information. They are essential tools in almost every field of research and applied technologies because of their capabilities. And because of the widespread use and availability of computers, it is essential that everyone acquires an understanding to be ignorant of the important role of computers in any career or business of choice. Being computer literate it can give anyone great competitive advantages. One example of technology is internet, widely used for everyone and popular. Everything can be known in the internet. It is an international network...

Words: 7189 - Pages: 29

Premium Essay

Mehehe

...Chapter 1 THE PROBLEM AND ITS BACKGROUND Introduction Now a day, computer is one of the technologies that most people use in their everyday lives. The use of computer is one of the fastest growing and most important developments in our time. People used computers to give easiest and fastest method of finding information. Most students used computers to their research work, assignments, projects, thesis and it is most effective technology because it gives us more knowledge and we can learn something from it. Computers are just known as a piece of equipment where awesome package of glass, plastic, metal and wires- use to make our work easier. It is one way to achieve changes, which we can create different things through using its features. Computers have actually transformed our lives- how we communicate, how we could work and learn things and even how we play. Computers are efficient tools in processing data into useful information. They are essential tools in almost every field of research and applied technologies because of their capabilities. And because of the widespread use and availability of computers, it is essential that everyone acquires an understanding to be ignorant of the important role of computers in any career or business of choice. Being computer literate it can give anyone great competitive advantages. One example of technology is internet, widely used for everyone and popular. Everything can be known in the internet. It is an international network...

Words: 7189 - Pages: 29

Free Essay

Php How to Use

...Creating dynamic Web sites with PHP and MySQL How to serve database content on the fly Skill Level: Intermediate Md. Ashraful Anam (russell@bangla.net) Web developer ##### 15 May 2001 This tutorial shows you how to create a dynamic Web site using PHP and MySQL. You learn how dynamic sites work and how they serve the content. After reading this tutorial, you will be ready to serve your own dynamic content from your own site. Section 1. Before you start About this tutorial This tutorial shows you how to use two open source, cross-platform tools for creating a dynamic Web site: PHP and MySQL. Prerequisites This tutorial is targeted to developers who are new to PHP and MySQL, and it has no prerequisites. Section 2. Introduction and installation Creating dynamic Web sites with PHP and MySQL © Copyright IBM Corporation 2001. All rights reserved. Trademarks Page 1 of 20 developerWorks® ibm.com/developerWorks The need for dynamic content The Web is no longer static; it's dynamic. As the information content of the Web grows, so does the need to make Web sites more dynamic. Think of an e-shop that has 1,000 products. The owner has to create 1,000 Web pages (one for each product), and whenever anything changes, the owner has to change all those pages. Ouch! Wouldn't it be easier to have only one page that created and served the content on the fly from the information about the products stored in a database, depending on the client request? Nowadays sites have...

Words: 2137 - Pages: 9

Free Essay

Capital Market of Bangladesh

...Building a Newsletter App in PHP with Dreamweaver CS3 E-mail newsletters are a very popular method of maintaining an open channel of communication with your site visitors. They have the great benefit of keeping a site’s current user base up-to-date on the latest news and offerings from the organization. Moreover, they have the potential for turning site visitors into site customers or donators. In this article, you’ll learn how to create a complete subscribe/unsubscribe application in PHP/MySQL with a standard Dreamweaver CS3 server and just one additional block of code. To use this application, a user signs up for a subscription on a site and receives a confirmation e-mail. The e-mail contains a link to unsubscribe, personalized for the user. In all, you’ll need to create five pages to achieve this functionality: * Subscribe.php: This page is comprised of a basic form that gathers an e-mail address and inserts a new record into the MySQL database. After the record is inserted the page is redirected to confirm_subscribe.php. * Confirm_subscribe.php: While the visitor sees a bit of text confirming his or her subscription on this page, a PHP function contained within e-mails the user a secondary confirmation, which contains a link to unsubscribe via the confirm_unsubscribe.php page. * Error_subscribe.php: This is an error page that displays if the e-mail attempt was not successful; it also contains a link to the subscribe.php page so another attempt can be made. ...

Words: 2239 - Pages: 9

Premium Essay

Web and Email Marketing

...Web Applications Developer (Consultant) Thermo Fisher Scientific (Life Technologies) - Fremont, CA - February 2014 to Present Responsibilities Working in the Remedy Queue as an applications support engineer capacity to resolve IT trouble tickets for the Array Manufacturing Support group. Installed ColdFusion 11 on a Red-Hat Unix system to upgrade a mission critical CRM system (http://vss.appliedbiosystems.com ) Acting as steward of other in-house developed systems in Cold Fusion. Participating in regular agile sprint cycle meetings in my capacity as reports developer for the OligoInc group. Skills Used ColdFusion 8-11. Windows XP, Professional and RedHat UNIX. Oracle 11g Crystal Reports 10, Visual Studio 10, VB.NET, C#. ASP.NET IT Applications Developer Alliance Analytical - Fremont, CA - September 2013 – September 2014 Responsibilities Maintained and enhanced coldfusion backend of components that connected to SQL Server 2008 database of in-house CRM system. Customized Adobe Flex components in the front end as required. Integrated the contacts data of the database with an external SMTP provider by building a web service of the data that fed into the third party API to render email broadcasts data. Maintained web site at http://www.aaisolutions.com . Web Applications Developer (Consultant) Life Technologies - Pleasanton, CA - February 2013 to August 2013 Responsibilities Created a web interface to process replacement assays for open array...

Words: 982 - Pages: 4

Premium Essay

Hostel

...Chapter-1 1.1 Introduction Android is an software platform and operating system for mobile devices. It is based on the Linux kernel. It was developed by Google and later the Open Handset Alliance (OHA). It allows writing managed code in the Java language. Due to Android here is the possibility to write applications in other languages and compiling it to ARM native code. Unveiling of the Android platform was announced on 5 November 2007 with the founding of OHA. It's a consortium of several companies 1.1.1 Introduction to Project Environment OPERATING SYSTEM: An operating system (OS) is software consisting of programs and data hostel management system project report runs on computers and manages computer hardware resources and provides common services for efficient execution of various application software. For hardware functions such as input and output and memory allocation, the operating system acts as an intermediary between application programs and the computer hardware, although the application code is usually executed directly by the hardware and will frequently call the OS or be interrupted by it. Operating systems | | Common Features: * Process management * Interrupts * Memory management ...

Words: 15019 - Pages: 61

Free Essay

Interactive Media Web Authoring

...Interactive Media Web Authoring Developing a news portal application 2011/2012 2HND2I Kurt Massa Table of Contents Table of Contents ................................................................................................................................ 1 Section 1.................................................................................................................................................. 3 Section 2.................................................................................................................................................. 4 Analysis, Design and Implementation ................................................................................................. 5 Content Management Systems....................................................................................................... 5 Blog ................................................................................................................................................. 5 Site Vs Portal ................................................................................................................................... 5 Open Source Software Content Management Systems ................................................................. 5 Software Used ................................................................................................................................. 6 WCM-P3.2 ...........................................................................

Words: 3026 - Pages: 13

Free Essay

Project

...COURSE CODE: 227 NAME: MUIGUA STEPHEN GITAU ADM NO: P15/54335/2012 SUPERVISOR: ERIC AYIENGA   DECLARATION I, Muigua Stephen Gitau, do declare that this project is my own work, and as per my knowledge, it has not been submitted to any other institution of higher learning. Student’s Name: MUIGUA STEPHEN GITAU Registration No: P15/54335/2012 Signature: _________________________________________________________ Date: _________________________________________________________ This project has been submitted as a partial fulfillment of requirements for the Diploma in Computer Science of the University of Nairobi with my approval as the University Supervisor. Supervisor’s Name: Mr. ERIC AYIENGA Signature: ___________________________________________________________ Date: _______________________________________________________________   ACKNWOLEDGEMENT I thank almighty God; I thank Nairobi University of Kenya in Conjunction with the School of Computing and Informatics for facilities and resources they availed during execution of this project. I take this opportunity to express my sincere appreciation to my supervisor Mr. Ayienga and the entire Faculty of Computer Science for the exemplary guidance, monitoring and constant encouragement throughout the course. Lastly, I thank my parents, for their constant support even as I worked over the night and throughout the week towards school and this project.   ABSTRACT ABSTRACT Currently in Kenya...

Words: 4782 - Pages: 20

Free Essay

Programming

...updates and my first Engl... / 10 Unix/Linux Windows 1 Linux Web+ 1 Python/Ruby Web 2 iOS Android Windows Windows Windows Linux+ Windows 9 : csv ( log python csv, python open, python sys) 52 word count (sys, os, path) (python sqlite) print Google (phrase, domain, use reader to follow tech blogs) 2 ( Vim / Emacs / Notepad++ Source Insight ( ctag) Cool IDE) / / 3 Unix/Linux Shell windows man ls/chmod/chown/rm/find/ln/cat/mount/mkdir/tar/gzip … sed/awk/grep/tail/less/more … ps/top/lsof/netstat/kill/tcpdump/iptables/dd… /etc /var/log /proc linux vmware player Ubuntu 1 6 9/6/13 1:36 PM - -[ ] http://blog.renren.com/blog/73603/740437492 /Linux 4 Web Web HTML CSS HTML Firefox + Firebug Javascript HTML DOM Firefox + Firebug Apache PHP PHP PHP chrome Nginx HTML MySQL MySQL SQL http://www.stanford.edu/~ouster/cgi-bin/cs142-fall10/index.php ) javascript HTTP: The Definite Guide browsers) Cookie/Session jQuery 4 3-5 ExtJS + Ajax ( +JSON (proxy, gateway, Javascript box model chrome DOM http://oreilly.com/catalog/9780596527402) HTML/CSS/JS) + WEB (LAMP) W3School 1 C C C C Unix/Linux fork/wait/waitpid signal/kill/raise/alarm/pause/sigprocmask gcc gdb makefile IPC Socket Windows SDK Windows WinMain/WinProcedure Windows SDK MSDN SDK GUI 2 Java Java Java JDK Java IDE Eclipse Tomcat JSP Servlet 3 Web HTML5 Web HTTP Server Web Web HTML5 canvas Web Web 4 SVN JUnit Git Java rewrite Nginx Cache Web SQL JS...

Words: 807 - Pages: 4

Premium Essay

Rm Avakjll

...manual complement many of the chapters of the Elmasri/Navathe text typically covered in most introductory database systems courses. Chapter Mappings The laboratory manual consists of 8 chapters and the following table shows the mapping to the chapters in the Elmasri/Navathe textbook: Laboratory Manual Chapter Elmasri/Navathe 6th Edition Chapter(s) Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapters 7, 8, and 9 Chapters 3, 6, and 26 Chapters 4, 5, and 13 Chapters 4, 5, and 14 Chapters 15 and 16 Chapter 11 Chapter 12 Chapters 13 and 14 Chapter 1 presents ERWin, a popular data modeling software that allows database designers to represent Entity-Relationship diagrams and automatically generate relational SQL code to create the database in one of several commercial relational database management systems such as Oracle or Microsoft SQLServer. The material presented in this chapter is tutorial in nature and covers the COMPANY database design of the Elmasri/Navathe text in detail. Chapter 2 presents three interpreters that can be used to execute queries in Relational Algebra, Domain Relational Calculus, and Datalog. These interpreters are part of a Java package that includes a rudimentary database engine capable of storing relations and able to perform basic relational...

Words: 18417 - Pages: 74

Free Essay

Siteprotector Database Tuning Guide

...Database Tuning and Administration Guide for SP6.1 February 22, 2007 IBM Internet Security Systems, Inc. 6303 Barfield Road Atlanta, Georgia 30328-4233 United States (404) 236-2600 http://www.iss.net © IBM Internet Security Systems, Inc. 1994-2006. All rights reserved worldwide. Customers may make reasonable numbers of copies of this publication for internal use only. This publication may not otherwise be copied or reproduced, in whole or in part, by any other person or entity without the express prior written consent of Internet Security Systems, Inc. Patent pending. Internet Security Systems, System Scanner, Wireless Scanner, SiteProtector, Proventia, Proventia Web Filter, Proventia Mail Filter, Proventia Filter Reporter ADDME, AlertCon, ActiveAlert, FireCell, FlexCheck, Secure Steps, SecurePartner, SecureU, and X-Press Update are trademarks and service marks, and the Internet Security Systems logo, X-Force, SAFEsuite, Internet Scanner, Database Scanner, Online Scanner, and RealSecure registered trademarks, of Internet Security Systems, Inc. Network ICE, the Network ICE logo, and ICEpac are trademarks, BlackICE a licensed trademark, and ICEcap a registered trademark, of Network ICE Corporation, a wholly owned subsidiary of Internet Security Systems, Inc. SilentRunner is a registered trademark of Raytheon Company. Acrobat and Adobe are registered trademarks of Adobe Systems Incorporated. Certicom is a trademark and Security Builder is a registered trademark of Certicom...

Words: 5367 - Pages: 22

Free Essay

Hshajs

...- PHP, Apache, MySQL, Windows : WampServer http://forum.wampserver.com/read.php?2,77471,77478 Apache, PHP, MySQL on Windows Home forum Back to WampServer presentation Downloads Addons Trainings Alter Way Go to: Forum List•Message List•New Topic•Search•Log In•Print View 404 Error Page when try to start LocalHost/phpMyAdmin Posted by: gjalpert (---.bb.netvision.net.il) Date: September 12, 2011 09:01PM Go to Topic: Previous•Next I been trying all day to get wamp server started. Just have no luck and figure its best to ask on the forums. I'm currently using Windows XP, and I'm assuming that somehow Wampserver is not configured with my localhost and that's why is not working. Anyone knows how to get it to work? Options: Reply•Quote Re: 404 Error Page when try to start LocalHost/phpMyAdmin Posted by: yfastud (Moderator) Date: September 12, 2011 11:58PM Make sure no other program conflict Wamp such as IIS, Microsoft Web Deploy, SQL, Skype, Zonealarm, firewall/antivirus, NOD32, Eset, any web related program including Remote Desktop, Teamviewer or Apache, MySQL, PHP outside wamp folder (ie. in Program Files or System32 folder) ... IIS and Apache/Wamp are both web server and might conflict in some way, so you have to disable IIS in order for Wamp to work Disable IIS in Vista/W7: Control Panel, Uninstall Programs, Turn Widows Features On or Off, uncheck Internet Information Services Disable IIS in XP: Control Panel, Add/Remove Programs, Add/Remove Windows Components, uncheck...

Words: 598 - Pages: 3

Free Essay

Essay on Business Operations Management

...from ... right? but we are based in pune, r u ready to move here   how many companies u have worked in till now? then why would u like to switch?     so far u have worked in (number) projects were they all in core php? if not then in what other framework? then ask about that framework so u have experiance in oop then ask oop questions then go to php questions then go to my sql then js     I think thats all we need our hr will get back to u with the decision/result but before that may i know ur current ctc and expected ctc? and is it negotiable? PHP: 1) What is use of header() function in php ? The header() function sends a raw HTTP header to a client.We can use herder() function for redirection of pages. It is important to notice that header() must be called before any actual output is seen.. 2) what does the error message "header already sent" mean? Ques: 10 How we can upload videos using PHP? Ans: When want to upload videos using PHP we should follow these steps: 1.first you have to encrypt the the file which you want to upload by using "multipart-form-data" to get the $_FILES in the form submition. 2.After getting the $_FILES['tmp_name'] in the submition 3.By using move_uploaded_file (tmp_location,destination) function in PHP we can move the file from original location. 3) What is the difference between $name and $$name? $name is variable where as $$name is reference variable like $name=sonia and $$name=singh so $sonia value is singh. ...

Words: 5893 - Pages: 24

Premium Essay

Online Registration System

...computer software that is aimed to provide a managing tool for maintaining the data, through various data models. The purpose of implementing this project is to understand the data modeling concepts that is used in a real time scenario and to implement a fully functional database system which interacts with a front end interface. 2. Definition of the Problem An Online Course Registration system for University of Dataville is to be developed with a front-end web interface and a back-end database. An example of the system would be University of Florida’s ISIS Registration. Any database system can be chosen as the back-end such as Oracle, MySQL, Microsoft SQL Server, DB2, Access. Any web server can be chosen for the front end such as Tomcat, Glassfish, JRun, etc. Any server side language can be chosen such as PHP, JSP, ASP, etc. 3. Project Specification A high level description of the project: • Each student has a unique student ID and a profile. The profile includes first/last names, gender, date of birth, local address, department, enrolled year, username, login password, and may have a picture. You can also add other necessary information. • Each instructor has a unique faculty ID and a profile. The profile must indicate the instructor’s department(s). An instructor may work at...

Words: 3961 - Pages: 16