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 pasok D2

Obviously.

Dapat kung ano ang nasa design mo sa database layout, cya ring ma.code jan. Error ang labas mo nyan pag wala sa database.

I wonder bat wala kang error when you delete? you should have error raised by PHP when you invoke edit or delete.

yap, wala ngang error sir pag nagdedelete ako, saktong sakto kung ano gusto kong madelete un ang mga ndedelete :lol:
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

thanks kay sir hakuna.. :)
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Can someone explain how friend system works, kung ilang table ba need at kung ano mga ilalagay na column names.. Thanks
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Can someone explain how friend system works, kung ilang table ba need at kung ano mga ilalagay na column names.. Thanks

i think pwede na sa 2.
1 for User and the other for friend identifier.

Eg.

Friends table contains two columns, User Column and Friends Column.

So pag inadd ni user 1 si user 2,

massave ngayun sa friends table yung userid nila.

Eg.
[User Column], [Friend Column]
user 1, user 2
user 2, user 1


para pag idispay mo yung mga friends ni user 1, all you have to do is use the where clause,
select friend from friends where user = 1

sorry kung mejo magulo, cp mode kasi. Hirap magtype. Hehe.
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

i think pwede na sa 2.
1 for User and the other for friend identifier.

Eg.

Friends table contains two columns, User Column and Friends Column.

So pag inadd ni user 1 si user 2,

massave ngayun sa friends table yung userid nila.

Eg.
[User Column], [Friend Column]
user 1, user 2
user 2, user 1


para pag idispay mo yung mga friends ni user 1, all you have to do is use the where clause,
select friend from friends where user = 1

sorry kung mejo magulo, cp mode kasi. Hirap magtype. Hehe.

salamat sa effort haha,, by the way 2 beses ako mag insert?
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

mga sir! panu poh mag send ng email from localhost server sa php eto poh lumalabas na error skin.. "Warning: mail() [function.mail]: Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set()" di q poh masolusyunan ung error eh! gusto q sna itest kung ok ung email verification sa registration q. sna may tumulong sakin na master jan! nga pala wamp ung ginagamit q! nid q lang poh! :thumbsup::upset::upset:
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Need you help po..
Here's my code

<form action="classschedule.php" method="post">
Search: <input type="text" name="term" /><br />
<input type="submit" name="submit" value="Submit" />
</form>


Gusto ko lang po sana may error handlers xa, like error kapag knlick ko yung submit tapos wla akong ininput sa box or error kpag mali ung keywords na tinype ko..tnx po..

tpos code bellow is the result.. gusto ko rin po sana nka'highlight ung keywords na tinype ko pag nagssearch..

<form>
<?php
$con = mysql_connect("localhost","root");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("semsubject", $con);

$term = $_POST['term'];

$sql = mysql_query("select * from semsubject where fullname like '%$term%' or bldg like '%$term%' or subjcode like '%$term%'");

while ($row = mysql_fetch_array($sql)){
echo 'School Year: '.$row['sy'];
echo '<br/> Semester: '.$row['sem'];
echo '<br/> Subject: '.$row['subjcode'];
echo '<br/> Section: '.$row['section'];
echo '<br/> Days: '.$row['days'];
echo '<br/> Time: '.$row['time'];
echo '<br/> Building: '.$row['bldg'];
echo '<br/> Employee ID: '.$row['empid'];
echo '<br/> Employee Fullname: '.$row['fullname'];
echo '<br/><br/>';
}

mysql_close($con);
?>
</form>


try mo maglagay ng if, example

