Vinsanity
-
Posts
23 -
Joined
-
Last visited
Never
Posts posted by Vinsanity
-
-
i would like to knw how can i show few words(dynamic from DB) and when click on it then i will bring us to the details page of it... do i need to pass the variable or id??? can anyone help me?
-
below is the screenshot of the error...
[attachment deleted by admin] -
i have the login script which work prefectly on itself but when i try to use the frame to create the main page and call out the login function, the login doesnt work and just display out some of the php login script. even i managed to get rid of this error then the function also canot work... below will be my code... hope somebody can help... thnk you...
[attachment deleted by admin] -
my php script works prefectly when run by itself but when i try to design using the frame on the mainpage it will just show the script code instead of the program... its my login page... anyone can help me... thank you...
-
the page is running properly on the page itself but when create a main page using frame, when call the certain page to display on the mainframe then its doesnt work... it will onli show some php coding sentences but its not working...
-
i would like to know how to identify the value of it and need to display it details... becos i hav a lot of data in my table and need to know which details to display...
-
Here is my scenario:
My job portal need to allow the user to register with us, and then they are able to login using the account, and after the users are able to view all the job posts , add a new job post, and delete the job post. On the other hands, there are administrator account for administrator to login to manage the registration and job posting... they can choose to either approve or reject the registration and job post... Now i would like to take the advice from u all on how to do the database design on how many tables i need and the relationship between those table... any help will be appreciated... -
can anyone help me on this problem?i need to allow user to click on the row with highlighted and it will show the details of it... can i achieve it without the checkbox or the radio button... initially the page will onli show the key field of the table and then when user choose on one and click on it then the details page will come out...
-
i wan to create a page similiar to window explorer format and so i need to do with frames to seperate the page into two parts... the left hand side will be used to display the key fields($JobID) and when user clicked on it... the details of the key field will be displayed on the right hand frame(main page)... but when i try to write the code on the left hand frame, it run properly on itself... but when u try to run the whole page... it seems doesnt work and blank on it part... anyway if anyone can provide me with the code would be appreciated...
-
i come out with the frameset and named it as left.php , index.php and main.php but when i load the page and i found nothing appear on the left hand side... i was using php coding on the left hand frame... is it bcos of the php cause the frame load failed... anyone can help me to troubleshoot...
-
Currently i m workin on a project related to job portal and it require me to display my data on a format similiar to Window Explorer or Email format... need to display the keyword of the data on the left hand corner which i using a frame to do so and when i click on the certain keyword and on the main page the details will be shown... may i know how to do the hyperlink on the keyword the identify it...
-
i do understand with the frame method but the problem is how to make the key data possible to click and to show the details... do i need to do it with array??? bcos i wan it to be able to show the details of the certain row...
-
how to display the data similiar to window explorer format, like show the key field at the left frame and when clicked on it then the details of it will be display at the main frame... is it possible to achieve... need help from u all guys... any help will be appreciated...
-
the above code detected an error named 'undefined checkbox' and the checkbox mentioned is at the bottom of the code that [ $del_id = $checkbox[$i]; ]
can anyone list out the solution for it... -
[img]http://C:\Documents and Settings\L340C27\My Documents\My Pictures\error.bitmap[/img]
<?php
// connect and select the database
$conn = mssql_connect($host, $user, $password) or die(mssql_error());
$db = mssql_select_db($dbName, $conn) or die(mssql_error());
$sql="SELECT * FROM Job";
$result=mssql_query($sql);
$count=mssql_num_rows($result);
?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF"> </td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mssql</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">#</td>
<td align="center" bgcolor="#FFFFFF"><strong>JobID</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>JobTitle</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Location</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>CompanyName</strong></td>
</tr>
<?php
while($rows=mssql_fetch_array($result)){
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" value="<?php echo $rows['JobID']; ?>"></td>
<td bgcolor="#FFFFFF"><?php echo $rows['JobID']; ?></td>
<td bgcolor="#FFFFFF"><?php echo $rows['JobTitle']; ?></td>
<td bgcolor="#FFFFFF"><?php echo $rows['Location']; ?></td>
<td bgcolor="#FFFFFF"><?php echo $rows['CompanyName']; ?></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input type="submit" name="delete" value="Delete"></td>
</tr>
<?php
//Check if delete button active, start this
if(isset($_POST['delete'])){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM Job WHERE JobID='$del_id'";
$result = mssql_query($sql);
}
if($result){
//echo "<meta http-equiv=\"refresh\" content=\"0;URL=DeleteJ.php\">";
}
}
mssql_close($conn);
?>
</table>
</form>
</td>
</tr>
</table>
-
Can anyone provide me the sources or codes for the delete function using the checkbox... it can be a very simple delete using checkbox since i m a newbie of php... I got these fields in my database(JobID, JobTitle, JobRequirement, Location, JobStatus and CompanyName) and i wan to delete the certain rows when i checked the row and click on the delete button... Can anybody help me... Any help will be appreciated...
-
how to identify the checkbox related with the row... any soft code can refer to???is array needed here???
-
I m new to php and i would like to know how to delete the rows using checkboxes... after checked on the checkbox and follow by a DELETE button then the certain row will be deleted in the database... i m using dreamweaver to come out with the UI... anyone can help me?
-
Is it possible to display out the certain field of a table and when clicked on It and it will show out all the details of the certain field... Any way to achieve this in php... Help needed...
Display the details
in PHP Coding Help
Posted