I am working on a Jquery mobile site using DW CS6. I'm trying to use the sql insert behavior to insert data into a database. When I take the Jqery and Jquery mobile code from the head tag the extension works fine. However, when I leave the code, the dat
<?php require_once('Connections/Connections.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php require_once('webassist/mysqli/queryobj.php'); ?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>jQuery Mobile Web App</title>
<link href="jquery-mobile/jquery.mobile-1.0.min.css" rel="stylesheet" type="text/css"/>
<script src="jquery-mobile/jquery-1.6.4.min.js" type="text/javascript"></script>
<script src="jquery-mobile/jquery.mobile-1.0.min.js" type="text/javascript"></script>
</head>
<?php
$users = new WA_MySQLi_RS("users",$Connections,1);
$users->setQuery("SELECT * FROM users");
$users->execute();
?>
<?php
if ((((isset($_POST["submit"]))?$_POST["submit"]:"") != "")) {
$InsertQuery = new WA_MySQLi_Query($Connections);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "users";
$InsertQuery->bindColumn("oponent", "s", "".((isset($_POST["oponent"]))?$_POST["oponent"]:"") ."", "WA_DEFAULT");
$InsertQuery->saveInSession("userID");
$InsertQuery->execute();
$InsertGoTo = "index.php";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>
<body>
<div data-role="page" id="page">
<div data-role="header">
<h1>Page One</h1>
</div>
<div data-role="content">
<ul data-role="listview">
<li><a href="#page2">Page Two</a></li>
<li><a href="#page3">Page Three</a></li>
<li><a href="#page4">Page Four</a></li>
</ul>
</div>
<div data-role="footer">
<h4>Page Footer</h4>
</div>
</div>
<div data-role="page" id="page2">
<div data-role="header">
<h1>Page Two</h1>
</div>
<div data-role="content">
<form action="index.php" method="post" name="test" id="test">
<input name="oponent" type="text" />
<input name="submit" type="submit" />
</form>
</div>
<div data-role="footer">
<h4>Page Footer</h4>
</div>
</div>
<div data-role="page" id="page3">
<div data-role="header">
<h1>Page Three</h1>
</div>
<div data-role="content">
Content
</div>
<div data-role="footer">
<h4>Page Footer</h4>
</div>
</div>
<div data-role="page" id="page4">
<div data-role="header">
<h1>Page Four</h1>
</div>
<div data-role="content">
Content
</div>
<div data-role="footer">
<h4>Page Footer</h4>
</div>
</div>
</body>
</html>