if (isset($_POST['submit']))
{
$sy=($_POST['txtusername']);
$sem=($_POST['txtpassword']);

if($sy==''){
die('Please Enter School Year...');
}if($sem==''){
die('Please Enter Semester...');
}

kakaturo lng samin to ng prof namin last week eh sana nakatulong :thumbsup:
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Guys p2long naman ako dito,

Gusto ko kasi kapag Male ung user
pupunta siya lets say for example sa -> male.php
kapag naman female didirect naman sa -> female.php
at kapag naman wala siyang nilagay magdidirect siya sa register.php

pa assist naman sa nakakaalam dito salamat poh ^_^:help:



Code:
<?php
$con=mysql_connect('localhost','root','');
mysql_select_db('dblib',$con); 



if(isset($_POST['submit']))
{
	$username=($_POST['txtusername']);
	$password=($_POST['txtpassword']);

	$qstring="select * from studentrecords where username='$username' and password='$password'";
	$submit=mysql_query($qstring);
	
	$test=mysql_num_rows($submit);
	
	if($test==0)
	{
	echo"<script>alert(\"Invalid Username or Password\");</script>";
	}
		
	if($test==1)
	{
	header('Location: male.php');
	}
	
}

?>


<html>

<title>Library Circulation System</title>
<style type="text/css">

hr 
{
  color:SpringGreen;
  height:2;
  width:80%;
}

h1
{
  font-family:Old English Text MT;
  text-align:center;
  color:snow;
  font-size:25px;
}


h2
{
  font-family:Georgia;
  color:white;
  text-align:left;
  font-size:15pt;
  font-style:italic;
}

body 
{

  background-color:black;
  background-image:url(s.jpg);
  background-size: 100%;
  background-attachment:fixed;
  background-position:center;
  background-repeat:no-repeat;
  scrollbar-arrow-color:red;
  scrollbar-base-color:#FF6347;
  scrollbar-darkshadow-color:#006600;
  scrollbar-face-color:#FFF0F5;
  scrollbar-highlight-color:#1E90FF;
  cursor:url(sjcb.ani);
}

</style>

<body><span class=1>
<table height=100% width=80% cellpadding=0 cellspacing=0 bordercolor=white borderstyle=double align="center">
	<tr>
		<td valign=top><h1><br>
		LAN-Based Library Circulation System<br> of Saint Joseph College of Bulacan</h1><br><hr><br>
		<br><br>
		<table border=0 align=center>
		<td width=40%>
		<fieldset><legend><font color="white">Login</font></legend>
		<center>
		<form method="POST"><br />
		<font color="white">Username:</font>  <input type="text" size="10" name="txtusername" STYLE="font-size:17; background-color:gold"> <font color=red><sup>*required</sup></font><br /><br />
		<font color="white">Password:</font>  <input type="password" size="10" name="txtpassword" STYLE="font-size:17; background-color:gold"><font color=red> <sup>*required</sup></font>
		</p></center>
		<center><br>
		<input class="1" type="submit" name="submit" value="Login" STYLE="font-size:15; background-color:green; color:white; border-color="red" />
		</form> 
		<a href="register.php">
		<input type="button" value="Register" STYLE="font-size:15; background-color:green; color:white; border-color="red" /></a></center><br />
		
		</fieldset><br>
		</table></td>
		
	</tr>
</table>
</body>
</html>
 

Attachments

  • untitled.JPG
    untitled.JPG
    32.9 KB · Views: 5
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

pano po ba gawin tong iniisip ko:

Meron akong 5 Category

1.Mobile Zone
2.PC UBT/FBT
3.Programming
4. PC Themes
5.PC Applications

tas kapag nagadd ako ng new category automatic madidisplay yung naiadd kong category.

nagawa ko na po yan ang hindi ko lang po magawa ay yung automatic ididisplay yung mga laman ng bawat category
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Eto yung html file ko:

Code:
<div id="contents">
    <div id="centeredmenu">
        <ul id="navigation">
	     <li class="active"><a href="/">Home</a></li>
	     <li><a href="/test1">test1</a></li>
	     <li><a href="/test2">test2</a></li>
        </ul>
     </div>
</div>

paano ko ba ma change yung may mga CLASS na "active" to gamit CSS? :dance:
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Ask ko lang po sana kung anong version ng Xampp ang pinaka user-friendly?
Kasi po balita ko may mga conflict sa codings dati dun sa bagong Xampp..?

Can anyone confirm this?
Thanks po!
:salute:
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Ask ko lang po sana kung anong version ng Xampp ang pinaka user-friendly?
Kasi po balita ko may mga conflict sa codings dati dun sa bagong Xampp..?

Can anyone confirm this?
Thanks po!
:salute:

Meron bang ganito sa XAMPP? I think sa PHP to. Kasi sa PHP 5.3 daming ni.remove na functionalities from 5.2. Tapos If di ako nagkakamali, walang backward compatibility na ata from PHP 5.3.6.

About sa conflict ng codings, parang wala cyang conflict, meron lang cgurong deprecated functions at features. If yong coding mo was coded from PHP 5.2, be sure to update your site na maging compatible in PHP 5.3.

About sa XAMPP version, just look for XAMPP na may PHP 5.3 up.
 
Last edited:
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

:hat:
Spectator lang po kasi ako sir eh..
Bale mga nasagap ko lang po yun.. Magsstart palang po ako ng studies sa PHP
since hindi po ito nabigyang pansin sa subject ko..

:salute: Salamat po!
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

I just recently read the PHP release notes. After replying on your post.

Dami na talaga tinangal yong PHP 5.4. Kaya mas better hwag gagamit ng mga legacy style of coding dun sa PHP. Malay natin next version that feature na pala is removed. :)

http://php.net/ChangeLog-5.php
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Tinignan ko po yung latest dun sa ApacheFriends at ang Php na nakalagay eh yung
5.3.8 pa..
Hindi na po yung supported ng PhP diba?
May disadvantage po ba yun?

Another thing, ano pong mas prefer nyong gamitin? Wamp or Xampp?

Noob na noob pa po kasi ako.
Sorry po.. :unsure:
 
Last edited:
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Tinignan ko po yung latest dun sa ApacheFriends at ang Php na nakalagay eh yung
5.3.8 pa..
Hindi na po yung supported ng PhP diba?
May disadvantage po ba yun?

Another thing, ano pong mas prefer nyong gamitin? Wamp or Xampp?

Noob na noob pa po kasi ako.
Sorry po.. :unsure:

Supported pa yong PHP 5.3.* and up. Yong di na supported is yong PHP 4, 5.2.* down.

Pwede pa yan.

I don't use those eh. Hahaha I'm using the installers talaga ng Apache, PHP at Postgres. Di ako gumagamit ng XAMPP or WAMP.

Mas updated ata yong sa WAMP. Yong wamp nalang gamitin mo. ;D
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Base on Wiki lang po yung info ko sir eh... 5.3.10 nalang daw tsaka 5.4 ang supported nila..

anyways.. Mag ttry parin naman po ako either way..
Salamat po ng marami sir! :salute:
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Ang supported nila is 5.3 at 5.4. Yong latest version ng 5.3 series is 5.3.10, then sa 5.4 is 5.4.0.

Ganyan po cya ang naming ng version ng php.. If you have 5.3.8, you need to update to 5.3.10 para ma fix yong mga minor changes or bug fixes sa 5.3 branch/series.

Yong 3rd digit kasi pag.mag.increment yan it means may minor change.
Tapos kung ang 2nd digit mag increment it means major changes.

Major changes kung may babaguhin (coding at structure ng codes) or mag.add ng bagong features. While yong minor changes, kalimitan nito is bug fixes at corrections sa mga bagong features na dinagdag dun sa major release.
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Ganun pala yun... At least may natutunan parin ako..
Salamat po sir! :salute:
 
Back
Top Bottom