Symbianize Forum
Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok dito
- Thread starter nitzgamz
- Start date
- Replies 3,912
- Views 214,219
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
The best way to do that is via storing session messages and via flags.
Dun sa registration process mo,
alam mo naman siguro mga input checks, validates,etc.
Ex:
if username already exist
{
session['message'] = "username already exist";
header(location: registration.php);
}
if succesfull
{
session['message'] = "Registered succesfully";
header(location: registration.php);
}
tas dun naman sa registration page mismo
display mo na yung session message.
session_start();
echo session['message'];
session_destroy['messages'];
kung gusto mo magdisplay ng multiple notifiations, like fill all the fields, password mismatch,etc..
All you have to do is use flags and array mo yung mga messages.
Note: wrong syntax yang mga codes na yan, kaw nalang magayos, just giving you idea. Nakamobile kasi ako now eh, tsaka lagi kung nakakalimutan mga syntax ng mga PL na gamit ko lol.. XD
The best way to do that is via storing session messages and via flags.
Dun sa registration process mo,
alam mo naman siguro mga input checks, validates,etc.
Ex:
if username already exist
{
session['message'] = "username already exist";
header(location: registration.php);
}
if succesfull
{
session['message'] = "Registered succesfully";
header(location: registration.php);
}
tas dun naman sa registration page mismo
display mo na yung session message.
session_start();
echo session['message'];
session_destroy['messages'];
kung gusto mo magdisplay ng multiple notifiations, like fill all the fields, password mismatch,etc..
All you have to do is use flags and array mo yung mga messages.
Note: wrong syntax yang mga codes na yan, kaw nalang magayos, just giving you idea. Nakamobile kasi ako now eh, tsaka lagi kung nakakalimutan mga syntax ng mga PL na gamit ko lol.. XD
Last edited:
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
Teacher ba gagamit ng system mu sir?
Naku!mukhang mahihirapan sila, kasi yung tita kong teacher, ever grading period napupuyatan sa pagttype ng grading sheet niya sa excell, yun yung pinapasa nila sa registrars office.
Pag admin naman gagamit, mas lalong mahirap, kasi every grading record siya na magiinput.
Sa system ko, ang ginawa ko, iupload lang yung grading sheet in xls format sa system, tas yung system na bahalang magsave sa datase yung mga laman sa grading sheet. Tas after msave sa datase, yung teacher meron na siyang option to edit the grades individualy incase may mali. That way mas mapapabilis yung process, less effort pa.
mga sir patulong naman, paki pansin naman po..
ang recommendation kasi is, makapag add ng grade continuously
eto po ginawa ko code
galing sa db,
Code:<?php $query = mysql_query("select * from students, stud_subject, tc_handle where tc_handle.secid = stud_subject.secid and tc_handle.sid = '$_SESSION[sid]' and tc_handle.sub_id = '$_GET[view]' and students.id = stud_subject.id and stud_subject.sub_id = tc_handle.sub_id and stud_subject.remark=''"); while ($row = mysql_fetch_array($query)){ ?> <form action="tc_addall.php" method="post"> <?php $f_name = $row['lastname'].' , '.$row['firstname'].$row['middlename'].'<br>'; echo '<p class="name">'.$f_name.'</p>'; echo $row['id']; ?> <p class="oo"> <input name="fg[]" type="text" id="fg[]" size="1"/> <input name="sg[]" type="text" id="sg[]" size="1"/> <input name="tg[]" type="text" id="tg[]" size="1"/> <input name="forg[]" type="text" id="forg[]" size="1"/> </p> <?php $a=$a+1;}?>
at eto po ung save ko, ---- problema po pano po ba?
Code:<?php if(isset($_POST['save'])) { $g_year['acad_id']; $fg=$_POST['fg']; $sg=$_POST['sg']; $tg=$_POST['tg']; $forg=$_POST['forg']; for($i=0;$i<count($fg) && $i<count($sg) && $i<count($tg) && $i<count($forg);$i++){ $first = $fg[$i]; $sec = $sg[$i]; $tir = $tg[$i]; $for = $forg[$i]; $f_subj=mysql_query("select * from tbl_grades where firstgrading='$first' && secondgrading='$sec' && thirdgrading='$tir' && fourthgrading='$for'")or die(mysql_error()); $g_subj=mysql_fetch_array($f_subj); if($g_subj==0) { mysql_query("insert into tbl_grades set firstgrading='$fg', secondgrading='$sg', thirdgrading='$tg', $fourthgrading='$for'")or die (mysql_error()); } } } ?>
Teacher ba gagamit ng system mu sir?
Naku!mukhang mahihirapan sila, kasi yung tita kong teacher, ever grading period napupuyatan sa pagttype ng grading sheet niya sa excell, yun yung pinapasa nila sa registrars office.
Pag admin naman gagamit, mas lalong mahirap, kasi every grading record siya na magiinput.
Sa system ko, ang ginawa ko, iupload lang yung grading sheet in xls format sa system, tas yung system na bahalang magsave sa datase yung mga laman sa grading sheet. Tas after msave sa datase, yung teacher meron na siyang option to edit the grades individualy incase may mali. That way mas mapapabilis yung process, less effort pa.
- Messages
- 399
- Reaction score
- 0
- Points
- 26
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
Attached files modified.
Sir, question are you the one who made this codes?
Other than that, just run this codes. I never run it. I just code it. Hahaha. You can just debug. Base on your codes I guess that's what you wanted. Please see attachment.
Don't forget to view your server logs for errors for easier debugging.
Attached files modified.
Sir, question are you the one who made this codes?
Other than that, just run this codes. I never run it. I just code it. Hahaha. You can just debug. Base on your codes I guess that's what you wanted. Please see attachment.
Don't forget to view your server logs for errors for easier debugging.
- Messages
- 354
- Reaction score
- 0
- Points
- 26
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
subscribed na nga rin ako rito hehe
subscribed na nga rin ako rito hehe
- Messages
- 171
- Reaction score
- 0
- Points
- 26
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
first, salamat po sa pag pansin nito...
teacher po ang gagamit nito, pero mas madali lang po ATA gusto ko gawin at mangyari,
Teacher iupload niya lang ung mga grades ng students na COMPUTED na po, viewing lang po si student...
sir pwede penge sample on how to do that po
i still got no idea pa po!
first, salamat po sa pag pansin nito...
teacher po ang gagamit nito, pero mas madali lang po ATA gusto ko gawin at mangyari,
Teacher iupload niya lang ung mga grades ng students na COMPUTED na po, viewing lang po si student...
sir pwede penge sample on how to do that po
i still got no idea pa po!
- Messages
- 171
- Reaction score
- 0
- Points
- 26
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
sir penge naman po ako simple TUT on how to upload that excel file to my page, thanks!!!!
sir penge naman po ako simple TUT on how to upload that excel file to my page,
thanks!!!!Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
ganun din po isang function ng system ko.. Upload ng teachers yung computed grades, eg. Midterms and finals. Tas pwede na siyang iview ng student.
Search for phpexcell, andun na din mismo yung tutorial.
first, salamat po sa pag pansin nito...
teacher po ang gagamit nito, pero mas madali lang po ATA gusto ko gawin at mangyari,
Teacher iupload niya lang ung mga grades ng students na COMPUTED na po, viewing lang po si student...
sir pwede penge sample on how to do that po
ganun din po isang function ng system ko.. Upload ng teachers yung computed grades, eg. Midterms and finals. Tas pwede na siyang iview ng student.
Search for phpexcell, andun na din mismo yung tutorial.
- Messages
- 290
- Reaction score
- 0
- Points
- 26
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
Boss pahelp po!!
Paano po bah e.delete record ko sa database ko,.Eto code ko ayaw gumana eh.
<?php
require('config.php'); //---- include the configuration file
/***********************************
* Open a query, abort program when query fails else return recordset
************************************/
function openQry($sql)
{
$rst = mysql_query($sql);
if (!$rst)
die("Unable to open ".$sql." ".mysql_error());
else
return $rst;
}
$connect = mysql_connect($dbhost, $dbuser, $dbpass);
if (!$connect)
die("Unable to connect ".$dbhost." ".mysql_error());
$db = mysql_select_db($dbname,$connect);
if (!$db)
die("Unable to open ".$dbname." ".mysql_error());
if (!isset($_GET['fish_id'])) {
die("The parameter fish_id is not specified");
}
// additional code...
$fish_id=$_GET[fish_id];
$division=$_GET[division];
$order=$_GET[order];
$family=$_GET[family];
$sci_name=$_GET[sci_name];
$author=$_GET[author];
$en_name=$_GET[en_name];
$description=$_GET[description];
if (isset ($_GET['delete'])){
$delete="DELETE FROM table1, table2, table3
USING identification table1, information table2, fish_pic table3
WHERE (table1.fish_id= table2.fish_id AND table1.fish_id=table3.fish_id AND table1.fish_id = '$fish_id')";
$row3=OpenQry($delete);
}
$qry ="SELECT
`identification`.`fish_id`,
`identification`.`division`,
`identification`.`order`,
`identification`.`family`,
`identification`.`sci_name`,
`identification`.`author`,
`identification`.`en_name`,
`order_list`.`order_name`,
`division_list`.`division_name`,
`family_list`.`family_name`
FROM
`identification`
Inner Join `division_list` ON `division_list`.`division_code` = `identification`.`division`
Inner Join `family_list` ON `family_list`.`family_code` = `identification`.`family`
Inner Join `order_list` ON `order_list`.`order_code` = `identification`.`order`
WHERE
`identification`.`fish_id`= '".$fish_id."'";
$result = openQry($qry);
$row = mysql_fetch_array($result);
$sql = "SELECT
`information`.`entry`,
`identification`.`fish_id`,
`info_list`.`info_label`
FROM
`identification`
Inner Join `information` ON `identification`.`fish_id` = `information`.`fish_id`
Inner Join `info_list` ON `info_list`.`info_code` = `information`.`info_code`
WHERE
`identification`.`fish_id` = `information`.`fish_id` AND
`identification`.`fish_id` ='".$fish_id."'";
$result = openQry($sql);
//$row3 = mysql_fetch_array($result);
if (!$row)
die("<fieldset><center>Record Deleted</center></fieldset>");
?>
<html>
<head>
<title>Delete List</title>
<link href="style.css" type="text/css" rel="stylesheet">
</head>
<body class='pop'>
<style type="text/css">
<!--
.odd {background-color:green}
.even {background-color:green}
.foot {background-color:green}
//-->
</style>
<center>
<table>
<form name=List method=GET action="<?php echo $PHP_SELF; ?>">
<input type="hidden" name="fish_id" value="<?php echo $fish_id; ?>">
<table width=80% border=2 id='popbod'>
<tr height=10 bgcolor="blue"><td valign=middle align=center colspan="4">
<input type="button" value="Close"
onclick="window.close()"></tr>
</table>
<table width=80% border=2 id='popbod'>
<tr height=30 class=caption>
<td colspan=2 valign=middle align=center id='head' ><big >Taxonomic Description</big> </td>
</tr>
<td width='175px' align="center">Class </td>
<td><?php echo $row['division_name']; ?></td>
</tr>
<tr>
<td align="center">Order</td>
<td><?php echo $row['order_name']; ?></td>
</tr>
<tr>
<td align="center">Family</td>
<td><?php echo $row['family_name']; ?></td>
</tr>
<tr>
<td align="center">Scientific Name</td>
<td id='scipop'><?php echo $row['sci_name']; ?></td>
</tr>
<tr>
<td align="center">Author</td>
<td><?php echo $row['author']; ?></td>
</tr>
<tr>
<td align="center">Common Name</td>
<td><?php echo $row['en_name']; ?></td>
</tr>
<tr>
</table>
<table width=80% border=2 id='popbod'>
<tr height=30 class=caption>
<td colspan=2 valign=middle align=center id='head' ><big >Additional Information</big> </td>
</tr>
<!-- <tr ><td width='30%'><?php echo $row2['info_label']; ?></td>
<td ><?php echo $row2['entry']; ?></td> </tr> -->
<?php
if($result){
$counter = 0;
while ($myrow = mysql_fetch_array($result)) {
$counter++;
printf(" <tr><td width='175px'>".$myrow['info_label']."</td>
<td>".$myrow['entry']."</td> </tr>");
}
echo "</table>\n";
}
?>
<table width=80% border=2 id='popbod'>
<tr height=30 class=caption>
<td colspan=2 valign=middle align=center id='head'><big>Picture</big></td>
</tr>
<td width="40%"><iframe src="<?php echo "imageUpdate.php?fish_id=".$fish_id;?>"
name=picframe width="100%" height=400px FRAMEBORDER=0></iframe>
</td>
</table>
<table width=80% border=2 id='popbod'>
<tr height=10 bgcolor="blue"><td valign=middle align=center colspan="4">
<input id="delete" type="submit" value="Delete Record" name="delete"
onclick="return confirm('Are you sure you want to delete this record?')">
</tr></table>
</form>
</center>
</body>
</html>
Boss pahelp po!!
Paano po bah e.delete record ko sa database ko,.Eto code ko ayaw gumana eh.
<?php
require('config.php'); //---- include the configuration file
/***********************************
* Open a query, abort program when query fails else return recordset
************************************/
function openQry($sql)
{
$rst = mysql_query($sql);
if (!$rst)
die("Unable to open ".$sql." ".mysql_error());
else
return $rst;
}
$connect = mysql_connect($dbhost, $dbuser, $dbpass);
if (!$connect)
die("Unable to connect ".$dbhost." ".mysql_error());
$db = mysql_select_db($dbname,$connect);
if (!$db)
die("Unable to open ".$dbname." ".mysql_error());
if (!isset($_GET['fish_id'])) {
die("The parameter fish_id is not specified");
}
// additional code...
$fish_id=$_GET[fish_id];
$division=$_GET[division];
$order=$_GET[order];
$family=$_GET[family];
$sci_name=$_GET[sci_name];
$author=$_GET[author];
$en_name=$_GET[en_name];
$description=$_GET[description];
if (isset ($_GET['delete'])){
$delete="DELETE FROM table1, table2, table3
USING identification table1, information table2, fish_pic table3
WHERE (table1.fish_id= table2.fish_id AND table1.fish_id=table3.fish_id AND table1.fish_id = '$fish_id')";
$row3=OpenQry($delete);
}
$qry ="SELECT
`identification`.`fish_id`,
`identification`.`division`,
`identification`.`order`,
`identification`.`family`,
`identification`.`sci_name`,
`identification`.`author`,
`identification`.`en_name`,
`order_list`.`order_name`,
`division_list`.`division_name`,
`family_list`.`family_name`
FROM
`identification`
Inner Join `division_list` ON `division_list`.`division_code` = `identification`.`division`
Inner Join `family_list` ON `family_list`.`family_code` = `identification`.`family`
Inner Join `order_list` ON `order_list`.`order_code` = `identification`.`order`
WHERE
`identification`.`fish_id`= '".$fish_id."'";
$result = openQry($qry);
$row = mysql_fetch_array($result);
$sql = "SELECT
`information`.`entry`,
`identification`.`fish_id`,
`info_list`.`info_label`
FROM
`identification`
Inner Join `information` ON `identification`.`fish_id` = `information`.`fish_id`
Inner Join `info_list` ON `info_list`.`info_code` = `information`.`info_code`
WHERE
`identification`.`fish_id` = `information`.`fish_id` AND
`identification`.`fish_id` ='".$fish_id."'";
$result = openQry($sql);
//$row3 = mysql_fetch_array($result);
if (!$row)
die("<fieldset><center>Record Deleted</center></fieldset>");
?>
<html>
<head>
<title>Delete List</title>
<link href="style.css" type="text/css" rel="stylesheet">
</head>
<body class='pop'>
<style type="text/css">
<!--
.odd {background-color:green}
.even {background-color:green}
.foot {background-color:green}
//-->
</style>
<center>
<table>
<form name=List method=GET action="<?php echo $PHP_SELF; ?>">
<input type="hidden" name="fish_id" value="<?php echo $fish_id; ?>">
<table width=80% border=2 id='popbod'>
<tr height=10 bgcolor="blue"><td valign=middle align=center colspan="4">
<input type="button" value="Close"
onclick="window.close()"></tr>
</table>
<table width=80% border=2 id='popbod'>
<tr height=30 class=caption>
<td colspan=2 valign=middle align=center id='head' ><big >Taxonomic Description</big> </td>
</tr>
<td width='175px' align="center">Class </td>
<td><?php echo $row['division_name']; ?></td>
</tr>
<tr>
<td align="center">Order</td>
<td><?php echo $row['order_name']; ?></td>
</tr>
<tr>
<td align="center">Family</td>
<td><?php echo $row['family_name']; ?></td>
</tr>
<tr>
<td align="center">Scientific Name</td>
<td id='scipop'><?php echo $row['sci_name']; ?></td>
</tr>
<tr>
<td align="center">Author</td>
<td><?php echo $row['author']; ?></td>
</tr>
<tr>
<td align="center">Common Name</td>
<td><?php echo $row['en_name']; ?></td>
</tr>
<tr>
</table>
<table width=80% border=2 id='popbod'>
<tr height=30 class=caption>
<td colspan=2 valign=middle align=center id='head' ><big >Additional Information</big> </td>
</tr>
<!-- <tr ><td width='30%'><?php echo $row2['info_label']; ?></td>
<td ><?php echo $row2['entry']; ?></td> </tr> -->
<?php
if($result){
$counter = 0;
while ($myrow = mysql_fetch_array($result)) {
$counter++;
printf(" <tr><td width='175px'>".$myrow['info_label']."</td>
<td>".$myrow['entry']."</td> </tr>");
}
echo "</table>\n";
}
?>
<table width=80% border=2 id='popbod'>
<tr height=30 class=caption>
<td colspan=2 valign=middle align=center id='head'><big>Picture</big></td>
</tr>
<td width="40%"><iframe src="<?php echo "imageUpdate.php?fish_id=".$fish_id;?>"
name=picframe width="100%" height=400px FRAMEBORDER=0></iframe>
</td>
</table>
<table width=80% border=2 id='popbod'>
<tr height=10 bgcolor="blue"><td valign=middle align=center colspan="4">
<input id="delete" type="submit" value="Delete Record" name="delete"
onclick="return confirm('Are you sure you want to delete this record?')">
</tr></table>
</form>
</center>
</body>
</html>
- Messages
- 12
- Reaction score
- 0
- Points
- 16
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
mga masters paano ko po ma didisplay ung mga word na na my mag kakaparehas na word...
sample
Java
and
Java Programming
eto my nagawa aq kaso kung ano lang ung nilagay mo sa textbox un lang ung lalabas
<form action="#" method="post">
<table>
<tr>
<input type="search" name="word" />
<input type="submit" name="search" value="Search"/>
</tr>
</table>
</form>
<?php
include "db-connect.php";
if($_SERVER["REQUEST_METHOD"]=="POST")
{
$word = $_POST['word'];
$sql=mysql_query("SELECT * from dictionary where w_name ='$word'");
$info = mysql_fetch_array($sql);
echo $info['w_name'];
}
?>
mga masters paano ko po ma didisplay ung mga word na na my mag kakaparehas na word...
sample
Java
and
Java Programming
eto my nagawa aq kaso kung ano lang ung nilagay mo sa textbox un lang ung lalabas
<form action="#" method="post">
<table>
<tr>
<input type="search" name="word" />
<input type="submit" name="search" value="Search"/>
</tr>
</table>
</form>
<?php
include "db-connect.php";
if($_SERVER["REQUEST_METHOD"]=="POST")
{
$word = $_POST['word'];
$sql=mysql_query("SELECT * from dictionary where w_name ='$word'");
$info = mysql_fetch_array($sql);
echo $info['w_name'];
}
?>
- Messages
- 981
- Reaction score
- 0
- Points
- 26
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
No, sir, i saw it online. In my previous posts here, im studying and to make a CMS site, it was sir Nitz who helped me a lot here. The codes i posted here were available online, i just modified it depeding on what i need.
Anyways, i was able to add record, but i was not able to search for it.
Thank you.
No, sir, i saw it online. In my previous posts here, im studying and to make a CMS site, it was sir Nitz who helped me a lot here. The codes i posted here were available online, i just modified it depeding on what i need.
Anyways, i was able to add record, but i was not able to search for it.
Thank you.
Last edited:
- Messages
- 171
- Reaction score
- 0
- Points
- 26
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
mga master paturo naman po kung paano magdownload.
I mean ung member pwede magupload ng files tapos malalagay sya link tapos pwede na idownload. ndi ko kasi magets ung sa php.net na code nila. pahelp naman po..
my script po ba kau ng download a file?
mga master paturo naman po kung paano magdownload.
I mean ung member pwede magupload ng files tapos malalagay sya link tapos pwede na idownload. ndi ko kasi magets ung sa php.net na code nila. pahelp naman po..
my script po ba kau ng download a file?
- Messages
- 21
- Reaction score
- 0
- Points
- 26
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
saan kopo maiimport ung users.sql?@pclogger: try to change ur username and password in ur connection.php
$username = "root"; <=== it shud be root,
$password = ""; <=== the way i see it u didn't set ur password for the localhost, so the default pass will be none.
here try this very basic login script i made.,
it lets users register and login,.
ang problem lng is i didn't made the validation, kaya ikaw na mag lagay sa validation, like hashing the password in the database, etc.. i did it in purpose kc maraming ways sa validation imo.
dont hesitate to share ur problems, TS made this thread para magtulungan tau, right TS?
password for my script is: password
- Messages
- 52
- Reaction score
- 0
- Points
- 26
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
at phpmyadmin.mysql administrator will do the import..
at phpmyadmin.mysql administrator will do the import..
- Messages
- 52
- Reaction score
- 0
- Points
- 26
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
use this query..
$sql=mysql_query("SELECT * from dictionary where w_name LIKE '%$word%'");
mga masters paano ko po ma didisplay ung mga word na na my mag kakaparehas na word...
sample
Java
and
Java Programming
eto my nagawa aq kaso kung ano lang ung nilagay mo sa textbox un lang ung lalabas
<form action="#" method="post">
<table>
<tr>
<input type="search" name="word" />
<input type="submit" name="search" value="Search"/>
</tr>
</table>
</form>
<?php
include "db-connect.php";
if($_SERVER["REQUEST_METHOD"]=="POST")
{
$word = $_POST['word'];
$sql=mysql_query("SELECT * from dictionary where w_name ='$word'");
$info = mysql_fetch_array($sql);
echo $info['w_name'];
}
?>
use this query..
$sql=mysql_query("SELECT * from dictionary where w_name LIKE '%$word%'");
