Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok dito

zidaine_38 · Oct 9, 2011

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

byakuran0425 said:
sino magaling gumawa ng program ?? hotel database

contact me if you needed my service..

gumagawa ako ng website which includes all aspects from photography, analiztion, translation, programming and deployment..

pwede ko pakita ang mga nagawa kong websites ^^

zidaine_38 · Oct 9, 2011

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

facedown said:
mga master, tanong lang po.

mag kano po bayad / singil sa isang dynamic website?
yung simpling PHP/mySQL CSS, at HTML

presyong kakilala

at presyong natural

eheheh..

simple: 7 K ~ 10 K
dynamic: 10 K ~ 15K
dynamic + class B: 15 K ~ 20 K
business type: 20 K ~ 40 K

may quote yan, presyong kakilala ^^

contact me ung kailngan mo ng quotation

zidaine_38 · Oct 9, 2011

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

shellv said:
sir, sa pc ko lng po, pero ia-upload ko din po s internet kpg nkahanap n
po ako ng free hosting ng website..iche-check daw po nila sa internet
ung project ko..mga konti lang po akong alam s php,html,css,photosop,
javascript at jquery..my nagawa na po akong template.nasa registration n
po ako nian..

meron po akong nadownload na jquey registration form, kaya lng hndi ko
po alam kung papaano ko xa lalagyan ng validation at kung papaano ko xa
lalagyan ng sql..
gusto ko po sanang ipakita sa inyo un sir,kya lng po hndi ko p po alam kng papaano mgatach ng file d2 sa SB..
my alam din p0 ba kayong FREE HOSTING site n pwede kong iUpload itong projct ko..ichecheck daw po kse nla s internet kung gagana website ko..wala n po kasi akong pera pang bili ng domain at pampayad ng hosting..
MARAMING SALAMAT PO PLA SIR SA RESPONSE NIO SAKIN..ehe

Shellv, klaruhin lang natin:

You have a project na required na may forum pero ang front page ay joomla based, but you only have a registration script so far.

ok2. First reserve mo muna yung registration script. mag simula tayo sa umpisa..

STEP 1: Downlod Joomla Package from www.joomla.com
BTW: Joomla ang tawag sa framework na idadownload mo.. Program din ito sa PHP pero organized na para madali mo maedit anything you like..

STEP 2: Extract to htdocs/project
( yung htdocs/project, ikaw na mag pangalan ung ano)
STEP 3: open browser and go to http://127.0.0.1/project/
or http://localhost/project
From here makikita mo anginstallation page, so follow the simple rules from there.. Importante lang ay yun databse name username at password sa database..

STEP 4: Open browser and o to http://localhost/project
Kapag nag appear na ang default home page, ibig sabihin, successful na yon..

Installing Forum

STEP 5: Downlod PunBB from www.punbb.com
BTW: PunBB yun tawag sa forum package na yan, pero naka PHP laht ng program nun..
STEP 6: extract mo ito sa folder na htdocs/project/forum

STEP 7: Open browser and go to http://localhost/project/forum
From there, follow the simple instruction to install the forum

STEP 8: Open browser and go to http://localhost/project/forum again to see if the default forum homepage appears. If all is up and running, konti na lang gagawin mo..

Linking Forum from home page

STEP 9: Open browser and go to http://localhost/project/administrator

back to the joomla > add a top menu/ main menu link (explore mo lang yung environment/ interface ng administration page, madali lang yan)

Lagyan mo ng link sa forum http://localhost/project/forum/

STEP 10: Chec mo sa homepage http://localhost/project kung lumabas na ang link ng forum.. Click mo at kung napunta ka sa forum page, ok na yan..
Same din gawin mo sa forum administration, i link mo yung joomla homepage sa top links(just explore)

Dito na papasok yung modification ng templates/ page styles

STEP 11: Go to /project/templates/beez10/
naalimutan ko kung beez10 ba yun, basta nandun yon makikita mo, may files dun na index.php at style/template.css
yun lang ang babaguhin mo para sa overall style ng page

Yung forum, no need na siguro bguhin yung style nun.

Post here your progress para masay ok?

Good Luck!

dream13 · Oct 9, 2011

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

tanong lang po...wala po kasi akong gaanong alam sa html kaya madali lang po ito para sa inyo pero para sa akin mahirap na...

paano po ba maisasakto yung image as background, yung hindi nag-uulit ulit...ito po kasi nilalagay ko:

