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

Hi,

Please check the tutorial Check PHP MySQL Connectivity.

Thanks

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

Advertisements

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 between the PHP on the server-side and Mysql on the backend. Understand

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 database connection between PHP and SQL. To understand the example we create a table

ftp connection error php
ftp connection error php Getting a ftp connection error in php

php mysql
php mysql automatically insert a value in the month field at the last date of current month in mysql database

why php and mysql - PHP
why php and mysql I noticed in most of the application that developer always use mysql with PHP. Why they do so,, as there are money other database are too available

PHP SQL close connection
PHP SQL close connection PHP SQL close connection is used to close a connection between the PHP... an example from 'PHP SQL close Connection'. To understand and grasp the example

Upgrading a PHP/MYSQL application?
Upgrading a PHP/MYSQL application? Upgrading a PHP/MYSQL application

connection with MySQL to java.
connection with MySQL to java. how to connect MySQL database with jsp

enum php mysql
enum php mysql How to use mysql enum in php

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 form post to mysql
php form post to mysql How to post data into mysql database from the PHP post data form

ide php mysql
ide php mysql what is ide for php and mysql Hi, You can use Eclipse to develop your PHP project. The easist way is to download the Eclipse having PHP support from eclipse download site.ADS_TO_REPLACE_1 The Eclipse

Mysql-Php code
Mysql-Php code I want to mysql script for query data from two tables in the mysql database trough php code. Can you help me Hi Friend, Please visit the following link:ADS_TO_REPLACE_1 Php Mysql Thanks �

PHP mysql database backup script - PHP
PHP mysql database backup script How can i get the database backup using PHP mysql database

PHP MySQL query
PHP MySQL query I have 11 tables and have to do the CRUD operations keeping userid as a reference key

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

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

connection of jsp with mysql - JSP-Servlet
Example of connection between JSP and MYSQL Need an example of connection between JSP and MYSQL

Database connectivity Hibernate mysql connection.
Database connectivity Hibernate mysql connection. How to do database connectivity in Hibernate using mysql

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

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

php mysql web application tutorial
php mysql web application tutorial How to create a simple php mysql web application? Please post an example or tutorial

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

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

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

connection of jsp with mysql - JSP-Servlet
connection of jsp with mysql can anybody tell me about connection of JSP with MYSQL? and also tell me which version is compatible with tomcat 4.1 i am using tomcat 4.1, MYSQL 5.0 but i have problem with connection

SQL PHP
table 'stu' in Mysql database. Once the connection is built, PHP server side.... The function is used to send a query or command to a MySQL connection. Understand...;; $password = "root"; $database = "komal"; $connection = mysql

JSP - MySQL - Connection
JSP - MySQL - Connection I can't connect mysql using jsp in my... to resolve this problem.I set classpath for the mysql connector jar (/home/aghiltu/apache-tomcat-6.0.26/lib/mysql-connector-java-5.1.8-bin.jar

PHP MySql Server Version
PHP MYSQL server version Sometimes we need to check the version of MySql, PHP...: http://www.roseindia.net/sql/mysql-example/php-sql-die.shtml Code: <... ' );//mysql_connect(): it open a connection to a MySql server //root is the name

sql php code
' in Mysql database. Once the connection is built, PHP server side scripting is used...; SQL PHP code executes the statement using the mysql_query ( ) function. The function is used to send a query or command to a MySQL connection. Understand

what is the mysql in the database using php
what is the mysql in the database using php what is the mysql in the database using php Please visit the following link: PHP Database

MySQL &PHP - WebSevices
MySQL &PHP Hello, I have write a script to read from a file and than store the values to a mysql. My problem is when I am storing this values in mysql the 1st column is taking 0 value and after this it is storing

PHP Mysql Group By
PHP Mysql Group By PHP Mysql Group By is used to establish a relation between the PHP..._TO_REPLACE_1 The Tutorial illustrate an example from PHP Mysql Group By. To understand

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

MySQL PHP Insert
MySQL PHP Insert Mysql PHP Insert is used to execute the Mysql function ( ) insert queries in the PHP server side script and print the records on the browser

Todd oracle DB connection through PHP
Todd oracle DB connection through PHP Can u please explain how to connect Todd oracle DB using PHP & What are the setups we need to perform? Thanks

how to post data in mysql php form
how to post data in mysql php form how to post data in mysql php form

Charset problem upon publishing PHP + MySQL website
Charset problem upon publishing PHP + MySQL website Charset problem upon publishing PHP + MySQL website

connection with mysql with jstl - JSP-Servlet
connection with mysql with jstl hi, i m working on jstl . i hv done connection in MS -Access with JSTL . The code is working well. but when i am trying to connect database with mysql 5.0 it is creating problem. Plz tell me

return all rows mysql php
return all rows mysql php How to find or return results that are not available in another table .. using join method in PHP and MYSql. SELECT * FROM Declined LEFT JOIN Request ON Declined.RequestID

connection of php to MySQL.

Questions by Category