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

Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

mga sir pa help naman po please .

Pinapagawa po kami ng HTMl ng prof. namin (offline) ang i pe present ko po ay human anatomy

at hindi ko po alam kung panu sisimulan at kung panu gagawin alam ko naman po ung mga basic kaso hindi ko alam kung

panung lay out ang gagawin ko wala po akong ka ide idea please help naman po kailangan ko lng malapit na po deadline
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

mga sir pwede po ang pahingi ng code about upload and download ng file(.doc/pdf) sa database gamit po PHP.....

salamat..
 
Last edited:
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

Thanks! Subukan ko. Oo nga eh. Need talaga mag bayad.
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

sir :thanks: po.. nakita ko na po ung sample code mu.. ok po sya kaso.. ung saint vincent college of cabuyao ko..

image po sya hehe.. :thanks:
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

SOON TO UPDATE (Tutorials and Sample Code) Para hindi na po redundant yung mga mostly na tinatanong po natin. :clap:


REGISTRATION FORM
----------------------------
LOGIN FORM
----------------------------
COMMENT FORM
----------------------------
SEARCH FORM
----------------------------
OTHERS (will be specify soon after you post yours)
----------------------------


From there ilalagay po natin lahat ng may author in every code and tuts together with their links in the thread.. :salute:
PM nyo lang ako pag may nilagay kayong tuts and sample codes tas yung link and dont forget the title kung para san yung tuts and sample code the yun para malagay narin natin... thnx guys for helping others..


sana meron updates nito
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

mga sir baka naman po may giangamit kayong code diyan nang php database connection yung maikli lang po? ang haba kasi anng parang mga code na nakikita ko sa net. agaaral palang po kasi ako sa php and share niyo na rin po mga thoughts niyo or suggestion on my learning curve sa php :D
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

Need help html po :(
Code:
<html>

<head>
<script language= "javascript">  
function sel(frm)
{
var pet = frm.chkSubj;
var a="<ul>";

for (i=0;i<pet.length;i++)
	{
	if(pet[i].checked)
		{
		 a+="<li>"+pet[i].value+"</li>";
		
		}
}
		a+="</ul>";
		a="Your Subject is/are : "+ a;

var courses = frm.cboCourse;
var idx = courses.selectedIndex;
var course = courses.options[idx].value;


var years=frm.optYear;
var ctrs;
var as;

for(ctrs=0;ctrs<years.length;ctrs++)
{
if(years[ctrs].checked)
{
as=years[ctrs].value;
break;
}
}
var nam = frm.txtname.value;

document.getElementById("name").innerHTML="Name : " + nam;
document.getElementById("subj").innerHTML= a;
document.getElementById("year").innerHTML="Year : " + as;
document.getElementById("course").innerHTML="Course : " + course;

}


</script>
</head>

<body>
<form>
	Name:
	<input type="text" name="txtname"/>
	<br /><br />
	Course:
	<select name="cboCourse">
		<option value="-1"></option>
		<option value="BSCS">BSCS</option>
		<option value="BSIT">BSIT</option>
		<option value="ComEng">ComEng</option>
		<option value="ComTech">ComTech</option>
		<option value="ComSec">ComSec</option>
		<option value="ACHT">ACHT</option>
	</select>

	<br /><br />
	Year:
	<input type="radio" value="First" name="optYear" checked="checked"/>I
	<input type="radio" value="Second" name="optYear" />II
	<input type="radio" value="Third" name="optYear" />III
	<input type="radio" value="Fourth" name="optYear" />IV

	<br /><br />
	Subjects:
	<br />	
	<input type="checkbox" value="CP1" name="chkSubj" />CP1
	<input type="checkbox" value="DBMS" name="chkSubj" />DBMS
	<br />
	<input type="checkbox" value="CP2" name="chkSubj" />CP2
	<input type="checkbox" value="WebProg" name="chkSubj" />WebProg
	<br />
	<input type="checkbox" value="CP3" name="chkSubj" />CP3
	<input type="checkbox" value="IT Project I" name="chkSubj" />IT Project I
	<br />
	<input type="checkbox" value="CCF" name="chkSubj" />CCF
	<input type="checkbox" value="IT Project II" name="chkSubj" />IT Project II


	<br /><br />
	<input type="button" value="Process" onclick="sel(this.form)" />
	<input type="reset" value="Clear" onclick ="Delete"/>
</form>

<div id="name"></div>
<div id="course"></div>
<div id="year"></div>
<div id="subj"></div>

</body>

</html>

this is the output of the code :
15qopbp.jpg


Now ang problema ko po ay panu lagyan ng asterisk "*" sa right side of each cbobox, option, name if they are unfilled tapos click mo yung process.. thats like this :
jj4v81.jpg


Thanks! :)
 