<html>
<head><title> My Own Web Page </title></head>
<body background="Image\img1.jpg">
</body>
</html>

natry ko na rin lagyan ng width at height pero walang nababago...

yuwishinu · Oct 9, 2011

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

dream13 said:
tanong lang po...wala po kasi akong gaanong alam sa html kaya madali lang po ito para sa inyo pero para sa akin mahirap na...

paano po ba maisasakto yung image as background, yung hindi nag-uulit ulit...ito po kasi nilalagay ko:

<html>
<head><title> My Own Web Page </title></head>
<body background="Image\img1.jpg">
</body>
</html>

natry ko na rin lagyan ng width at height pero walang nababago...

Gamit ka po ng style function like CSS..kaya lang sa HTML tag mo ilalagay yung style... try this code:

<body style="background-image:url(Image\img1.jpg);background-repeat:no-repeat;background-attachment:fixed;background-position:center;" >

or you can use this one, ilgay mo sa loob ng head tag mo

<head>
<style>
body{
background-image:url(Image\img1.jpg);
background-repeat:no-repeat;
background-attachment:fixed;
background-position:center;}
</style>
</head>

:thumbsup:

jesnatividad · Oct 9, 2011

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

dream13 said:
tanong lang po...wala po kasi akong gaanong alam sa html kaya madali lang po ito para sa inyo pero para sa akin mahirap na...

paano po ba maisasakto yung image as background, yung hindi nag-uulit ulit...ito po kasi nilalagay ko:

<html>
<head><title> My Own Web Page </title></head>
<body background="Image\img1.jpg">
</body>
</html>

natry ko na rin lagyan ng width at height pero walang nababago...

css gamit ka po...

<head>
<style>
body
{
background-repeat:no-repeat;
background-position:center';
}
</style>
</head>

banMedo · Oct 11, 2011

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

yuwishinu said:
add mo ako sa facebook,
www.facebook.com/yuweeshinu

yung session mo po, bka hindi po naka generate sa login mo..kasi kailangan yun ng

session_regenerate_id(); //mag generate yung session mo
form

session_write_close(); //to close your session

master yuwishinu ganito nlng.. Gusto ko yung processo ay ganito.. The student just type their student ID (hindi nlng sila mag log in using password) then they click search button or just enter and display their information. . .Code lang saking then papaturo ako sa instructor ko kung panu mag connect. kung pwede lang po master. please... :yipee:

ecneerdivad · Oct 11, 2011

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

banMedo said:
master yuwishinu ganito nlng.. Gusto ko yung processo ay ganito.. The student just type their student ID (hindi nlng sila mag log in using password) then they click search button or just enter and display their information. . .Code lang saking then papaturo ako sa instructor ko kung panu mag connect. kung pwede lang po master. please...

here try this..

$query=mysql_query("Select * from tablename WHERE Field = '$variable'")

if(mysql_num_rows($query)> 0){
$info = mysql_fetch_array($query);
echo "<table border='0'>";
echo "<tr>";
echo "<td>MyIDnumber...$info['0']</td>";
echo "</tr></table>";
}else{
echo "No Record Found";
}

tablename = your table name on your database
$variable = hold the value of the ID you want to find
FIELD = a field on your table

try this hope it will help

marshygeek · Oct 11, 2011

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

Mga sir ask ko lang bout MySQL. Nagsave kasi ko ng script na may data na. (may laman ung mga tables ko) pero pag inoopen ko ung script sa ibang sql workbench hindi lumalabas ung mga data, pero yung mga tables nandun KASO walang laman. May sample script yung prof ko. Bat yung kanya naoopen ko may laman ung tables. Ung akin wala? Thanks in advance!

ST2011 · Oct 12, 2011

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

marshygeek said:
Mga sir ask ko lang bout MySQL. Nagsave kasi ko ng script na may data na. (may laman ung mga tables ko) pero pag inoopen ko ung script sa ibang sql workbench hindi lumalabas ung mga data, pero yung mga tables nandun KASO walang laman. May sample script yung prof ko. Bat yung kanya naoopen ko may laman ung tables. Ung akin wala? Thanks in advance!

most probable reason nyan ay yung naming convention nyo po...
i-double check nyo po sa echo/print kung anong variable name ng katumbas sa table (rows) sa database nyo po...
EXAMPLE:
Ang table (rows) ay fname, mname, lname.

Sa code nyo po dapat ganito,
$Firstname = $_POST['fname'];
$Middlename = $_POST['mname'];
$Lastname = $_POST['lname'];

