connection of php to MySQL.
I have a query on connection of php to MySQL.
Website's serverspace by godaddy
and provides phpmyadmin(interface of MySQL) for Database
I have a page
admin.php
<?php
if (isset($_POST["submitted"]))
{
include('connect-mysql.php');
$username=$_POST['username'];
$password=$_POST['password'];
$sqlinsert="INSERT INTO adminlogin (username,password) VALUES ('$username','$password');";
if(!mysqli_query($link,$sqlinsert))
{
die('error in inserting data');
}
$newrecord="1 record updated in database";
}
?>
<html>
<form action="admin.php" method="post" id="admin-login">
<input type="hidden" name="submitted" value="true"/>
<fieldset>
<td><span class="text-form">Username:<td><input name="username" type="text" /></td>
<td><span class="text-form">Password:</span></td>
<td><input name="password" type="text" /></td>
<div class="buttons">
<a href="#" onclick="document.getElementById('admin-login').reset()">Clear</a>
<a href="#" onclick="document.getElementById('admin-login').submit()">Send</a>
</form>
<?php
echo $newrecord
?>
</html>
According to this code on clicking the send button should call the above written php code, make the connection and run the query..
Connection is made perfectly 'connect-mysql.php'
but the data is not getting inserted into the table(in phpmyadmin).
Can u give a resolution on this?
View Answers
September 22, 2013 at 5:22 PM
September 23, 2013 at 8:58 PM
Hey as i mentioned i am able to make an connection.
But I was not able to fetch and insert data from/to the database and also i am using mysqli version
Ads
Related Tutorials/Questions & Answers:
connection of php to MySQL.
connection of
php to
MySQL. I have a query on
connection of
php to
MySQL.
Website's serverspace by godaddy
and provides phpmyadmin(interface of
MySQL) for Database
I have a page
admin.php
<?
php
if (isset($_POST
PHP Mysql Database Connection
PHP Mysql Database
Connection
PHP Mysql Database
Connection is used to build a
connection...
The Tutorial illustrate an example from
PHP Mysql Database
Connection
Advertisements
connection in php
connection in php <?
php
include("include/db.php");
?>
<...;categories</div>
<ul id="cate">
<?
php
$get_cate="select * from categories";
$run_cate=
mysql_query($con
connection in php
connection in php <?
php
include("include/db.php");
?>
<...;categories</div>
<ul id="cate">
<?
php
$get_cate="select * from categories";
$run_cate=
mysql_query($con
connection in php
connection in php <?
php
include("include/db.php");
?>
<...;categories</div>
<ul id="cate">
<?
php
$get_cate="select * from categories";
$run_cate=
mysql_query($con
PHP SQL Connection
PHP SQL
Connection
PHP SQL
Connection is used to access and return the records from
PHP... the host,
user, password and database that connects the
PHP server side to
MySQL
php mysql
php mysql automatically insert a value in the month field at the last
date of current month in
mysql database
php mysql
php mysql automatically insert a value in the month field at the last
date of current month in
mysql database
PHP SQL close connection
PHP SQL close
connection
PHP SQL close
connection is used to close a
connection between the
PHP... '
PHP SQL close
Connection'. To
understand and grasp the example we include
php form post to mysql
php form post to mysql How to post data into
mysql database from the
PHP post data form
PHP MySQL query
PHP MySQL query I have 11 tables and have to do the CRUD operations keeping userid as a reference key
connection to mysql in jsp
connection to
mysql in jsp please i got this error message when trying to connect to
mysql database in jsp.
Unknown character set: 'utf8mb4
php inserting date into mysql
php inserting date into mysql
php inserting date into
mysql
Here is a
php code that inserts date into
mysql database. In the given code, data is a database table.
<?
php
table
$query_manual = "INSERT INTO data
PHP MYSQL Interview Questions
PHP MYSQL Interview Questions What kind of questions can be asked in an
PHP,
MYSQL interview? Can anyone post the
PHP interviews questions with well explained answers?
PHP,
MYSQL Interview Questions
Please tell me
drop down php mysql - PHP
drop down
php mysql
PHP Script required to show the similar drop down item in each menu without refreshing the page. Is it possible if yes how
Import MYSQL file in PHP - PHP
Import
MYSQL file in PHP i wanted to import the
mysql file in PHP5 on button click. is it possible to do it? Is there any possibility of data security
login page php mysql example
login page
php mysql example How to create a login page for user in
PHP Mysql? Please provide me a complete tutorial.
Thanks in Advance
php mysql fetch array example
php mysql fetch array example How to fetch data from
mysql and store it into an array in
PHP? Please post an example.
Thanks in Advance
DriverClass hibernate mysql connection.
DriverClass hibernate
mysql connection. What is DriverClass in Hibernate using
mysql connection?
DriverClass implements java.sql.Driver.... the
connection url as-
<property name="connection.url">jdbc:
mysql://localhost
SQL PHP
;
Mysql database. Once the
connection is built,
PHP server side scripting....
The function is used to send a query or command to a
MySQL connection.
Understand...;;
$database = "komal";
$
connection =
mysql_connect($host,$user,$password
PHP Mysql Group By
PHP Mysql Group By
PHP Mysql Group By is used to establish a relation between the
PHP...
The Tutorial illustrate an example from
PHP Mysql Group By. To understand and
grasp
Mysql PHP Select
Mysql PHP Select
Mysql PHP is used to execute the select statement using
mysql_query ( )
function. The function send a query or command to a
MySQL connection
jsp/mysql connection
jsp/
mysql connection I am puttng the following files in the lib folder of jdk to connect jsp and
mysql and in the lib folder of tomacat and in the lib folder of project of netbeans but I am unable to to connect jsp and
mysql
jsp/mysql connection
jsp/
mysql connection I am puttng the following files in the lib folder of jdk to connect jsp and
mysql and in the lib folder of tomacat and in the lib folder of project of netbeans but I am unable to to connect jsp and
mysql