jQWidgets Forums

Tagged: jqxDropDownList, jqxSwitchButton, mssql

This topic contains 2 replies, has 2 voices, and was last updated by Hristo 8 years, 5 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)

Author

How can I run the code of another php page when I clcik on a jqxswitchbutton Posts

November 15, 2016 at 11:41 pm How can I run the code of another php page when I clcik on a jqxswitchbutton #89072

Participant

Hello,
First of all, you have to know that I’m a beginner… sorry for that 🙂
My goal is to populate a dropdownlist with data from MSSQLserver db when I switch on the jqxSwitchButton.
For that, I have created 3 different files:
connect.php containing the MSSQL credentials:

<?php
	$hostname = "localhost";
	$database = "Customers";
	$username = "sa";
	$password = "azerty";
?>

data.php executing the SQL query and return the value to the jqxDropDownList

<?php
	#Include the connect.php file
	include('connect.php');

	//SQL connection info
	$ConnectionInfo = array( "Database"=>$database, "UID"=>$username, "PWD"=>$password );
	//Connect to the database
	$conn = sqlsrv_connect( $hostname, $ConnectionInfo );
	//If connection problem then display "Connection to the server failed !"
	if ($conn === false)
	{
		echo '<script language="javascript">';
		echo 'alert("Connection to the server failed !")';
		echo '</script>';
		die( print_r( sqlsrv_errors(), true ));
		exit;
	}

	// get data and store in a json array
	$query = "SELECT * FROM Customers";
	$result = sqlsrv_query( $conn, $query );
	if( $result === false) 
	{
		echo '<script language="javascript">';
		echo 'alert("A problem in the query is detected!")';
		echo '</script>';
		die( print_r( sqlsrv_errors(), true) );
		exit();

	}

	while( $row = sqlsrv_fetch_array( $result, SQLSRV_FETCH_ASSOC ) ) 
		{
			$customers[] = array(
			'CompanyName' => $row['CompanyName'],
			'ContactName' => $row['ContactName'],
			'ContactTitle' => $row['ContactTitle'],
			'Address' => $row['Address'],
			'City' => $row['City']
			  );
		}

	echo json_encode($customers);

	sqlsrv_free_stmt( $result);
?>

index.php where I simply populate directly the jqxdropdownlist because I don’t know how to run it only when I click on the jqxswitchbutton. In the example, the connection to SQLServer is working well and the data are correctly inserted in the jqxdropdownlist.

<html>
	<head>
		<title>Test</title>
		<link rel="stylesheet" href="jqwidgets/styles/jqx.base.css" type="text/css">
		<link rel="stylesheet" href="jqwidgets/styles/jqx.classic.css" type="text/css">
		<script type="text/javascript" src="scripts/jquery-1.11.1.min.js"></script>
		<script type="text/javascript" src="jqwidgets/jqxcore.js"></script>
		<script type="text/javascript" src="jqwidgets/jqxbuttons.js"></script>
		<script type="text/javascript" src="jqwidgets/jqxscrollbar.js"></script>
		<script type="text/javascript" src="jqwidgets/jqxdata.js"></script>
		<script type="text/javascript" src="jqwidgets/jqxlistbox.js"></script>
		<script type="text/javascript" src="jqwidgets/jqxdropdownlist.js"></script>
		<script type="text/javascript">
			$(document).ready(function () {
					// prepare the data
					var source =
					{
						datatype: "json",
						datafields: [
							{ name: 'CompanyName' },
							{ name: 'ContactName' },
							{ name: 'ContactTitle' },
							{ name: 'Address' },
							{ name: 'City' },
						],
						url: 'data.php'
					};
					var dataAdapter = new $.jqx.dataAdapter(source);
					$("#dropdownlist").jqxDropDownList(
					{
						source: dataAdapter,
						theme: 'classic',
						width: 200,
						height: 25,
						selectedIndex: 0,
						displayMember: 'CompanyName',
						valueMember: 'ContactName'
					});
				});
		</script>
	</head>
	<body>
		<div id="dropdownlist"></div>
	</body>
</html>

Then, to use the jqxswitchbutton, I will have to add:
<script type=”text/javascript” src=”jqwidgets/jqxswitchbutton.js”></script>
<script type=”text/javascript”>
$(document).ready(function () {
var label = {
‘button’: ‘Keyboard clicks’
};
$(‘#button’).jqxSwitchButton({ height: 27, width: 81, checked: false });

$(‘.jqx-switchbutton’).on(‘checked’, function (event) {
$(‘#events’).text(label[event.target.id] + ‘: OFF’);

});
$(‘.jqx-switchbutton’).on(‘unchecked’, function (event) {
$(‘#events’).text(label[event.target.id] + ‘: ON’); //how can I run the data.php here?
});
});
</script>

Then, my question is how can I run the data.php here in the $(‘.jqx-switchbutton’).on(‘unchecked’, function (event) {.. ???

Thanks in advance,
Christophe Toussaint

November 15, 2016 at 11:51 pm How can I run the code of another php page when I clcik on a jqxswitchbutton #89073

christophe.toussaint

Participant

oups, not on the good section. Sorry

November 16, 2016 at 9:18 am How can I run the code of another php page when I clcik on a jqxswitchbutton #89081

Hristo

Participant

Duplicate post: http://www.jqwidgets.com/community/topic/how-can-i-run-the-code-of-another-php-page-when-i-click-on-a-jqxswitchbutton/