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

mga sir..meron po b kayong sample dyan lahat ng data file ng parang facebook po ...nais ko po sana tignan ang ilan bawat code...... sana po meron kayo :cry:
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

mga sir, since diff. language nman po mga nand2.. tnung lng po aq about sa installing/uninstalling MS SQL 2008..
whenever na bubuksan q ung intaller ng ms sql to install or uninstall, ganitong error ang lumlabas:

SQL Server Setup has encountered the following error:

The given key was not present in the dictionary..



3 days n po akong problemado d2, ndi q mbuksan ung database ng system nmen and i need to uninstall ung ms sql in my pc (kaso nga may error) to fully install ms sql


any help or piece of advice will do tnx po..


nanjan po ung pic
 

Attachments

  • Untitled.png
    Untitled.png
    129 KB · Views: 4
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

sir patulong naman po if how magnotify sa php..ggwa kasi kami ng document tracking system.dapat daw po nagnonotify ito kung nasnd na ba ung document or narecieve..
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

ako TS di tanung yung hanap ko dito. :salute: nice thread. Anyway hahanap kami ng magaling sa php coding at templates. Maliban lang sa scripting baka mayroon kaung mairerecommenda jan.
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

mga boss at sir may sample po bah kayo jan sa bank account using php oop yung simple lng poh..salamat pohh
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

nag design po ko ng web template using css ok sya s chrome & firefox but nung s ie ko n po tinignan nasira yung design..paginaus ko nman s ie ndidisalign nman s ibng browser pano po un??

Gamit ka ng Javascript

Pag na detect ng page mo na IE ang Browser na gamit yung style na ok sa IE yung gamitin mo.

kung hindi naman e yung pang Moz and chrome ang mag te take effect.

Ayos. Apir. Sana nakatulong sayo.
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

nagdedevelop po ako ng control panel para sa VPN ko, kaso pag dun sa paggegenerate ng code na button pag nagclick ako dun naggegenerate pero pag pindutin ko browser refresh at nagauautomatic generate sya. paano po mapipigilan yun?
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Mmhmm.. Out of topic lang to, Pero kasi base sa mga nabasa ko na tanong mula dun sa last page na binisita ko last time e pwede naman i search muna kay mr. google yung mga simpleng tanong, at yung iba naman e hangat maaari sana e yung pinaka clear na tanong yung i post. Yung sa iba naman na nahingi nga codesample e tingin ko mas magiging magaling na programmer kayo kung on your own ang codes. kayo mismo makaka create ng codes nyo. Ok siguro kung Pwede bang bigyan nyo ako ng Idea sa ganito. Yung ganun hindi yung Pwede pahingi ng codes. Kasi in reality walang pahingi ng codes make your own and be creative sa pag gawa.

Hindi ko sinasabi na magaling ako sa programming kaya ako ng sasabi ng ganito pero since nakikita ko ang tao na papunta sa maling way na pwede naman sabinan na dito ang tamang daan e dapat sabihan na para hindi mapariwara.

Ang sikreto lang naman sa pagiging good programmer are the following:

1. Research - kailangan magaling ka mag research
2. Basic knowledge - dapat start ka palagi sa Basic. Para lang yang nag start ka mag basa ng aphabet
3. Solid Understanding - kung alam mo na ang basic dapat solido na ang knowledge sa basic
4. Keep in mind na dapat ginagawa mo yung program meaning, wag umasa sa copy and paste.
5. Understanding sa scenario.

Base yan sa experience ko mga dudes.

Good luck and God bless.

Apir! Sana nakatulong.
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

sinu nakakaalam ng pagembed ng custom video player para sa website?

ayaw ko sana magupload sa youtube at ilagay sa website.

gusto ko sana custom ko ung player ng video at tinatawag lang sya sa root directory.

sana may makatulong sakin mga sir.
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

mga boss, anu kaya magandang web framework na babagay sa admin page? yung parang jquery mobile pero pang desktop browsers? sana may makatulong sa akin.
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

gusto ko po ganito yung link ko sa CSS ano gagamitin ko newbie Question lang po:noidea:
 

