Href Modal not working

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP

Href Modal not working



I am new in PHP. My href modal doesn't work perfectly.
I am working on a database search with edit items function.


href



On initial load of the datatable, the edit anchor tag should return field values in
the modal form.


datatable



However it doesn't seem to work. When I clicked the icon it didn't do anything.
I am thinking maybe there is conflict between my search queries and div ids?



Here is my code:



My code for the search query:


$sql_result = mysql_query ($sql, $conn ) or die ( "Could not execute SQL
query" .$sql);
if (mysql_num_rows($sql_result)>0) {
while ($row = mysql_fetch_assoc($sql_result)) {
$project=$row['Project'];
$id=$row['ID'];
$discipline=$row['Discipline'];
$area_code=$row['Area_Code'];
$drawingnumber=$row['Drawing_Number'];
$documenttitle=$row['Document_Title'];
$approveddate=$row['Approved_Date'];
$revnumber=$row['Revision'];
$status=$row['Status'];
$transnumber=$row['Transmittal_No'];

//table row
<tr>
<td><?php echo $project; ?></td>
<td><?php echo $discipline; ?></td>
<td><?php echo $area_code ;?></td>
<td><?php echo $drawingnumber ;?></td>
<td><?php echo $documenttitle; ?></td>
<td><?php echo $approveddate; ?></td>
<td><?php echo $revnumber; ?></td>
<td><?php echo $status; ?></td>
<td><?php echo $transnumber; ?></td>
<td><?php echo $id; ?></td>
<div class='btn-group' role='group' aria-label='...'>
<td> <a href="#edit<?php echo $id;?>" data-toggle="modal"><button type='button' class='btn btn-warning btn-sm'>Edit<span class='glyphicon glyphicon-edit' aria-hidden='true'></span></button></a></td>
</div>
</tr>



My href edit Modal:


href


<div id="edit<?php echo $id; ?>" class="modal fade" role="dialog">
<form method="post" class="form-horizontal" role="form">
<div class="modal-dialog modal-lg">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">&times;</button>
<h4 class="modal-title">Edit Item</h4>
</div>
<div class="modal-body">
<input type="hidden" name="edit_item_id" value="<?php echo $id; ?>">
<div class="form-group">
<label class="control-label col-sm-2" for="discipline">Discipline:</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="discipline" name="discipline" value="<?php echo $id; ?>" required autofocus>
</div>
<label class="control-label col-sm-2" for="area_code">Area Code:</label>
<div class="col-sm-4">
<input type="text" readonly class="form-control" id="area_code" name="area_code" value="<?php echo $area_code;?>" required>
</div>
<label class="control-label col-sm-2" for="drawingnumber">Drawing Number:</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="drawingnumber" name="drawingnumber" value="<?php echo $drawingnumber; ?>" required >
</div>
<label class="control-label col-sm-2" for="documenttitle">Document Title:</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="documenttitle" name="documenttitle" value="<?php echo $documenttitle; ?>" required >
</div>
<label class="control-label col-sm-2" for="approveddate">Approved Date:</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="approveddate" name="approveddate" value="<?php echo $approveddate; ?>" required>
</div>

<label class="control-label col-sm-2" for="revnumber">Revision Number:</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="revnumber" name="revnumber" value="<?php echo $revnumber; ?>" required >
</div>
<label class="control-label col-sm-2" for="status">Status:</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="status" name="status" value="<?php echo $status; ?>" required >
</div>
<label class="control-label col-sm-2" for="transnumber">Transmittal Number:</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="transnumber" name="transnumber" value="<?php echo $transnumber; ?>" required >
</div>
</div>
</div>
</div>
</div>
</form>
</div>





edit your code and question properly for better understanding
– Bobby Axe
54 mins ago





I edited it guys. Hope it is understandable enough.. Let me know!
– juds
38 mins ago





Cant seem to get the correct href="#edit<?php echo $id ?>
– juds
34 mins ago





What about `data-target="#edit<?php echo $id ?>"
– GGw
3 mins ago









By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Comments

Post a Comment

Popular posts from this blog

Executable numpy error

Image
Clash Royale CLAN TAG #URR8PPP Executable numpy error I'm trying to create an executable file for my code. I've already tried with cx_Freeze and with pyinstaller. Both gives me the same error, which is: "Missing required dependencies 0.format(missing_dependencies))" PS C:UsersGustavoDesktopbuildexe.win32-3.6> python AgendaOficial.py C:UsersGustavoAppDataLocalProgramsPythonPython36-32python.exe: can't open file 'AgendaOficial.py': [Errno 2] No such file or directory PS C:UsersGustavoDesktopbuildexe.win32-3.6> .AgendaOficial.exe Traceback (most recent call last): File "C:UsersGustavoAppDataLocalProgramsPythonPython36-32libsite-packagescx_Freezeinitscripts__startup__.py", line 14, in run module.run() File "C:UsersGustavoAppDataLocalProgramsPythonPython36-32libsite-packagescx_FreezeinitscriptsConsole.py", line 26, in run exec(code, m. dict ) File "AgendaOficial.py", line 8, in File "C:UsersGustavoAppDataLocal
Read more

PySpark count values by condition

Image
Clash Royale CLAN TAG #URR8PPP PySpark count values by condition I have a DataFrame, a snippet here: [['u1', 1], ['u2', 0]] basically one string ('f') and either a 1 or a 0 for second element ('is_fav'). What I need to do is grouping on the first field and counting the occurrences of 1s and 0s. I was hoping to do something like num_fav = count((col("is_fav") == 1)).alias("num_fav") num_nonfav = count((col("is_fav") == 0)).alias("num_nonfav") df.groupBy("f").agg(num_fav, num_nonfav) It does not work properly, I get in both cases the same result which amounts to the count for the items in the group, so the filter (whether it is a 1 or a 0) seems to be ignored. Does this depend on how count works? count 1 Answer 1 There is no filter here. Both col("is_fav") == 1 and col("is_fav") == 0) are just boolean expressions and count doesn't really care about their value as long a
Read more

Trying to Print Gridster Items to PDF without overlapping contents

Image
Clash Royale CLAN TAG #URR8PPP Trying to Print Gridster Items to PDF without overlapping contents I want to print gridster items to pdf using chome browser. Unfortunately the item overlaps on next page. Is there any way to make gridster item go to next page if it doesnt fit in the current page when printing to pdf? Screenshot By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Read more