|
Home
Browse Sections
Recent Searches
|
|
|
| You are here : HOME > SQL |
 |
 |
Learning PHP, MySQL, and JavaScript: A Step-By-Step Guide to Creating Dynamic Websites (Animal Guide)
Price : $39.99 $22.24
Average
Customer Rating : Not
yet rated |
|
Editorial Review :
If you know HTML, this guide will have you building interactive websites quickly. You'll learn how to create responsive, data-driven websites with PHP, MySQL, and JavaScript, regardless of whether you already know how to program. Discover how the powerful combination of PHP and MySQL provides an easy way to build modern websites complete with dynamic data and user interaction. You'll also learn how to add JavaScript to create rich Internet applications and websites.
Learning PHP, MySQL, and JavaScript explains each technology separately, shows you how to combine them, and introduces valuable web programming concepts, including objects, XHTML, cookies, and session management. You'll practice what you've learned with review questions in each chapter, and find a sample social networking platform built with the elements introduced in this book.
This book will help you:
- Understand PHP essentials and the basics of object-oriented programming
- Master MySQL, from database structure to complex queries
- Create web pages with PHP and MySQL by integrating forms and other HTML features
- Learn about JavaScript, from functions and event handling to accessing the Document Object Model
- Use libraries and packages, including the Smarty web template system, PEAR program repository, and the Yahoo! User Interface Library
- Make Ajax calls and turn your website into a highly dynamic environment
- Upload and manipulate files and images, validate user input, and secure your applications
Customer Review :
No review yet |
 |
PHP and MySQL Web Development (4th Edition)
Price : $54.99 $27.99
Average
Customer Rating : Not
yet rated |
|
Editorial Review :
PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications. PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server. This practical, hands-on book includes numerous examples that demonstrate common tasks such as authenticating users, constructing a shopping cart, generating PDF documents and images dynamically, sending and managing email, facilitating user discussions, connecting to Web services using XML, and developing Web 2.0 applications with Ajax-based interactivity. The fourth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP 5 through version 5.3, such as namespaces and closures, as well as features introduced in MySQL 5.1.
Customer Review :
No review yet |
 |
Sams Teach Yourself SQL in 10 Minutes (3rd Edition)
Price : $24.99 $10.55
Average
Customer Rating : Not
yet rated |
|
Editorial Review :
Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in applying the SQL language. Forta¿s examples are clear and his writing style is crisp and concise. As with earlier editions, this revision includes coverage of current versions of all major commercial SQL platforms. New this time around is coverage of MySQL, and PostgreSQL. All examples have been tested against each SQL platform, with incompatibilities or platform distinctives called out and explained.
Customer Review :
No review yet |
 |
Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners (SQL Exam Prep Series 70-433 Volume 1 of 5) (Sql Design Series)
Price : $25.00 $17.39
Average
Customer Rating : Not
yet rated |
|
Editorial Review :
Several years ago a challenge was given to technology instructor Rick A. Morelan. Take downsized workers with little or no experience with computers or technology and turn them into industry certified technology experts. The proven material from this venture is now available to you as the Joes 2 Pros series of books and videos. This new approach has vivid pictures on almost every page that shows what you should see on your computer screen as you work through the material, and downloadable content, home practice labs, software, and fun review games available from the joes2pros web site. Starting with the basic lesson: "What is a Database? " this book helps beginners get comfortable with the SQL language. From there, you will walk step-by-step through the basics. 'Beginning SQL Joes 2 Pros' is the second edition of the popular 'T-SQL Joes 2 Pros' with updated content and a lower price. The language examples in this book can be used with any standard SQL engine. Regardless of your skill level, you too can evolve from "Joe" to "Pro" by following the steps outlined in this book. Note: My publisher is not able to put a DVD in the back of the book but a DVD showing all topic and labs in 3 hours of full video can be bought on Amazon at this link http://www.amazon.com/Beginning-SQL-Joes-Pros-70-433/dp/B004GEB67C/ref=sr_1_2?ie=UTF8&qid=1294633127&sr=8-2
Customer Review :
No review yet |
 |