Attachments

  • 2.JPG
    2.JPG
    49.4 KB · Views: 4
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

:clap: Salamat tol

Pero yung gusto ko kasi pag tapat ng mouse ko may lalabas ng dropdown menu parang ganun.. CSS p ba yun?
 
Last edited:
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

mga boss patulong nguguluhan na kasi ako sa code ko eh newbie pa po kac ako sa php..gusto ko sanang e display ang na input ko sa database ito po code...
Code:
<?php
include 'connect.php';
class User
{
	var $card;
	var $name;
	var $depo;
//Database connect 
public function __construct() 
{
$db = new DB_Class();
}
//Registration process 
public function register_user($card,$name,$depo) 
{

$query =  mysql_query("INSERT INTO uu (card, name, depo) VALUES ('$card', '$name', '$depo')");
        $result = mysql_query($query);
      if($result) {
		die("Query didn't work. " . mysql_error());
		}
		else {
		}
		 header ("location: register_view.php");
		
}
public function getPosts() {
  $card = $_POST['card'];  
  
       $result = mysql_query("SELECT card,name,depo FROM uu ");
        $posts = array();
       while($post =  mysql_fetch_array($result)) {
            array_push($posts, new User( $post['card'], $post['name'], $post['depo']));      
        }  

	     
        return $posts;        
    }    
}
?>


sa html..

Code:
<html>
<head>
</head>
<body bgcolor='#333333'>
<?php
include 'functions.php';
$User = new User();
$posts = $User->getPosts();?>

<br><br><br><br><br><br><br><br>
<?php foreach ($posts as $post){ ?>
<table width="50%" border="0" align="center" cellpadding="2" cellspacing="0" bgcolor="#000000">
  <tr align="center"> 
    <td colspan="3"><font color="#00FF00" size="1" face="verdana">Welcome to your Banking System!</font></td>
  </tr>
  <tr> 
    <td align="right"> </td>
    <td align="center"> </td>
    <td> </td>
  </tr>
  <tr> 
    <td width="37%" align="right"><font color="#00FF00" size="2" face="arial"><b>Account Number</b></font></td>
    <td width="7%" align="center"><font color="#00FF00" size="2" face="arial">:</font></td>
    <td width="56%"><font color="#00FF00" size="2" face="arial"><b><?php echo $post->card; ?></b></font></td>
  </tr>
  <tr> 
    <td align="right"><font color="#00FF00" size="2" face="arial"><b>Identity Card</b>
      </font></td>
    <td align="center"><font color="#00FF00" size="2" face="arial">:</font><br> 
    </td>
    <td><font color="#00FF00" size="2" face="arial"><b><?php echo $post->record; ?></b></font></td>
  </tr>
  <tr> 
    <td align="right"><font color="#00FF00" size="2" face="arial"><b>Full Name</b></font></td>
    <td align="center"><font color="#00FF00" size="2" face="arial">:</font><br> 
    </td>
    <td><font color="#00FF00" size="2" face="arial"><b><?php echo $post->record; ?></b></font></td>
  </tr>
  <tr> 
    <td align="right"> </td>
    <td align="center"> </td>
    <td> </td>
  </tr>
  <tr align="center"> 
    <td colspan="3"> <form action='../banking/main.php' method='post'>
        <input type='submit' value='Proceed'>
      </form></td>
  </tr>
</table>
<?php }?> 
</body>
</html>
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

mga boss patulong nguguluhan na kasi ako sa code ko eh newbie pa po kac ako sa php..gusto ko sanang e display ang na input ko sa database ito po code...
Code:
<?php
include 'connect.php';
class User
{
	var $card;
	var $name;
	var $depo;
//Database connect 
public function __construct() 
{
$db = new DB_Class();
}
//Registration process 
public function register_user($card,$name,$depo) 
{

$query =  mysql_query("INSERT INTO uu (card, name, depo) VALUES ('$card', '$name', '$depo')");
        $result = mysql_query($query);
      if($result) {
		die("Query didn't work. " . mysql_error());
		}
		else {
		}
		 header ("location: register_view.php");
		
}
public function getPosts() {
  $card = $_POST['card'];  
  
       $result = mysql_query("SELECT card,name,depo FROM uu ");
        $posts = array();
       while($post =  mysql_fetch_array($result)) {
            array_push($posts, new User( $post['card'], $post['name'], $post['depo']));      
        }  

	     
        return $posts;        
    }    
}
?>


