Connecting a Web page to MySQL

MySQL expert Scott Noyes explains the three components of connecting a Web page to MySQL.

Scott Noyes, Oracle

Published: 03 Aug 2006

I need to run a SQL statement on a button click using Javascript in the LotusNotes Web form and get the value returned, based on that value I need to open a form. I tried to search for AJAX code on running a SQL statement but couldn't find any. What should I do to resolve this?

Connecting a Web page to MySQL requires JavaScript on the client to issue the request, MySQL on the server to handle the query and a server-side scripting language to stand in-between. You may use any language you wish; PHP, Perl and Python are popular candidates.

Here is an article showing each step is done and how to tie them together.

Dig Deeper on Linux servers

SQL Server vs. MySQL: Learn the differences MySQL and Microsoft SQL Server relational databases have their pros and cons. Weigh the differences between SQL Server and MySQL features, costs, functionality and more.

DBSync for MS SQL & MySQL DBSync for MS SQL & MySQL performs SQL-to-MySQL and MySQL-to-SQL database conversion and synchronization.

DBConvert for MS SQL & MySQL DBConvert for MS SQL & MySQL allows for the conversion from MySQL databases to SQL Server and from SQL Server databases to MySQL servers.

Hot skils: MySQL 5.1 Skills for IT professionals: MySQL 5.1

Troubleshooting a virtualized MySQL: Tales of a MySQL admin In this tip, MySQL admin Brendan Barry troubleshoots three MySQL problems. Read about how he completed a database move, migrated data from Windows to a virtualized instance of MySQL and debugged a few data-changing queries.

mysql_ functions vs. mysqli object approach MySQL expert Scott Noyes explains why using mysqli over mysql_functions allows you to take advantage of MySQL's newer features and PHP scripts.

Related Q&A from Scott Noyes

Advice on MySQL character sets and collations

Get suggestions for choosing MySQL character sets and field collations from expert Scott Noyes. Continue Reading

Incorporating multi-master support in MySQL

A MySQL expert describes two ways that the multi-master support can be used. Continue Reading

Detection deadlock algorithms in MySQL

An expert describes where to find information on detection deadlock algorithms in MySQL. Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Data Center experts

View all Data Center questions and answers

SearchWindowsServer

Connecting a Web page to MySQL

MySQL expert Scott Noyes explains the three components of connecting a Web page to MySQL.

Dig Deeper on Linux servers

Related Q&A from Scott Noyes

Advice on MySQL character sets and collations

Incorporating multi-master support in MySQL

Detection deadlock algorithms in MySQL

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

How to manage Exchange hybrid mail flow rules

How to repair Windows Server using Windows SFC and DISM

Microsoft's history and future strategy beyond 2020

SearchServerVirtualization

Learn to integrate VMs and containers in your data center

Dockerfile commands for containerizing applications

VMware vSphere monitoring ensures system health, performance

SearchCloudComputing

Review these Azure Service Bus best practices

Instill cloud change management best practices

How much cloud does an IT disaster recovery plan need?

Related Resources

Dig Deeper on Linux servers

Related Q&A from Scott Noyes

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.