Access 2007: The Missing Manual
Price : $34.99 $18.00
Features
: - ISBN13: 9780596527600
- Condition: New
- Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!
Average
Customer Rating : Not
yet rated |
|
Editorial Review :
Compared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. It runs on PCs rather than servers and is ideal for small- to mid-sized businesses and households. But Access is still intimidating to learn. It doesn't help that each new version crammed in yet another set of features; so many, in fact, that even the pros don't know where to find them all. Access 2007 breaks this pattern with some of the most dramatic changes users have seen since Office 95. Most obvious is the thoroughly redesigned user interface, with its tabbed toolbar (or "Ribbon") that makes features easy to locate and use. The features list also includes several long-awaited changes. One thing that hasn't improved is Microsoft's documentation. To learn the ins and outs of all the features in Access 2007, Microsoft merely offers online help. Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master. Customer Review :
No review yet |
|
More
Results : 1 | 2 | 3 | 4 | 5 [Next] [Last]
|
|
Questions & Answers
Question : What is the difference between SQL Server and MySQL?
I understand that MySQL is used to manage your website database can SQL Server do the same thing, if so why are companies such as Yahoo and Google using MySQL. What is Microsoft SQL Server's and MySQL's main purpose
Answer:
The biggest difference is open source vs closed source. Here's one description of the difference:http://en.wikipedia.org/wiki/Open-source_software#Open_source_vs._closed_source
|
Question : what is SQL query to copy a table from one database into a different?
What is the SQL query for copying a table with its contents from one database into a different database. I am using SQL server 2005.
Answer:
select * into db_name1.dbo.new_table from db_name2.dbo.old_table
|
Question : How do I set up SQL Server so I can access it from another computer over a network?
I want to be able to access my SQL Server on my computer from another computer on the network.Both computers have SQL Server installed now I just need to know how to configure the Host system and what ports I need to open on the firewall for example.Thanks.
Answer:
To access from computer A to computer B, you can register/Connect B on A. default port 1433. SQL Server 2000: on Computer A, open Enterprise Manger, right click SQL server group-->New SQL server registration.. follow the instruction.. SQL 2005 SQL Server Mangement Studio, just connect computer B directly or register...If you want to join database tables between computer A and computer B, your best answer is to create linked server. on SQL 2000: security->linked server-->new linked server; on SQL2005: server objects-->linked server... From any database in computer A, You can refer or join tables on computer B as linkedserverB.dbname.dbo.tablename
|
Question : What is SQL Injection and How does one accomplish this for penetration testing?
I am interested in SQL injection to maintain secure and safe networks as well as secure software. Does anyone have any general information to help me learn more about this phenomena?
Answer:
SQL Injection is a trick to inject SQL query/command as an input possibly via web pages. Many web pages take parameters from web user, and make SQL query to the database. Take for instance when a user login, web page that user name and password and make SQL query to the database to check if a user has valid name and password. With SQL Injection, it is possible for us to send crafted user name and/or password field that will change the SQL query and thus grant us something else. Try to look for pages that allow you to submit data, i.e: login page, search page, feedback, etc. Sometimes, HTML pages use POST command to send parameters to another ASP page. Therefore, you may not see the parameters in the URL. However, you can check the source code of the HTML, and look for "FORM" tag in the HTML code. You may find something like this in some HTML codes:You should look for pages like ASP, JSP, CGI, or PHP web pages. Try to look especially for URL that takes parameters, like:http://duck/index.asp?id=10Start with a single quote trick. Input something like:hi' or 1=1--Into login, or password, or even in the URL. Example:Login: hi' or 1=1-- Pass: hi' or 1=1-- http://duck/index.asp?id=hi' or 1=1--If you must do this with a hidden field, just download the source HTML from the site, save it in your hard disk, modify the URL and hidden field accordingly. Example:If luck is on your side, you will get login without any login name or password. Let us look at another example why ' or 1=1-- is important. Other than bypassing login, it is also possible to view extra information that is not normally available. Take an asp page that will link you to another page with the following URL:http://duck/index.asp?category=foodIn the URL, 'category' is the variable name, and 'food' is the value assigned to the variable. In order to do that, an ASP might contain the following code (OK, this is the actual code that we created for this exercise):v_cat = request("category")sqlstr="SELECT * FROM product WHERE PCategory='"& v_cat &"'"set rs=conn.execute(sqlstr)As we can see, our variable will be wrapped into v_cat and thus the SQL statement should become:SELECT * FROM product WHERE PCategory='food'The query should return a resultset containing one or more rows that match the WHERE condition, in this case, 'food'.Now, assume that we change the URL into something like this:http://duck/index.asp?category=food' or 1=1--Now, our variable v_cat equals to "food' or 1=1-- ", if we substitute this in the SQL query, we will have:SELECT * FROM product WHERE PCategory='food' or 1=1--'The query now should now select everything from the product table regardless if PCategory is equal to 'food' or not. A double dash "--" tell MS SQL server ignore the rest of the query, which will get rid of the last hanging single quote ('). Sometimes, it may be possible to replace double dash with single hash "#".However, if it is not an SQL server, or you simply cannot ignore the rest of the query, you also may try' or 'a'='aThe SQL query will now become:SELECT * FROM product WHERE PCategory='food' or 'a'='a'It should return the same result.Depending on the actual SQL query, you may have to try some of these possibilities:' or 1=1--" or 1=1--or 1=1--' or 'a'='a" or "a"="a') or ('a'='a
|
Question : What sort of SQL injection attacks is the MS Access ODBC Driver susceptible to?
Okay I'm replacing all apostrophes ' with double apostrophes '' (not quote marks, two apostrophe characters). This seems to prevent most of my attempts to insert any SQL fails. Can anyone think of any way to insert SQL?
Answer:
Remove NULL characters from input. SQL NULLs are not the same as programming/scripting NULLs, and they may be put in to terminate a line by exception (overflow errors), allowing for the double dash ( e.g.: -- SQL single line comments) to be inserted, which in turn can allow for arbitrary code to follow...Check this page: http://msdn.microsoft.com/en-us/library/ms161953.aspx . They explain it better than I can.
|
Question : sql???!!!?
i used a Vector object in java prgramming and an ecxeption "array endex out of bound " occured when i wanted to fill it with integer elements, what should i do???plz help....thanks...
Answer:
Perhaps you are assigning a negative number to your index, or you told the program to access an index which isn't there, test the program by printing the index numbers the program is being assigned, and find out where your variables are in the vector, good luck!
|
Question : SQL Server: How do I determine the security group through which a user is granted permission?
In SQL Server, a user in my domain is able to access a database because they are a member of a particular security group. How can I determine the security group that this user is a member of and therefore is gaining access?
Answer:
From your question, I'm a little unsure of what you mean by security group. If you mean group on the domain, you'll need to obtain a list of groups the user is assigned to (Active Directory?) and then trace these back to your server to see which group has been granted access.If you mean SQL Server security group, without knowing which version of SQL Server you have installed these instructions may be incorrect but I'll assume you have a 2005 instance.Log on to the server in Management Studio and then expand the "Security" folder. You can then expand the "Logins" folder which will list the domain users (and groups) that have access granted for parts of the SQL Server. Double clicking the user (or group) will then allow you to configure the access in further detail and also view the server roles for that user.As another approach, you could also right click on the server instance in Management Studio, view Properties and then look at the permissions tab (it should be the last one on the list). This will also allow you to view the user permissions.Hope this helps.
|
Question : How do I store picturebox images to sql and retrieve that picture again from sql to picturebox?
I'm using vb as my language. I could now browse pictures and display it to my picturebox. What I would want to do next is to store that image to sql database. On the other hand, I also want to retrieve that image from sql and display it to the picturebox. Please help guys.. Thanks a lot!!
Answer:
I'm using vb as my language. I could now browse pictures and display it to my picturebox. What I would want to do next is to store that image to sql database. On the other hand, I also want to retrieve that image from sql and display it to the picturebox. Please help guys.. Thanks a lot!!
|
Question : How long will SQL be the main database computer language for corporate America?
I am currently working as a Database Analyst and love it! I graduated in December and started my first entry-level job as a Database Analyst. Of course, I work with everything SQL. I was just curious as to how long SQL will be the main requirement for employers? I know I will have to learn whatever new comes out down the road.
Answer:
If the SQL language was a company, it would have a logo on the bottom that says "in business since 1972".In my opinion, SQL will be here for a long time unless they come up with a completely new system to replace the concept of a database. Even though each db technology (eg. oracle, sql server, db2, etc..) all have their own flavor of SQL, SQL-92 will always be supported across all database platform. however, you should know the sql flavour (eg.t-sql for sql server) inside-out for the database your company is using.
|
Question : SQL???????????????????????
who knows a way to learn sql quickly and just the basics of sql
Answer:
The best way is to install a database ( Anything from MySQL to Oracle all have free downloads ) install an IDE ( Eclipse is OK, SQL Developer is really good for Oracle - again both are free to dowload and use ) and then have a go.There are also some web sites which allow you to try SQL online ( http://www.w3schools.com/SQl/default.asp has a tutorial and also a try it type page )Main thing is to understand your data - how things link together and what the data represents. If you know that it makes more sense why you would want to process it in certain ways, or how you can extract data for a given purpose.
|
Powered by Yahoo! Answers
|
|