Last edited:
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

Need help html po :(
Code:
<html>

<head>
<script language= "javascript">  
function sel(frm)
{
var pet = frm.chkSubj;
var a="<ul>";

for (i=0;i<pet.length;i++)
	{
	if(pet[i].checked)
		{
		 a+="<li>"+pet[i].value+"</li>";
		
		}
}
		a+="</ul>";
		a="Your Subject is/are : "+ a;

var courses = frm.cboCourse;
var idx = courses.selectedIndex;
var course = courses.options[idx].value;


var years=frm.optYear;
var ctrs;
var as;

for(ctrs=0;ctrs<years.length;ctrs++)
{
if(years[ctrs].checked)
{
as=years[ctrs].value;
break;
}
}
var nam = frm.txtname.value;

document.getElementById("name").innerHTML="Name : " + nam;
document.getElementById("subj").innerHTML= a;
document.getElementById("year").innerHTML="Year : " + as;
document.getElementById("course").innerHTML="Course : " + course;

}


</script>
</head>

<body>
<form>
	Name:
	<input type="text" name="txtname"/>
	<br /><br />
	Course:
	<select name="cboCourse">
		<option value="-1"></option>
		<option value="BSCS">BSCS</option>
		<option value="BSIT">BSIT</option>
		<option value="ComEng">ComEng</option>
		<option value="ComTech">ComTech</option>
		<option value="ComSec">ComSec</option>
		<option value="ACHT">ACHT</option>
	</select>

	<br /><br />
	Year:
	<input type="radio" value="First" name="optYear" checked="checked"/>I
	<input type="radio" value="Second" name="optYear" />II
	<input type="radio" value="Third" name="optYear" />III
	<input type="radio" value="Fourth" name="optYear" />IV

	<br /><br />
	Subjects:
	<br />	
	<input type="checkbox" value="CP1" name="chkSubj" />CP1
	<input type="checkbox" value="DBMS" name="chkSubj" />DBMS
	<br />
	<input type="checkbox" value="CP2" name="chkSubj" />CP2
	<input type="checkbox" value="WebProg" name="chkSubj" />WebProg
	<br />
	<input type="checkbox" value="CP3" name="chkSubj" />CP3
	<input type="checkbox" value="IT Project I" name="chkSubj" />IT Project I
	<br />
	<input type="checkbox" value="CCF" name="chkSubj" />CCF
	<input type="checkbox" value="IT Project II" name="chkSubj" />IT Project II


	<br /><br />
	<input type="button" value="Process" onclick="sel(this.form)" />
	<input type="reset" value="Clear" onclick ="Delete"/>
</form>

<div id="name"></div>
<div id="course"></div>
<div id="year"></div>
<div id="subj"></div>

</body>

</html>

this is the output of the code :
http://i62.tinypic.com/15qopbp.jpg

Now ang problema ko po ay panu lagyan ng asterisk "*" sa right side of each cbobox, option, name if they are unfilled tapos click mo yung process.. thats like this :
http://i57.tinypic.com/jj4v81.jpg

Thanks! :)

Sir wrap mo element mo sa div..mga limang div..
<form>
<div class="name"> [Your Code] <span class="required">*</span></div>
<div class="course"> [Your Code] <span class="required">*</span></div>
<div class="year"> [Your Code] </div>
<div class="subject"> [Your Code] <span class="required">*</span></div>
<div class="form-action"> [Your Code] </div>
</form>

<style type="text/css">
.required {
float: right;
}
</style>

alm mo nmn na ata pag ndi nlgyn ung required eh..show mo nlng ung .required sa bawat div na wlang input si user..
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

mga sir ano po kaya mali nang login.php ko eto po yung code ko

kapag tinatype ko na yung username at password at pag clinick ko na yung login parang narrereset lang po yung mga fields eh nawawala lang yung mga nilagay kong username at password

<?php
include("includes/connection.php");


$my_connect=mysql_connect(DB_HOST,DB_USER,DB_PASS) or die("Couldn't Connect to the database!".mysql_error());

$my_db=mysql_select_db(DB_DATA,$my_connect) or die("Couldn't find the Database!".mysql_error());


