What's new
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

sir hakuna.. :weep: baka last na checking mamaya.. hohoho..
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

jerjerjerjanjanjan said:
Good Day!! I have a table named sales and salesdetails..At present its accumulating data for almost 200 rows /day on sales and 2000rpws/day on salesdetails. My problem is what is tha maximum rows for a table?
Click to expand...


From MYSQL Reference Manual Feature

Scalability and Limits:

  • Support for large databases. We use MySQL Server with databases that contain 50 million records. We also know of users who use MySQL Server with 200,000 tables and about 5,000,000,000 rows.
  • Support for up to 64 indexes per table (32 before MySQL 4.1.2). Each index may consist of 1 to 16 columns or parts of columns. The maximum index width is 1000 bytes (767 for InnoDB); before MySQL 4.1.2, the limit is 500 bytes. An index may use a prefix of a column for CHAR, VARCHAR, BLOB, or TEXThttp://127.0.0.1:8001/mySQL/data-types.html#blob column types.
Click to expand...
 
Last edited:
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

bracers said:
sir ganun pa rin may lumalabas pa rin na codings >_< ano kaya problema d2, browser kaya..., na test ko na din kasi sa google chrome ganun din:upset:
Click to expand...

Read my comment dun sa last else{}
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

hakuna_matata_hm said:
hAHAHA copy & paste lang talaga oh?

di man lang alam ano gamit ng var_dump() ng PHP?

search po nyo yan sir, makakatulong yan sa inyo specially when debugging.
Click to expand...



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

acohzikyut said:
foreach ($users as $key => $value) /* fetch the array users not the username. */
{
if ($key == $username && $value == $password) /* Added condition if username is a valid user and has valid password. */
{
return true;
}
else
{
return false;
}
}
}

user_valid(){
header('Location: home.php');
}



/* Missing }. */
?>


dun sa mising ko ilalagay?


foreach ($users as $key => $value) /* fetch the array users not the username. */
{
if ($key == $username && $value == $password) /* Added condition if username is a valid user and has valid password. */
{
return true;
}
else
{
return false;
}
}
}

/* Missing }. */
?>
Click to expand...


Naku! gumawa ka ng function valid_user() e di mo naman pala alam paano gamitin?

On my previous codes.

After sa last } /* Missing */


Add mo ang code na to.

Code: 
    /*
     $username - ito yong variable na ina.signan mo ng $_POST["username"];
     $password - ito yong variable na ina.signan mo ng $_POST["password"];
    */
    if (user_valid($username, $password))
    {
        header("Location: home.php");
        exit;
    }
    else
    {
        /* Walang gagawin. */
    }
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

sir hakuna ask ko lang kung bakit may lumalabas na
0 => string '009' (length=3)
1 => string '010' (length=3)
after deleting the selected checkboxes.
den kapag edit ko ayaw naman ma edit,
im pretty sure may kinalaman to sa array eh, ung mag aassign ata un, penge naman sample sir, para sundan ko salamat :)
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

bracers said:
sir hakuna ask ko lang kung bakit may lumalabas na
0 => string '009' (length=3)
1 => string '010' (length=3)
after deleting the selected checkboxes.
den kapag edit ko ayaw naman ma edit,
im pretty sure may kinalaman to sa array eh, ung mag aassign ata un, penge naman sample sir, para sundan ko salamat :)
Click to expand...


Bakit may lumabas na parang garbage string?

First nag.read ka na ba ng var_dump()?

I put that, in order for you do debug and check if tama ba yong values na dapat ma receive mo. Remove that var_dump() and you will be ok na.

Di naman talaga ma.edit yong code ko. Tignan mo?

(field1, field2) = ('value1', 'value2')
Click to expand...

Yong naka.lagay sa queries ko. Hahaha pati ba naman yon di mo pinalitan? Modify it to make your codes edit your records.

I only put the algo and idea how to deal with it. Di yan talaga mag.rurun. And I never run it with PHP. I only coded it.
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