sa html..

Code:
<html>
<head>
</head>
<body bgcolor='#333333'>
<?php
include 'functions.php';
$User = new User();
$posts = $User->getPosts();?>

<br><br><br><br><br><br><br><br>
<?php foreach ($posts as $post){ ?>
<table width="50%" border="0" align="center" cellpadding="2" cellspacing="0" bgcolor="#000000">
  <tr align="center"> 
    <td colspan="3"><font color="#00FF00" size="1" face="verdana">Welcome to your Banking System!</font></td>
  </tr>
  <tr> 
    <td align="right"> </td>
    <td align="center"> </td>
    <td> </td>
  </tr>
  <tr> 
    <td width="37%" align="right"><font color="#00FF00" size="2" face="arial"><b>Account Number</b></font></td>
    <td width="7%" align="center"><font color="#00FF00" size="2" face="arial">:</font></td>
    <td width="56%"><font color="#00FF00" size="2" face="arial"><b><?php echo $post->card; ?></b></font></td>
  </tr>
  <tr> 
    <td align="right"><font color="#00FF00" size="2" face="arial"><b>Identity Card</b>
      </font></td>
    <td align="center"><font color="#00FF00" size="2" face="arial">:</font><br> 
    </td>
    <td><font color="#00FF00" size="2" face="arial"><b><?php echo $post->record; ?></b></font></td>
  </tr>
  <tr> 
    <td align="right"><font color="#00FF00" size="2" face="arial"><b>Full Name</b></font></td>
    <td align="center"><font color="#00FF00" size="2" face="arial">:</font><br> 
    </td>
    <td><font color="#00FF00" size="2" face="arial"><b><?php echo $post->record; ?></b></font></td>
  </tr>
  <tr> 
    <td align="right"> </td>
    <td align="center"> </td>
    <td> </td>
  </tr>
  <tr align="center"> 
    <td colspan="3"> <form action='../banking/main.php' method='post'>
        <input type='submit' value='Proceed'>
      </form></td>
  </tr>
</table>
<?php }?> 
</body>
</html>

Code:
<?php
    //connect to your database
      	$connection=@mysql_connect('localhost',$ususer,$uspass);
	$result=@mysql_select_db(your database name);

      $query="your qurey statement";

           $result=mysql_query($query); 

            if (mysql_num_rows($result)>0)
                {
                $myresult=blalalalalalalalaaaa;
                }
         /free result
     //clse connection

?>
<html>
<head>
   </head>
<body>
 <h1>MYResult</h1>
  <?php
       echo $myresult;;
  ?>
</body>
</html>
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Code:
<?php
    //connect to your database
      	$connection=@mysql_connect('localhost',$ususer,$uspass);
	$result=@mysql_select_db(your database name);

      $query="your qurey statement";

           $result=mysql_query($query); 

            if (mysql_num_rows($result)>0)
                {
                $myresult=blalalalalalalalaaaa;
                }
         /free result
     //clse connection

?>
<html>
<head>
   </head>
<body>
 <h1>MYResult</h1>
  <?php
       echo $myresult;;
  ?>
</body>
</html>

boss nka connect na po xa sa db problema ko nlng po ay f "select * from table_name" ilalabas nya lahat ng data sa db na table_name pro pag e specify ko naman gaya ng "where card ='$card' " wala siyang display..tulung naman pohh..



ito code ko sa function
Code:
public function getPosts($card) {

       $result = mysql_query("SELECT * FROM uu");
        $posts = array(); 
	     while($row =  mysql_fetch_array($result)) {
	      $posts[] = $row;
	     }
         
        return $posts;        
    }