echo "(kung anong format ng display mo)"
>>tapos lagay mo na yung mga variables (ex. $Firstname...etc.)

Note: wala pang validation yan, at yung code na binigay ko ay pseudo, or hindi yung actual code.
Sana po nakatulong.

PS: yung name po pala ng table nyo ay i-double check nyo po.
kung ang table ay Name, dapat ganyan din po ang ilagay nyo. Maaring typo-graphical error lang po.

Semenelinista · Oct 12, 2011

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

mga brader,

meron po ba kayong babasahin, intro - to - intermediate ng drupal? yung para sa may exp nang konti sa html/JS/PHP/CSS... salamat marami!!

-=meow=- · Oct 12, 2011

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

paturo po sana ako ng secure na log-in script using php. alam ko na po kung paano ung mag code sa pag log in, ang gusto ko lang po ay kung paano magiging secure cya sa sql injetion at ibang pang hacking Technic. sana po may maka 2long sakin

zidaine_38 · Oct 12, 2011

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

marshygeek said:
Mga sir ask ko lang bout MySQL. Nagsave kasi ko ng script na may data na. (may laman ung mga tables ko) pero pag inoopen ko ung script sa ibang sql workbench hindi lumalabas ung mga data, pero yung mga tables nandun KASO walang laman. May sample script yung prof ko. Bat yung kanya naoopen ko may laman ung tables. Ung akin wala? Thanks in advance!

Go to phpmyAdmin and make a back up file sa sql datum. also known as var dump

Then go to the other SQL workbench at i upload mo yung mga data sa phpmyAdmin

then your done

zidaine_38 · Oct 12, 2011

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

-=meow=- said:
paturo po sana ako ng secure na log-in script using php. alam ko na po kung paano ung mag code sa pag log in, ang gusto ko lang po ay kung paano magiging secure cya sa sql injetion at ibang pang hacking Technic. sana po may maka 2long sakin

•Use md5() in password
•Use addslashes(), trim(), htmlentities() for validation
•Use PDO extension for secured SQL transactions

alien06 · Oct 12, 2011

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

pahelp Poh kuya sa php, html and myswl..

case study q poh kc ay certificate of live birth......

e2 poh ung image

alien06 · Oct 12, 2011

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

e2 poh ung Code q kaya lang kulang poh ng SEARCH, UPDATE, DELETE ndi q poh alam ung code ng SEARCh, UPDATE, DELETE

<form action='haizt.php' method='post'>
<pre>

<H2 align="center">CERTIFICATE OF LIVE BIRTH<H2>
<H4 align="center">Place of Birth:<input type='text' name='pob'><H4>
<H4 align="center">City Town Or Distric:<input type='text' name='ctod'><H4>
<H4 align="center">Sex:<select name='sex'><H4>
<option>Male</option>
<option>Female</option></select>
<H4 align="center">Date of Birth:<input type='text' name='dob'><H4>
<H4 align="center">Date Recorded:<input type='text' name='dr'><H4>
<H5 align="center">FATHER OF CHILD<H5>
<H4 align="center">Full Name:<input type='text' name='fn'><H4>
<H4 align="center">Race:<input type='text' name='race'><H4>
<H5 align="center">MOTHER OF CHILD<H5>
<H4 align="center">Full Name:<input type='text' name='fn2'><H4>
<H4 align="center">Race:<input type='text' name='race2'><H4>
<H4 align="center">Date:<input type='text' name='date'><H4>
<H4 align="center"><input type='Submit' value='Submit'><H4>

<form name="search" method="post" action="<?=$PHP_SELF?>">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="fname">First Name</option>
<Option VALUE="lname">Last Name</option>
<Option VALUE="info">Profile</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
</form>

<?php
mysql_connect("localhost","root","");
mysql_query("create database mydb");
mysql_select_db("mydb");
mysql_query("create table certificate(pob varchar(20),ctod varchar(20),sex varchar(20),dob varchar(20),dr varchar(20),fn varchar(10),race varchar(10),fn2 varchar(10),race2 varchar(10),date varchar(10))");

mysql_query("insert into certificate value('" . @$_POST['pob'] . "','" . @$_POST['ctod'] . "','" . @$_POST['sex'] . "','" . @$_POST['dob'] . "','" . @$_POST['dr'] . "','" . @$_POST['fn'] . "','" . @$_POST['race'] . "','" . @$_POST['fn2'] . "','" . @$_POST['race2'] . "','" . @$_POST['date'] . "')");
$query="select *from certificate";
$result=mysql_query($query);