<?php
$username = $_REQUEST['username'];
$password = $_REQUEST['password'];
function user_valid($username, $password)
{
global $users;

$users = array(
"maver" => "maver",
"pogi" => "pogi",
"nice" => "nice",
"super" => "super",
"lala" => "lala",
);

foreach ($users as $key => $value)
{
if ($key == $username && $value == $password)
{
if (user_valid($username, $password))
{
header('Location: home.php');
exit();
}
else
{
return false;
}
}
}


/* Missing }. */
?>

sir tama ba? :( hina ko talaga sa webprog :weep:
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

<?php
$username = $_REQUEST['username'];
$password = $_REQUEST['password'];
function user_valid($username, $password)
{
global $users;

$users = array(
"maver" => "maver",
"pogi" => "pogi",
"nice" => "nice",
"super" => "super",
"lala" => "lala",
);

foreach ($users as $key => $value)
{
if ($key == $username && $value == $password)
{
if (user_valid($username, $password))
{
header('Location: home.php');
exit();
}
else
{
return false;
}
}
}


/* Missing }. */
?>

sir tama ba? :( hina ko talaga sa webprog :weep:
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

hakuna_matata_hm said:
Bakit may lumabas na parang garbage string?

First nag.read ka na ba ng var_dump()?

I put that, in order for you do debug and check if tama ba yong values na dapat ma receive mo. Remove that var_dump() and you will be ok na.

Di naman talaga ma.edit yong code ko. Tignan mo?



Yong naka.lagay sa queries ko. Hahaha pati ba naman yon di mo pinalitan? Modify it to make your codes edit your records.

I only put the algo and idea how to deal with it. Di yan talaga mag.rurun. And I never run it with PHP. I only coded it.
Click to expand...



yap napansin ko nga un sir eh, ung ilalagay ba sa field is yung column name sa mysql? :noidea:
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

acohzikyut said:
<?php
$username = $_REQUEST['username'];
$password = $_REQUEST['password'];
function user_valid($username, $password)
{
global $users;

$users = array(
"maver" => "maver",
"pogi" => "pogi",
"nice" => "nice",
"super" => "super",
"lala" => "lala",
);

foreach ($users as $key => $value)
{
if ($key == $username && $value == $password)
{
if (user_valid($username, $password))
{
header('Location: home.php');
exit();
}
else
{
return false;
}
}
}


/* Missing }. */
?>

sir tama ba? :( hina ko talaga sa webprog :weep:
Click to expand...


Code: 
<?php
    $username = $_REQUEST['username'];
    $password = $_REQUEST['password'];

    function user_valid($username, $password)
    {
        global $users;

        $users = array(
            "maver"    => "maver",
            "pogi"    => "pogi",
            "nice"    => "nice",
            "super"    => "super",
            "lala"    => "lala"
        );

        foreach ($users as $key => $value)
        {
            if ($key == $username && $value == $password)
            {
                return TRUE;
            }
            else
            {
                return FALSE;
            }
        }
    }

    if (user_valid($username, $password))
    {
        header("Location: home.php");
        exit;
    }
    else
    {
        echo "Invalid account.";
    }
?>

Ganyan lang ka simple.

Lol, mahina sa webprogramming? Alin ba kaibahan nyan sa desktop or server? They were just the same programming. Di yan alibi. Ang pinaka.basic na dapat mo matutunan is the logic, para kahit anong language alam mo paano e.handle. You will be needing nalang kung ano yong possible equivalence ng C code into Java code.


Dati, when our teacher gave us Quick Sort exercise sa VB, nag.search sa net eh walang result. We found a C quick sort. Hahaha we convert it to VB. :D
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

function user_valid($username, $password)
{
global $users;

$users = array(
"maver" => "maver",
"pogi" => "pogi",
"nice" => "nice",
"super" => "super",
"lala" => "lala",
);

foreach ($users as $key => $value)
{
if ($key == $username && $value == $password)
{
return true;
}
else
{
return false;
}
}
}

ganyan yung code na nakita ko kay mam .. :) kaso di ko na alm yung next

den mag cecreate ako ng "function log_in with an argument $user create a session variable named username) tapos create another function current_user with no argument that returns the value session variable username.. san ko paglalagay yan..:weep: hard to fin in google.. :( puro walang function method hoho..
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

function user_valid($username, $password)
{
global $users;

$users = array(
"maver" => "maver",
"pogi" => "pogi",
"nice" => "nice",
"super" => "super",
"lala" => "lala",
);

foreach ($users as $key => $value)
{
if ($key == $username && $value == $password)
{
return true;
}
else
{
return false;
}
}
}

ganyan yung code na nakita ko kay mam .. :) kaso di ko na alm yung next

den mag cecreate ako ng "function log_in with an argument $user create a session variable named username) tapos create another function current_user with no argument that returns the value session variable username.. san ko paglalagay yan..:weep: hard to find in google.. :( puro walang function method hoho.. thanks sa help and patient.. :weep:
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

bracers said:
yap napansin ko nga un sir eh, ung ilalagay ba sa field is yung column name sa mysql? :noidea:
Click to expand...


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.
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

okay sir try ko mona.. :)
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

yun lang sir.. mahina ako sa logic.. hilig ko lang talaga is MEDIA Or DESIGNING.. :) so ILove MMS .. :D ahahaha
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

<?php
$username = $_REQUEST['username'];
$password = $_REQUEST['password'];

function user_valid($username, $password)
{
global $users;

$users = array(
"maver" => "maver",
"pogi" => "pogi",
"nice" => "nice",
"super" => "super",
"lala" => "lala"
);

foreach ($users as $key => $value)
{
if ($key == $username && $value == $password)
{
return TRUE;
}
else
{
return FALSE;
}

if (user_valid($username, $password))
{
header("Location: home.php");
exit;
}
else
{
echo "Invalid account.";
}
}
}
?>

ito po yung form ko..
<html>
<head>
<title>Login Form</title>
</head>

<body>
<form method="post" action="auth.php">
Username: <input type="text" name="username" />

Password: <input type="password" name="password" />

<input type="submit" value="Login" />

</form>
</body>
</html>
 
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>
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

sir.. malapit ko na makuha.. :D
 
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

<?php
$username = $_REQUEST['username'];
$password = $_REQUEST['password'];


$users = array(
"maver" => "maver",
"pogi" => "pogi",
"nice" => "nice",
"super" => "super",
"lala" => "lala"
);

function user_valid($username, $password)
{
global $users;

foreach ($users as $key => $value)
{
if ($key == $username && $value == $password)
{
return TRUE;
}
else
{
return FALSE;
}
}
}

if(user_valid($username, $password))
{
header("Location: home.php");
exit;
}
else
{
echo "Invalid account.";
}

?>


SIR MEDYO INAYOS KO NA ,, pero di dahil sa inyo super mahihirapan ako.. ;)
 
You must log in or register to reply here.

Similar threads

S
Help po mga wordpress user and php masters
Replies
2
Views
331
shiapouf
S
G
Tulong Ko sa mga Website Developer.. ng...SYMB
Replies
12
Views
2K
regie180
R
xirukitepe
[PHP TUTORIAL] Simple Login, Logout, Signup and Display Functions!
2 3 4 5 6
Replies
117
Views
19K
Mar Lon
M
Back
Top Bottom