if (isset($_POST['submit']))
{

$user_name=strip_tags($_POST['uname']);
$user_pass=strip_tags($_POST['pword']);

if($user_name&&$user_pass)
{
$my_query=mysql_query("Select * from tbl_users where Uname='$user_name' and Pword='$user_pass'");

$numrows=mysql_num_rows($my_query);
if($numrows!=0)
{
header("Location: index.php");
}
else{
echo ("The Username or password is incorrect!");
echo ("<a href=/'mywebsite/index.php/'>Back to Login Page</a>");

}
}


else{
echo "<html><center><h2>Please Complete the fields needed to proceed</h2><a href='index.php'>Back to Login</a></center></html>";

}


}

?>

- - - Updated - - -

help naman po regarding may login
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

mga sir ano po kaya mali nang login.php ko eto po yung code ko

kapag tinatype ko na yung username at password at pag clinick ko na yung login parang narrereset lang po yung mga fields eh nawawala lang yung mga nilagay kong username at password

<?php
include("includes/connection.php");


$my_connect=mysql_connect(DB_HOST,DB_USER,DB_PASS) or die("Couldn't Connect to the database!".mysql_error());

$my_db=mysql_select_db(DB_DATA,$my_connect) or die("Couldn't find the Database!".mysql_error());


if (isset($_POST['submit']))
{

$user_name=strip_tags($_POST['uname']);
$user_pass=strip_tags($_POST['pword']);

if($user_name&&$user_pass)
{
$my_query=mysql_query("Select * from tbl_users where Uname='$user_name' and Pword='$user_pass'");

$numrows=mysql_num_rows($my_query);
if($numrows!=0)
{
header("Location: index.php");
}
else{
echo ("The Username or password is incorrect!");
echo ("<a href=/'mywebsite/index.php/'>Back to Login Page</a>");

}
}


else{
echo "<html><center><h2>Please Complete the fields needed to proceed</h2><a href='index.php'>Back to Login</a></center></html>";

}


}

?>

- - - Updated - - -

help naman po regarding may login

if($user_name&&$user_pass) <---- para san po ba to?
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

Ts alam niyo po ba yung php code para sa print button ? para mag print sa printer ?
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

mga master ask lng po dun sa mga nakapag intranet na ng php mysql.. gamit ko po ay xampp.
pano po ba na isetup ko sya ng intranet yung land based lng sya within the company mo lng sya pwdeng i access

patulong nmn po please..:help::help::help::help::pray::pray::pray::pray:
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

mga sir anu po kaya mali ko dito sa registration ko sa php bale eto po yung mga fields

Username, Password, Confirmpassword, Fullname,email_add ang problema po kapag nafillupan lahat and siyempre magkaparehas yung password and tama yung email add na nailagay ok siya registered successfully and naisasave naman siya sa database at nailologin ko siya pero kapag hindi parehas yung password na nailagay nacleaclear lang yung mga fields and also kapag hindi email address ang nailagay nacleaclear lang din yung mga fields

eto po pala yung code nang register.php kopo thank you :D

<?php
session_start();

$my_connec=mysql_connect("localhost","root","") or die("Couldn't Connect to the database!");
$my_db=mysql_select_db("db_mysite") or die("Couldn't find the Database!");

if (isset($_POST['submit']))
{

$user_name=strip_tags($_POST['uname']);
$fullname=strip_tags($_POST['fullname']);
$c_pword1=strip_tags($_POST['pword']);
$c_pword2=strip_tags($_POST['cpword']);
$email_add=strip_tags($_POST['emailadd']);


if ($user_name&&$c_pword1&&$c_pword2&&$email_add&&$fullname)
{
if ($c_pword1==$c_pword2)
{
$my_query=mysql_query("Select * from tbl_users where Uname='$user_name'");
$numrow=mysql_num_rows($my_query);
if ($numrow!=0)
{
echo "Username already exist!";
echo "<a href='index.php'>matik</a>";

}
else
{


$my_query=mysql_query("INSERT INTO tbl_users(Uname,Pword,Fullname,Email_add) values('$user_name','$c_pword1','$fullname','$email_add')");
die("You have been Registered!....Return to <a href='index.php'>Login Page</a>");

}
}
else
{
echo "Password doesn't match!";
}

}
else
{
echo "Please complete the following fields to continue";
}
}

session_destroy();

?>