sa php namn
Code:
nclude 'functions.php';
$User = new User();
$posts = $User->getPosts($card);?>

<?php foreach ($posts as $row){ ?>

<?php echo $row['card']; ?>
<?php echo $row['name']; ?>
<?php echo $row['depo']; ?>

<?php } ?>
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

boss nka connect na po xa sa db problema ko nlng po ay f "select * from table_name" ilalabas nya lahat ng data sa db na table_name pro pag e specify ko naman gaya ng "where card ='$card' " wala siyang display..tulung naman pohh..



ito code ko sa function
Code:
public function getPosts($card) {

       $result = mysql_query("SELECT * FROM uu");
        $posts = array(); 
	     while($row =  mysql_fetch_array($result)) {
	      $posts[] = $row;
	     }
         
        return $posts;        
    }

sa php namn
Code:
nclude 'functions.php';
$User = new User();
$posts = $User->getPosts($card);?>

<?php foreach ($posts as $row){ ?>

<?php echo $row['card']; ?>
<?php echo $row['name']; ?>
<?php echo $row['depo']; ?>

<?php } ?>


Baka nagkakamali ka sa query statement mo..

help select
Name: 'SELECT'
Description:
Syntax:
SELECT
[ALL | DISTINCT | DISTINCTROW ]
[HIGH_PRIORITY]
[STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
select_expr [, select_expr ...]
[FROM table_references
[WHERE where_condition]
[GROUP BY {col_name | expr | position}
[ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_condition]
[ORDER BY {col_name | expr | position}
[ASC | DESC], ...]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
[PROCEDURE procedure_name(argument_list)]
[INTO OUTFILE 'file_name'
[CHARACTER SET charset_name]
export_options
| INTO DUMPFILE 'file_name'
| INTO var_name [, var_name]]
[FOR UPDATE | LOCK IN SHARE MODE]]

SELECT is used to retrieve rows selected from one or more tables, and
can include UNION statements and subqueries. See [HELP UNION], and
http://dev.mysql.com/doc/refman/5.1/en/subqueries.html.

The most commonly used clauses of SELECT statements are these:

o Each select_expr indicates a column that you want to retrieve. There
must be at least one select_expr.

o table_references indicates the table or tables from which to retrieve
rows. Its syntax is described in [HELP JOIN].

o The WHERE clause, if given, indicates the condition or conditions
that rows must satisfy to be selected. where_condition is an
expression that evaluates to true for each row to be selected. The
statement selects all rows if there is no WHERE clause.

In the WHERE expression, you can use any of the functions and
operators that MySQL supports, except for aggregate (summary)
functions. See
http://dev.mysql.com/doc/refman/5.1/en/expressions.html, and
http://dev.mysql.com/doc/refman/5.1/en/functions.html.

SELECT can also be used to retrieve rows computed without reference to
any table.

URL: http://dev.mysql.com/doc/refman/5.1/en/select.html

here some of my example.
Code:
   $query="SELECT stores.address, purchaseorderid,suppliername,suppliers.address,suppliers.phone,suppliers.term, DATE_FORMAT(NOW(),'%m-%d-%Y'),shippername,gross,net from (($db.purchaseorders inner join $db2.suppliers on purchaseorders.supplierid=suppliers.supplierid) left join $db2.shippers on purchaseorders.shipperid=shippers.shipperid),$db2.stores where stores.storename='$db' and purchaseorderid=$id";
	   $result=mysql_query($query);
            if (!$result)
	       {
		throw new Exception(mysql_error());
	       }
           $row=mysql_fetch_row($result);

   $storeadd=$row[0];
   $purchaseid=$row[1];
   $suppliername=$row[2];
   $supplieradd=$row[3];
. and so on........

//more codes here.....

You have to test your query statement first in your mysql console(window) or terminal (linux) before applying it to your code..
 
Last edited:
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

may ask lang ako sino poh nakaka-alam nung sa textbox ..
may text sa textbox tapos pagclinick ko yung textbox mawawala yung text .. then
pagclinick ko sa labas babalik ulit yung textbox .. pa help thanks
 
Back
Top Bottom