?>

patulong poh plzzzzz......
kelangan lang poh talaga....
slamot poh :excited:

praise:

ST2011 · Oct 13, 2011

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

-=meow=- said:
paturo po sana ako ng secure na log-in script using php. alam ko na po kung paano ung mag code sa pag log in, ang gusto ko lang po ay kung paano magiging secure cya sa sql injetion at ibang pang hacking Technic. sana po may maka 2long sakin

simple filtering po ay yung paggamit ng mysql_real_escape_string,
marami pa po yang functions used for filtering inputs.
check this site-->>click me.
you can also download this TS.-->>click me.

myroel · Oct 13, 2011

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

-=meow=- said:
paturo po sana ako ng secure na log-in script using php. alam ko na po kung paano ung mag code sa pag log in, ang gusto ko lang po ay kung paano magiging secure cya sa sql injetion at ibang pang hacking Technic. sana po may maka 2long sakin

ST2011 said:
simple filtering po ay yung paggamit ng mysql_real_escape_string,
marami pa po yang functions used for filtering inputs.
check this site-->>click me.
you can also download this TS.-->>click me.

mysql_real_escape_string din gmit ko. pero make sure n you used that function before you query your database. otherwiese useless din yan

ex.
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

ST2011 · Oct 13, 2011

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

myroel said:
mysql_real_escape_string din gmit ko. pero make sure n you used that function before you query your database. otherwiese useless din yan

ex.
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

yup..ganun po ang dapat paggamit nun...
hehe...

hakuna_matata_hm · Oct 13, 2011

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

alien06 said:

e2 poh ung Code q kaya lang kulang poh ng SEARCH, UPDATE, DELETE ndi q poh alam ung code ng SEARCh, UPDATE, DELETE

Code:

<form action='haizt.php' method='post'>
<pre>
<H2 align="center">CERTIFICATE OF LIVE BIRTH<H2>
<H4 align="center">Place of Birth:<input type='text' name='pob'><H4>
<H4 align="center">City Town Or Distric:<input type='text' name='ctod'><H4>
<H4 align="center">Sex:<select name='sex'><H4>
                     <option>Male</option>
                     <option>Female</option></select>
<H4 align="center">Date of Birth:<input type='text' name='dob'><H4>
<H4 align="center">Date Recorded:<input type='text' name='dr'><H4>
<H5 align="center">FATHER OF CHILD<H5>
<H4 align="center">Full Name:<input type='text' name='fn'><H4>
<H4 align="center">Race:<input type='text' name='race'><H4>
<H5 align="center">MOTHER OF CHILD<H5>
<H4 align="center">Full Name:<input type='text' name='fn2'><H4>
<H4 align="center">Race:<input type='text' name='race2'><H4>
<H4 align="center">Date:<input type='text' name='date'><H4>
<H4 align="center"><input type='Submit' value='Submit'><H4>

<form name="search" method="post" action="<?=$PHP_SELF?>">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="fname">First Name</option>
<Option VALUE="lname">Last Name</option>
<Option VALUE="info">Profile</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
</form>

<?php
mysql_connect("localhost","root","");
mysql_query("create database mydb");
mysql_select_db("mydb");
mysql_query("create table certificate(pob varchar(20),ctod varchar(20),sex varchar(20),dob varchar(20),dr varchar(20),fn varchar(10),race varchar(10),fn2 varchar(10),race2 varchar(10),date varchar(10))");

mysql_query("insert into certificate value('" . @$_POST['pob'] . "','" . @$_POST['ctod'] . "','" . @$_POST['sex'] . "','" . @$_POST['dob'] . "','" . @$_POST['dr'] . "','" . @$_POST['fn'] . "','" . @$_POST['race'] . "','" . @$_POST['fn2'] . "','" . @$_POST['race2'] . "','" . @$_POST['date'] . "')");
$query="select *from certificate";
$result=mysql_query($query);

?>

patulong poh plzzzzz......
kelangan lang poh talaga....
slamot pohpraise:

I made a sample layout. I never run the page. Just look over especially the queries.

Please also read the comments posted. For more detailed explaination of the functions used please visit official documentation in http://php.net/manual/en/

Code:

<?php

    /*
        Note, do not create your db and table within the script this makes your database will be created everytime you run the script.
        Thus, you will end up error everytime your run this mysql_query("CREATE database mydb");
        Instead, create it from your phpMyAdmin or other tool then use the codes below.
    */
    
    /* You can add validation in here. */
    $error = array();
    
    if ($_POST["submit"] == "Save" OR $_POST["submit"] == "Update")
    {
        if ( ! isset($_POST["pob"]) OR $_POST["pob"] == "")
        {
            $error[] = "Place of Birth is required.";
        }
        
        /* Add more validations */
    }
    elseif ($_POST["submit"] == "Delete")
    {
        if ( ! isset($_POST["pob"]) OR $_POST["pob"] == "")
        {
            $error[] = "Place of Birth is required.";
        }
        
        /* Add more validations */
    }
    elseif ($_POST["submit"] == "Search")
    {
        if ( ! isset($_POST["find"]) OR $_POST["find"] == "")
        {
            $error[] = "Search field is required.";
        }
        
        /* Add more validations */
    }
    /* End of validation */
    
    /* Check if there were no errors. Connect only to database if there were no errors to save execution and resource. */
    if ($_POST["submit"] && count($error) == 0)
    {
        mysql_connect("localhost", "root", "");
        mysql_select_db("mydb");
        
        /* Add some validation in here if your connection failed. */

        if ($_POST["submit"] == "Save")
        {
            $result = mysql_query("INSERT INTO certificate (pob, ctod, ...) VALUES ('" . $_POST["pob"] . "', '" . $_POST["ctod"] . "', ...)");
        }
        elseif ($_POST["submit"] == "Update")
        {
            $result = mysql_query("UPDATE certificate SET (pob, ctod, ...) = ('" . $_POST["pob"] . "', '" . $_POST["ctod"] . "', ...) WHERE ...");
        }
        elseif ($_POST["submit"] == "Delete")
        {
            $result = mysql_query("DELETE certificate WHERE ...");
        }
        elseif ($_POST["submit"] == "Search")
        {
            /* Construct your sql based on your fields to set. */
            $where = array("pob", "ctod");
            $sql = array();
            
            foreach ($where as $key => $value)
            {
                $sql[] = $value . " LIKE '%" . $_POST["fine"] . "%'";
            }
            
            $result = mysql_query("SELECT pob, ctod, ... FROM certificate " . (count($sql) > 0) ? "WHERE " . implode(", ", $sql) : "");
            
            /*Display your results afterwards. */
        }
        
    }
?>
<html>
    <head>
        <title>Sample Form</title>
    </head>
    <body>
        <form action="<?php echo $PHP_SELF; ?>" method="post">
            <fieldset>
                <legend>CERTIFICATE OF LIVE BIRTH</legend>
                <label>Place of Birth : <input type="text" name="pob" value="" /></label><br />
                <label>City Town or District : <input type="text" name="ctod" value="" /></label><br />
                <label>Sex : 
                    <select name="sex">
                        <option value="male">Male</option>
                        <option value="female">Female</option>
                    </select>
                </label><br />
                <label>Date of Birth : <input type="text" name="dob" value="" /></label><br />
                <label>Date Recorded : <input type="text" name="dr" value="" /></label>
            </fieldset>
            <fieldset>
                <legend>FATHER OF CHILD</legend>
                <label>Full Name : <input type="text" name="fn" value="" /></label><br />
                <label>Race : <input type="text" name="race" value="" /></label><br />
            </fieldset>
            <fieldset>
                <legend>MOTHER OF CHILD</legend>
                <label>Full Name : <input type="text" name="fn2" value="" /></label><br />
                <label>Race : <input type="text" name="race2" value="" /></label><br />
                <label>Date : <input type="text" name="date" value="" /></label>
            </fieldset>
            <p>
                <label>
                    <input type="submit" name="submit" value="Save" />
                    <input type="submit" name="submit" value="Update" />
                    <input type="submit" name="submit" value="Delete" />
                </label>
            </p>
            <fieldset>
                <legend>Search</legend>
                <label>Find : <input type="text" name="find" value="" /></label><input type="submit" name="submit" value="Search" />
            </fieldset>
        </form>
    </body>
</html>

Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok dito

Apprentice

Apprentice

Apprentice

Novice

Amateur

Novice

Proficient

Recruit

Apprentice

Professional

Recruit

Recruit

Apprentice

Apprentice

Recruit

Recruit

Professional

Apprentice

Professional

The Devotee

Similar threads