<html>
<head>
<title>OUR LAB EXAM[NEW]</title>
<link rel="stylesheet" href="css/style.css" />

</head>
<body>

<div id="content-wrapper">

<div id="menu">

<ul>

<li><a href="home.php">Home</a></li>
<li><a href="#">Download</a></li>
<li><a href="register.php">Register</a></li>
<li><a href="#">Members</a></li>
<li><a href="#">Forum</a></li>
<li><a href="#">Contact</a></li>
<li><a href="#">Search</a></li>

</ul>

</div>

<div id="banner"></div>

<div id="content-top">

<div id="featured-member">

<h2>Featured Member<br />Featured Work</h2>

</div>

<div id="login-form">

<fieldset>

<label for="username">Username</label>
<input type="text" name="uname" class="text" /><br />

<label for="password">Password</label>
<input type="password" name="pword" class="text" /><br />

<input type="submit" value="Submit" class="button" />

<a href="register.php">Register</a>

</form>

</fieldset>

</div>

<div id="reg">
<form action="register.php" method="POST">
<table>
<th><h1>Registration</h1></th>
<tr>
<td>Choose Username:</td>
<td><input type="text" name="uname" /></td>
</tr>
<tr>
<td>Choose Password:</td>
<td><input type="password" name="pword" /></td>
</tr>
<tr>
<td>Confirm Password:</td>
<td><input type="password" name="cpword" /></td>
</tr>
<tr>
<td>Fullname:</td>
<td><input type="text" name="fullname" maxlength="50" /></td>
</tr>

<tr>
<td>Email Address:</td>
<td><input type="email" name="emailadd" /></td>
</tr>

<tr>
<td><input type="submit" name="submit" value="Register"></td>

</tr>
</table>

</div>






</div>





<div id="footer-nav">

<ul>

<li> </br> @ 2014 Brian Smetham Ama Tuguegarao </li>

</ul>

</div>

</div>

</body>
</html>
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

paano po ito gagawan ng paraan, di kuna po alam gagawin eh patulong naman po...


Cannot add or update a child row: a foreign key constraint fails (`servantcommunities`.`tbl_attendance`, CONSTRAINT `tbl_attendance_ibfk_1` FOREIGN KEY (`scID`) REFERENCES `tbl_information` (`scID`) ON DELETE CASCADE ON UPDATE CASCADE)
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

paano po ito gagawan ng paraan, di kuna po alam gagawin eh patulong naman po...


Cannot add or update a child row: a foreign key constraint fails (`servantcommunities`.`tbl_attendance`, CONSTRAINT `tbl_attendance_ibfk_1` FOREIGN KEY (`scID`) REFERENCES `tbl_information` (`scID`) ON DELETE CASCADE ON UPDATE CASCADE)

sir baka mali yung pag refer mo ..
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

Sir ako po may tanung.... baguhan po ako sa php programming i accepted a project po.. sa organization po kasi ito, panu po ung code ng magkakaroon ng bagong Id num base on sa num ng nagrefer sau.... eto po ang scenario, example po ung nagrefer sa akin eh id code nya is 1 tapos ang magiging id num q na eh 1.1 tapos nakapagrefer aq ng tatlo, so ang magigng Id num nila eh 1.1.1 1.1.2 at 1.1.3 and ganun po.. pahelp po.. ganyan po ang mag aappear na id iniisip ko po kung pwede iauto increment yan hindi q po mavisualize ung code nya. kasi parang networking ung concept ng pag ggawa nya ng Id.. patulong po. salamat.
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

mga sir anu po kaya mali ko dito sa registration ko sa php bale eto po yung mga fields

Username, Password, Confirmpassword, Fullname,email_add ang problema po kapag nafillupan lahat and siyempre magkaparehas yung password and tama yung email add na nailagay ok siya registered successfully and naisasave naman siya sa database at nailologin ko siya pero kapag hindi parehas yung password na nailagay nacleaclear lang yung mga fields and also kapag hindi email address ang nailagay nacleaclear lang din yung mga fields

eto po pala yung code nang register.php kopo thank you :D

<?php
session_start();

$my_connec=mysql_connect("localhost","root","") or die("Couldn't Connect to the database!");
$my_db=mysql_select_db("db_mysite") or die("Couldn't find the Database!");

