|
PHP - Click On Link To Display Dropdown Help Needed Pls
how can i do this pls?
i just want to display a link "Free Chat" when i click on it, it must display a dropdown with options "yes" and "no" the link must not go anywhere yet, only when yes is selected it must go to a page i have the code: Code: [Select] <a href="" id="link" name="link" onClick="yesnolist(1)">Free Chat</a> then i have javascript: Code: [Select] <script type="text/JavaScript"> function yesnolist() { var e = document.getElementById("link"); var strUser1 = e.options[e.selectedIndex].value; if (strUser1 == "1") { window.location.href = "http://........."; } return strUser1; } </script> the above is not correct, can some-one help me please? thanks Similar Tutorialshey there peoples i have a bit of a problem with my php code. when i click on the name it wont play the video. but if i click on the thumbnail it plays here is the code Code: [Select] echo "<div class='Video_thumbnail'>"; echo "<a href='/Video.php?id={$row['id']}'>"; echo "<img src='http://i.ytimg.com/vi/{$row['link']}/hqdefault.jpg' width='220' height='170' alt='click' /></a>"; echo "<br>"; echo "</br>"; echo "<a href='/Video.php?={$row['id']}'>"; echo "{$row['navn']}</a>"; echo "</div>"; Hi All, I am trying create 4 dropdowns and load the values based on the value selected in the previous dropdown. I am able to do this for 3 dropdowns, but for the fourth dropdown I am no able to populate the value. Could someone help me out with this please? --------------------------------------- ajaxData_1.php
<?php
// Include the database config file
include_once 'dbconfig_1.php';
if(!empty($_POST["solutions_id"])){
// Fetch state data based on the specific country
$query = "SELECT * FROM releases WHERE solutions_id = ".$_POST['solutions_id'];
$result = $db->query($query);
if($result->num_rows > 0){
echo '<option value="">Select release</option>';
while($row = $result->fetch_assoc()){
echo '<option value="'.$row['releases_id'].'">'.$row['releases_name'].'</option>';
}
}
else{
echo '<option value="">Release not available</option>';
}
}
elseif(!empty($_POST["releases_id"])){
$query = "SELECT * FROM versions WHERE releases_id = ".$_POST['releases_id']."";
$result = $db->query($query);
if($result->num_rows > 0){
echo '<option value="">Select version</option>';
while($row = $result->fetch_assoc()){
echo '<option value="'.$row['version_id'].'">'.$row['supported_version'].'</option>';
}
}
else{
echo '<option value="">Version not available</option>';
}
}
elseif(!empty($_POST["versions_id"]))
{
$query = "SELECT * FROM platforms WHERE version_id = ".$_POST['version_id']."";
$result = $db->query($query);
if($result->num_rows > 0){
echo '<option value="">Select Version</option>';
while($row = $result->fetch_assoc()){
echo '<option value="'.$row['platforms_id'].'">'.$row['platforms_name'].'</option>';
}
}
else{
echo '<option value="">Platform not available</option>';
}
}
?>
<?php
if(isset($_POST['submit']))
{
echo 'Selected Solution ID: '.$_POST['solution'];
echo 'Selected Release ID: '.$_POST['release'];
echo 'Selected Version ID: '.$_POST['version'];
echo 'Selected Platform ID: '.$_POST['platform'];
}
?>
Index_3.php
<!DOCTYPE html>
<html>
<head>
<title style="color: 000000">Solution Compatibility Matrix</title>
<style>
select
{
padding: 12px;
min-width:280px;
margin-top:10px;
}
.san{
width:280px;
margin:0 auto;
margin-top:90px;
background-color:#FFFFFF;
padding:55px;
color: 000000;
}
label
{
color:#000000;
margin-bottom:25px;
}
html{
background-color: #3399CC;
}
</style>
</head>
<body>
</body>
</html>
Thanks, Arun Edited April 23, 2020 by cyberRobotAdded code tags i have this simple table browse get me the filter let say 15 items of a table of 74 but after i click in the link forward the filter erase and disply me the all records... waht im doing wrong.... TNX in advance <img src="images/misc/search.JPG" width="367" height="100" /> <br /> <?php $strng = $_POST['search:strng']; $separa = "%"; $all = $separa.$strng.$separa; $mensaj="U Look for : "; $mensaj2=$mensaj.$stng; $regis=" u search get :"; $regis2=" Items"; $conn = mysql_connect('localhost','zerocctv_Admin','password') or trigger_error("almacen", E_USER_ERROR); $db = mysql_select_db('zerocctv_almacen',$conn) or trigger_error("almacenz", E_USER_ERROR); $sql = "SELECT COUNT(*) FROM modelos where descrip like '$all'"; $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR); $r = mysql_fetch_row($result); $numrows = $r[0]; $rowsperpage = 10; $totalpages = ceil($numrows / $rowsperpage); // get the current page or set a default if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) { $currentpage = (int) $_GET['currentpage']; } else { $currentpage = 1; } if ($currentpage > $totalpages) { $currentpage = $totalpages; } if ($currentpage < 1) { $currentpage = 1; } $offset = ($currentpage - 1) * $rowsperpage; $sql = "SELECT modelo, paginal,precio,foto FROM modelos where descrip like '$all' LIMIT $offset, $rowsperpage"; $result = mysql_query($sql, $conn) or trigger_error("SQLkk2", E_USER_ERROR); echo $Mensaj2 ; echo $regis. $numrows . $regis2 ; echo "<table width=\50%\ border=\1\ bordercolor=\#0033FF\ cellspacing=\1\">" ; while ($list = mysql_fetch_assoc($result)) { echo "<tr>"; echo "<td>><font color='red'>" . $list['model'] . "</font></td>"; echo "<td><font color='black'>" . $list['pagl'] . "</font></td>"; echo "<td><font color='black'>" . $list['prize'] . "</font></td>"; echo "<td><font color='black'>" . $list['pict'] . "</font></td>"; echo "<tr></tr>"; echo "</tr>"; } echo "</table>"; //****** build the pagination links ******/ $range = 3; if ($currentpage > 1) { echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> "; $prevpage = $currentpage - 1; echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> "; } for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) { if (($x > 0) && ($x <= $totalpages)) { if ($x == $currentpage) { echo " [<b>$x</b>] "; } else { echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> "; } } } if ($currentpage != $totalpages) { $nextpage = $currentpage + 1; echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> "; echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> "; } ?> Every other time a user/users click on a link I want the link to change to a different url the next time a user clicks onto that link.
For example two links
url1.html
url2.html
url1.html shows up when a user clicks that link the link auto changes to then when a new user clicks the linke url2.html then back to url1.html and so on?
Don't know where to start on how I would do this let alone have the server remember to keep which ever link to be held for the next user?
Hi all I need some help, i have a list of orders on the left column and want to click on each order and display related db information in the right column in a div or other method for each record click. screenshot attached.
Hello,
I am using this collapse menu from bootstrap:
http://getbootstrap....cript/#collapse
What I did is instead of putting text in the content section I added many links. The links only show up when one of the menu link is clicked.
Now my problem is that in one of the menu sub, there are about 30 links, therefore the user has to go down the page to see the content.
Is there a way to have the menu collapsing on itself when a link is clicked please? Like a reset to reset it like on page load
Thanks all,
Ben
Folks, When someone click on a link on my webpage and if that Link takes the visitor off my site, then i want to make an entry in my database. But if that link goes back to some other link in my Site then i do not want to Count that link. So, is there any code that lets me detect any outgoing link Click? Cheers I'm working on a fix for cURL that replaces all relative urls with absolute. Here's the code: <?php //Get web address //FORMAT: url=site.com, url=site.net, url=site.org $page = $_GET['url']; //Format web address $http = 'http:\/\/'; $www = 'www.'; if(preg_match('/'.$http.'/', $page)){preg_replace('/'.$http.'/', '', $page);} if(preg_match('/'.$www.'/', $page)){preg_replace('/'.$www.'/', '', $page);} $page = rtrim($page, '/'); $page = 'http://www.'.$page.'/'; //cURL // create curl resource $ch = curl_init(); // set url curl_setopt($ch, CURLOPT_URL, $page); //return the transfer as a string curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); // $output contains the output string $output = curl_exec($ch); // close curl resource to free up system resources curl_close($ch); //Convert relative URL to absolute $output = preg_replace('/src="/', 'src="'.$page, $output); $output = preg_replace('/href="/', 'href="'.$page, $output); $output = preg_replace('/action="/', 'action="'.$page, $output); echo $output; ?> As you can see it's pretty basic. In many cases it fixes broken styles, links, images and form actions. I am looking for any ideas as to how I can add some more intelligence to this script. 1. What else should it do 2. Where is it not doing it's job 3. Can it do what it's already doing better Any input offered is much appreciated. I'm not looking for someone to write code, but if you are intrigued and want to add a snippet to it, that's cool! Feel free to keep a copy of your own if you like the idea to build off of. Thanks Peeps, E This is actually a page to edit the drama details. Database- 3 tables 1. drama dramaID drama_title 1 friends 2. drama_genre drama_genreID dramaID genreID 1 1 2 2 1 1 3 1 3 3. genre genreID genre 1 comedy 2 romance 3 family 4 suspense 5 war 6 horror <?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = ''; $dbname = 'drama'; $link = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or trigger_error('Error connecting to mysql'); $id = $_GET['dramaID']; $link2 = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or trigger_error('Error connecting to mysql'); $sql2 = "SELECT * from drama , drama_genre , genre WHERE drama.dramaID='".$id."' AND drama_genre.dramaID='".$id."' AND drama.dramaID = drama_genre.dramaID AND drama_genre.genreID = genre.genreID"; $status2 = mysqli_query($link2,$sql2) or die (mysqli_error($link2)); $link3 = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or trigger_error('Error connecting to mysql'); $sql3 = "SELECT * from genre "; $status3 = mysqli_query($link3,$sql3) or die (mysqli_error($link3)); <form method='Post' action='doUpdate.php' enctype="multipart/form-data"> <?php while ($row2 = mysqli_fetch_assoc($status2)) { ?> <td height="1"></td> <td><select name="gdrop"> <option value="<?php echo $row2['genreID'];?>"><?php echo $row2['genre'];?></option> <?php while ($row3 = mysqli_fetch_assoc($status3)) { ?> <option value="<?php echo $row3['genreID'];?>"><?php echo $row3['genre'];?></option> <?php } mysqli_close($link3); ?> <input type='hidden' id='drama_genreID' name='drama_genreID' value = "<?php echo $row2['drama_genreID']; ?>"/> </select> <input type="hidden" id="dramaID" name="dramaID" value = "<?php echo $row['dramaID'];?>"/> <input type="submit" Value="Update"/> The result was there were 3 dropdown menus but only the first dropdown menu has all 6 genres from my database and also the genre that belongs to the drama. I'm also wondering how I can bring all the drama_genreIDs to my save(doupdate.php) page and update all 3 of them because it seems like only the last dropdown menu's data is saved. And also how can I display only 6 genres instead of 7 with the genre that belongs to the drama , being set as the default selection. Hello to all. I'm new here and i am very glad to be a part of this community. I am new in PHP/mysql but i try to learn as much as i can in php & mysql. And here is the problem: Into a php or html page i want to display 2 dropdown list to act as a filter for displaying a table. I managed to display a table based on option select from first dropdown but i don'y know how to make or activate the second dropdown list to act as a filter, and when i press "result" to display on the same page the results. Thanks a lot. My code: Code: [Select] <?php $username = $_SESSION['loggedin']; $extract_user_rank = mysql_query("SELECT `rank` FROM users WHERE username='$username'"); if($extract_user_rank['rank'] > 0) { echo "<a href='control_panel.php'>Admin Control Panel</a>"; } else { //return nothing } ?> I have my rank in the database set to 1. Why doesn't it output the ACP link? I wanted to store a link in the db and display the same link on the front end which will take me to the site. i tried with href but i get some string error. Also i wanted to add a youtube embed tag to display it again on query to the db. in short is possible to store the url in the db and display the same url. thanks Greetings! I have a website www.lanceronlinejobs.com/our_franchises.php I have a franchise images. I want to display each franchise record from database whenever a user click on franchise link. Here is my code. ourfranchises.php code: Code: [Select] <?php include('fconnection.php'); $sql = mysql_query("SELECT * FROM tbl_franchise ORDER BY id DESC") or die(mysql_error()); $row3 = mysql_fetch_array($sql); ?> <a href="franchiseDetails.php?city=<?php echo $row3['city'];?>"><img src="images/lbatkhela.jpg" width="150" height="150" alt="Batkhela" /></a>---------------------------------------------------------------------- franchiseDetails.php code: Code: [Select] <?php $id = $_GET['id']; $query = "SELECT * FROM tbl_franchise WHERE id = '$id' ORDER BY id DESC LIMIT 1"; $result = mysql_query($query); if (!$result) { echo "NO RECORD FOUND"; } else { while($row3 = mysql_fetch_array($result)): ?> Manager Name: <?php echo $row3['manager_name'];?> Please help me. Any help would be appreciated. Thanks. I have a "Members" page that displays my organizations members info via My SQL. Currently, the database displays "State" quick links at the top and has the members organized by State down the page. If you click on one of the State links at the top, it will navigate to the section of the page with that state and associated members. I want the members associated with a specific state to be displayed only once I click the associated state link -- instead of all of the information showing at once like it is now. The page I am referring to can be seen at this link: http://homesforhorse...rs.com/members/
<?php
update_option('image_default_link_type','none');
include("/home/cingen/config_admin.php");
function listMembers() {
$sql = mysql_query("SELECT c.*, s.*
FROM (".TABLE_MEMBERS." c LEFT JOIN ".TABLE_STATE." s on c.state = s.state_abbr)
WHERE c. status = '1'
ORDER BY c.country, c.state, c.organization ASC");
while ($row = mysql_fetch_array($sql)) {
$display_members = false;
$organization = stripslashes($row['organization']);
$website = stripslashes($row['website']);
if ($website) {
$link = "<a href='http://".$website."' target='_blank'>";
$endlink = "</a>";
} else {
$link = "";
$endlink = "";
}
$display_members .= $link.$organization.$endlink."<br />";
if ($row['address']) $display_members .= stripslashes($row['address'])." ".stripslashes($row['address2'])."<br />";
if ($row['city']) $display_members .= stripslashes($row['city']).", ";
if ($row['state']) $display_members .= stripslashes($row['state'])."";
if ($row['zip']) $display_members .= " ".$row['zip'];
$display_members .= "<br />";
if ($row['contact_name']) $display_members .= "Contact: ".stripslashes($row['contact_name']);
if ($row['contact_title']) $display_members .= ", ".stripslashes($row['contact_title']);
if ($row['phone']) $display_members .= "<br />Tel: ".stripslashes($row['phone']);
if ($row['email']) $display_members .= "<br />".$row['email'];
if ($row['website']) $display_members .= "<br /><a href='http://".$row['website']."' target='_blank'>".$row['website']."</a><br/>";
if ($row['year_est']) $display_members .= "Founded in ".$row['year_est'].".";
if ($row['org501c3'] == "1") $display_members .= " A 501(c)3 non-profit.";
if ($row['gfas'] == "1") $display_members .= "<br />GFAS: Accredited Sanctuary.";
if ($row['gfas'] == "2") $display_members .= "<br />GFAS: Verified Sanctuary.";
if ($row['member_category']) $display_members .= "<br />".$row['member_category'];
$display_members .= "<br /><br />";
$entries[$row['country']][$row['state_name']][] = $display_members;
}
$countrylinks = false;
$statelinks = false;
$display = false;
if(is_array($entries)){
$display .= '
<div class="memberlist">';
foreach($entries as $country=>$state_members){
$countrylinks .= '<a href="#'.$country.'">'.$country.'</a> ';
$display .= '
<h2 id="'.$country.'">'.strtoupper($country).'</h2>
<div class="country">';
if(($state_members)){
foreach($state_members as $state=>$members){
$statelinks .= '<a href="#'.$state.'">'.$state.'</a> ';
$display .= '
<h3 id="'.$state.'">'.strtoupper($state).'</h3>
<div class="state">';
if(is_array($members)){
foreach($members as $key=>$member){
$display .= '
<div class="member">
'.$member.'
</div>';
}
}
$display .= '
</div>';
}
}
$display .= '
</div>';
}
$display .= '
</div>';
}
$statelinks1 = '
<h2>Members List</h2>
<strong>Quick Links</strong><br /><br />
'.$statelinks.'<br /><br />'
.$display;
return $statelinks1;
}
add_shortcode('memberlist', 'listMembers');
function listRescueStandards() {
$display_members = '';
$sql = mysql_query("SELECT vc.*, s.*, m.*
FROM ".TABLE_COMPLIANCE." vc, ".TABLE_STATE." s, ".TABLE_MEMBERS." m
WHERE vc.member_id = m.cid
AND m.status = '1'
AND m.state = s.state_abbr
ORDER BY m.state, m.organization ASC");
while ($row = mysql_fetch_array($sql)) {
$organization = stripslashes($row['organization']);
if ($row['website']) {
$link = "<a href='http://".$row['website']."' target='_blank'>";
$endlink = "</a>";
} else {
$link = "";
$endlink = "";
}
if($x!=$row['state_name']){
$display_members .= "<br /><strong>".strtoupper($row['state_name'])."</strong><br />";
$x = $row['state_name'];
}
$display_members .= $link.$organization.$endlink."<br />
".stripslashes($row['address'])." ".stripslashes($row['address2'])."<br />
".stripslashes($row['city']).", ".stripslashes($row['state'])." ".$row['zip']."<br />";
if ($row['contact_name']) $display_members .= "Contact: ".stripslashes($row['contact_name']);
if ($row['contact_title']) $display_members .= ", ".stripslashes($row['contact_title']);
if ($row['phone']) $display_members .= "<br />Tel: ".stripslashes($row['phone']);
if ($row['fax']) $display_members .= "<br />Fax: ".stripslashes($row['fax']);
if ($row['email']) $display_members .= "<br />".$row['email'];
if ($row['website']) $display_members .= "<br /><a href='http://".$row['website']."' target='_blank'>".$row['website']."</a>";
if ($row['year_est']) $display_members .= "<br />Founded in ".$row['year_est'].".";
if ($row['org501c3'] == "1") $display_members .= "<br />This organization IS registered with the IRS as a 501(c)3.";
if ($row['org501c3'] != "1") $display_members .= "<br />This organization is NOT registered with the IRS as a 501(c)3.";
$display_members .= "<br /><br />";
}
return "<div class='memberlist'>" . $display_members . "</div>";
}
add_shortcode('standardslist', 'listRescueStandards');
Hello guys, I want to make an xml feed into my webpage, but the xml is generated from an .asp file on another website, so it's not actually an xml file, but xml output. Now, I want to retrieve this xml output on my webpage, but I'm having difficulties while doing this. What I've tried so far: - With PHP: Code: (php) [Select] <?php echo file_get_contents("http://link-on-other-website.asp?XML=1"); ?> - With javascript: Code: (javascript) [Select] <script type="text/javascript"> if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.open("GET","http://link-on-other-website.asp?XML=1", false); xmlhttp.send(); xmlDoc=xmlhttp.responseXML; document.write("<table border='1'>"); var x=xmlDoc.getElementsByTagName("RECORD"); for (i=0;i<x.length;i++) { document.write("<tr><td>"); document.write(x[i].getElementsByTagName("NAME")[0].childNodes[0].nodeValue); document.write("</td><td>"); document.write(x[i].getElementsByTagName("DATE")[0].childNodes[0].nodeValue); document.write("</td></tr>"); } document.write("</table>"); </script> When using the PHP code, I can retrieve it obviously, but I get an <?xml ... > declaration within my body, which is not allowed. When using the Javascript code, I can't even retrieve anything. And the goal is to style this xml output to match my website. That's the whole purpose of this xml link, because I couldn't style the iframe I had earlier. Can someone help me on this, on how to properly embed this asp generated xml output, within my HTML5 document? ps: I've asked for the xml-feed link from that other website, so using the above PHP code is legit in my case. Trying to figure out how to make it so name is a link to the profile when its echo anyone know how to do this? im at a huge stand still Code: [Select] <?php $sql = "SELECT name FROM users WHERE DATE_SUB(NOW(),INTERVAL 5 MINUTE) <= lastactive ORDER BY id ASC"; $query = mysql_query($sql) or die(mysql_error()); $count = mysql_num_rows($query); $i = 1; while($row = mysql_fetch_object($query)) { $online_name = htmlspecialchars($row->name); echo '<a href="Inbox.php">"'[$goauld]'</a>"'; ?> This is my script I want to display but it does not show in the page just blank. <td><object width="220" height="148"><param name="movie" value="http://www.youtube.com/user/THEWORLDOFTRAVEL#p/search/2/uX9nd3xM_MY=1&h1=enUS&color1=0x234900&color3=34900&"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/user/THEWORLDOFTRAVEL#p/search/2/uX9nd3xM_MY=1&h1=enUS&color1=0x234900&color3=34900&" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="220" height="148"></embed></object></td> I am having problems understanding the reason for why the user has to click logout twice, here's the bulk of the code: <?php ini_set('display_errors',0); require_once 'header.html'; require_once 'db.functions.php'; require_once 'config.php'; $database = dbConnect($host, $username, $password, $database); // should output 1 or nothing at all! if($database == true) { // now connected? // carry on with logic of outputting the blog contents: $result = entries("SELECT * FROM entries"); printf("<table>"); while($row = mysql_fetch_array($result)) { printf(" <tr> <td>%s</td> <td>%s</td> </tr> <tr> <td colspan=\"2\">%s</td> </tr> ", $row[2], $row[4], $row[3]); } printf("</table>"); printf("\n\n"); session_name("jeremysmith_blog"); session_start(); if(array_key_exists('login',$_SESSION)) { if($_SESSION['login'] == 1) // change this to correspond with session on the login.php script { printf("<p>Welcome %s</p> <p>To logout, click <a href=\"index.php?action=logout\">here</a></p> ",$_SESSION['username']); } } else { printf("<p>You are not logged in, please click <a href=\"login.php\">here</a> to login.</p>"); } } else { printf("\n<p id=\"error\">Could not connect to database, please try again later.</p>"); } // init the logout script? if(array_key_exists('action',$_GET)) { if($_GET['action'] == 'logout') { // log user out of the system: unset($_SESSION['login']); unset($_SESSION['username']); session_destroy(); } } printf("\n"); // just for output format! require_once 'footer.html'; Why does the user have to click logout twice, have I missed anything? Any helps appreciated thanks. I have a form with dropdown list that is populated with values from Sql Server table. Now i would like to use this selected item in SQL query. The results of this query should be shown in label or text field. So when a user selects item from dropdown menu, results from SQL query are shown at the same time. I have two dropdown list at the moment in my form. First one gets all values from a column in table in SQL Server. And the second one should get a value from the same table based on a selection in first dropdown list.
When i load ajax.php i get 2 error mesages: This is my code so far. I have tried to do it with this Ajax script. But i can only get first dropdown to work. The second dropdown(sub_machinery) does not show values, when first dropdown item is selected. The second dropdown should show values from databse table with this query( *$machineryID* is first dropdown selected item): SELECT MachineID FROM T013 WHERE Machinery=".$machineryID. Index.php
<!doctype html>
<?PHP
$server = "server";
$options = array( "UID" => "user", "PWD" => "pass", "Database" =>
"database");
$conn2 = sqlsrv_connect($server, $options);
if ($conn2 === false) die("<pre>".print_r(sqlsrv_errors(), true));
echo " ";
?>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<section id="formaT2" class="formaT2 formContent">
<div class="row">
<div class="col-md-2 col-3 row-color remove-mob"></div>
<div class="col-md-5 col-9 bg-img" style="padding-left: 0;
padding-right: 0;">
<h1>Form</h1>
<div class="rest-text">
<div class="contactFrm">
<p class="statusMsg <?php echo
!empty($msgClass)?$msgClass:''; ?>"><?php echo $statusMsg; ?></p>
<form action="connection.php" method="post">
<div>machinery</div>
<select id="machinery">
<option value="0">--Please Select Machinery--</option>
<?php
// Fetch Department
$sql = "SELECT Machinery FROM T013";
$machanery_data = sqlsrv_query($conn2,$sql);
while($row = sqlsrv_fetch_array($machanery_data) ){
$id = $row['Id'];
$machinery = $row['Machinery'];
// Option
echo "<option value='".$id."' >".$machinery."</option>";
}
?>
</select>
<div class="clear"></div>
<div>Sub Machinery</div>
<select id="sub_machinery">
<option value="0">- Select -</option>
</select>
<input type="submit" name="submit"
id="submit" class="strelka-send" value="Insert">
<div class="clear"> </div>
</form>
</div>
</div>
</div>
</div>
</section>
</script>
<script type="text/javascript">
$(document).ready(function(){
$("#machinery").change(function(){
var machinery_id = $(this).val();
$.ajax({
url:'ajaxfile.php',
type: 'post',
data: {machinery:machinery_id},
dataType: 'json',
success:function(response){
var len = response.length;
$("#sub_machinery").empty();
for( var i = 0; i<len; i++){
var machinery_id = response[i]['machinery_id'];
var machinery = response[i]['machinery'];
$("#sub_machinery").append("<option
value='"+machinery_id+"'>"+machinery+"</option>");
}
}
});
});
});
</script>
</body>
</html>
Ajaxfile.php
<?php
$server = "server";
$options = array( "UID" => "user", "PWD" => "pass",
"Database" => "database");
$conn2 = sqlsrv_connect($server, $options);
if ($conn2 === false) die("<pre>".print_r(sqlsrv_errors(), true));
echo " ";
$machineryID = $_POST['machinery']; // department id
$sql = "SELECT MachineID FROM T013 WHERE Machinery=".$machineryID;
$result = sqlsrv_query($conn2,$sql);
$machinery_arr = array();
while( $row = sqlsrv_fetch_array($result) ){
$machinery_id = $row['ID'];
$machinery = $row['MachineID'];
$machinery_arr[] = array("ID" => $machinery_id, "MachineID" =>
$machinery);
}
// encoding array to json format
echo json_encode($machinery_arr);
?>
Edited May 6, 2019 by davidd
|
|||||||