if (isset($_POST['submit']))
{

$user_name=strip_tags($_POST['uname']);
$fullname=strip_tags($_POST['fullname']);
$c_pword1=strip_tags($_POST['pword']);
$c_pword2=strip_tags($_POST['cpword']);
$email_add=strip_tags($_POST['emailadd']);


if ($user_name&&$c_pword1&&$c_pword2&&$email_add&&$fullname)
{
if ($c_pword1==$c_pword2)
{
$my_query=mysql_query("Select * from tbl_users where Uname='$user_name'");
$numrow=mysql_num_rows($my_query);
if ($numrow!=0)
{
echo "Username already exist!";
echo "<a href='index.php'>matik</a>";

}
else
{


$my_query=mysql_query("INSERT INTO tbl_users(Uname,Pword,Fullname,Email_add) values('$user_name','$c_pword1','$fullname','$email_add')");
die("You have been Registered!....Return to <a href='index.php'>Login Page</a>");

}
}
else
{
echo "Password doesn't match!";
}

}
else
{
echo "Please complete the following fields to continue";
}
}

session_destroy();

?>




<html>
<head>
<title>OUR LAB EXAM[NEW]</title>
<link rel="stylesheet" href="css/style.css" />

</head>
<body>

<div id="content-wrapper">

<div id="menu">

<ul>

<li><a href="home.php">Home</a></li>
<li><a href="#">Download</a></li>
<li><a href="register.php">Register</a></li>
<li><a href="#">Members</a></li>
<li><a href="#">Forum</a></li>
<li><a href="#">Contact</a></li>
<li><a href="#">Search</a></li>

</ul>

</div>

<div id="banner"></div>

<div id="content-top">

<div id="featured-member">

<h2>Featured Member<br />Featured Work</h2>

</div>

<div id="login-form">

<fieldset>

<label for="username">Username</label>
<input type="text" name="uname" class="text" /><br />

<label for="password">Password</label>
<input type="password" name="pword" class="text" /><br />

<input type="submit" value="Submit" class="button" />

<a href="register.php">Register</a>

</form>

</fieldset>

</div>

<div id="reg">
<form action="register.php" method="POST">
<table>
<th><h1>Registration</h1></th>
<tr>
<td>Choose Username:</td>
<td><input type="text" name="uname" /></td>
</tr>
<tr>
<td>Choose Password:</td>
<td><input type="password" name="pword" /></td>
</tr>
<tr>
<td>Confirm Password:</td>
<td><input type="password" name="cpword" /></td>
</tr>
<tr>
<td>Fullname:</td>
<td><input type="text" name="fullname" maxlength="50" /></td>
</tr>

<tr>
<td>Email Address:</td>
<td><input type="email" name="emailadd" /></td>
</tr>

<tr>
<td><input type="submit" name="submit" value="Register"></td>

</tr>
</table>

</div>






</div>





<div id="footer-nav">

<ul>

<li> </br> @ 2014 Brian Smetham Ama Tuguegarao </li>

</ul>

</div>

</div>

</body>
</html>


check mo tong repo ko https://github.com/roowako/inno.git

- - - Updated - - -

Ts alam niyo po ba yung php code para sa print button ? para mag print sa printer ?


<p>Click the button to print the current page.</p>

<button onclick="myFunction()">Print this page</button>

<script>
function myFunction()
{
window.print();
}
</script> easiest way

- - - Updated - - -

mga sir baka naman po may giangamit kayong code diyan nang php database connection yung maikli lang po? ang haba kasi anng parang mga code na nakikita ko sa net. agaaral palang po kasi ako sa php and share niyo na rin po mga thoughts niyo or suggestion on my learning curve sa php :D

eto pinaka simple connection.php
<?php $con = mysql_connect("localhost","root","","db_name"); ?>

- - - Updated - - -

if else if else will do.

- - - Updated - - -

hmm look for append using jquery or javascript.
 
Last edited:
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

PHP question:

gud pm masters meron po kayo tutorial for manual activation by an administrator in php for newly registered members for a website? or may flow kau step by step if ano ang gagawin, need ko kasi lagyan ng activation using admin account
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

PHP question:

gud pm masters meron po kayo tutorial for manual activation by an administrator in php for newly registered members for a website? or may flow kau step by step if ano ang gagawin, need ko kasi lagyan ng activation using admin account

lagay ka lang sa table ng STATUS if status is 1 activated na if 0 naman eh d pa activated..
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pa

Mga sir, Tanong kulang poh kung paano mag insert ng data sa table na my foregn key from other table.....how I get the ID of foreign key? salamat
 
Back
Top Bottom