User Profile

Collapse

Profile Sidebar

Collapse
dreamy
dreamy
Last Activity: Nov 4 '09, 04:20 AM
Joined: Jul 20 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • dreamy
    started a topic how to update record with 2 tables?
    in PHP

    how to update record with 2 tables?

    i have 2 tables,
    1. account
    -id,
    -accounttypeid,
    -name

    2. accounttype
    -accounttypeid,
    -type.

    i can add record by join the table,
    but if i need update record, it cant,
    can some 1 help me?
    how to update?
    thz

    Code:
    <html><head></head>
<body>
<?php
$jenis =$_POST['accounttypeid'];

$connect =mysql_connect("localhost","root","")
    ...
    See more | Go to post
    Last edited by Dormilich; Sep 14 '09, 08:23 AM. Reason: Please use [code] tags when posting code
    • dreamy
      replied to how to insert excel file to mysql?
      in PHP
      i hv done the upload file with the csv type,
      but now,
      after upload a csv file,
      data hv insert into database
      izit can delete a row data from database?
      See more | Go to post

        Leave a comment:

      • dreamy
        replied to how to insert excel file to mysql?
        in PHP
        ok, can i ask another question about DOMdocument,

        if i put like this

        Code:
        $dom = DOMDocument::load( $_FILES['file']['tmp_name'] );
$rows = $dom->getElementsByTagName( 'Row' );
        it come out error
        Fatal error: Undefined class name 'domdocument' in c:\

        so,
        izit i need add...
        can tell me? thz
        See more | Go to post
        Last edited by Dormilich; Sep 4 '09, 04:35 AM. Reason: Please use [code] tags when posting code

          Leave a comment:

        • dreamy
          replied to how to insert excel file to mysql?
          in PHP
          still cant get it,
          can tell more detail, thz.
          See more | Go to post

            Leave a comment:

          • dreamy
            replied to how to insert excel file to mysql?
            in PHP
            ok, i hv seen the tutorial aldy,

            but can i ask a question is 'mysqli'
            if i apply mysqli, it will face the problem



            if i change mysqli to mysql
            the problem will come out such as



            can i ask for the solution? thz...
            See more | Go to post

              Leave a comment:

            • dreamy
              started a topic how to insert excel file to mysql?
              in PHP

              how to insert excel file to mysql?

              Can i ask how to insert a file into mysql?

              what the different between basename, getElementsByTa gName, DOMdocument and $_FILES?

              how to apply it?

              thz.
              See more | Go to post
              • dreamy
                replied to How to encrypt and decrypt password in php
                in PHP
                is that the pass_hash, salt as a field in database?

                And strcmp is for?

                Thz

                but why that any user which not in database also can login?
                See more | Go to post

                  Leave a comment:

                • dreamy
                  replied to How to encrypt and decrypt password in php
                  in PHP
                  ok thanks,
                  but there is an error
                  Warning: mysql_num_rows( ): supplied argument is not a valid MySQL result resource,
                  can i know how to fixed it.thx
                  See more | Go to post

                    Leave a comment:

                  • dreamy
                    replied to How to encrypt and decrypt password in php
                    in PHP
                    And this is my changing password part.
                    Can some 1 help me? thz..

                    how i log in with the changing password than i hv change, which aldy encryted.

                    thz


                    Code:
                    <? 
session_start();

$user = $_SESSION['username'];

if ($user)
{
	//user is logged in
	if (@$_POST['submit'])
	{
	//check fields
	$oldpassword = md5($_POST['oldpassword']);
                    ...
                    See more | Go to post
                    Last edited by Dormilich; Aug 20 '09, 05:59 AM. Reason: Please use [code] tags when posting code

                      Leave a comment:

                    • dreamy
                      replied to How to encrypt and decrypt password in php
                      in PHP
                      if that my string in database there is already encryted,
                      and how i retrieve it out?

                      this is my ori login code without the adding any encypt

                      Code:
                      <?
session_start(); 

$username= $_POST['username'];
$password= $_POST['password'];

if($username && $password)
{
	$connect = mysql_connect("localhost","root","") or die ("Couldn't
                      ...
                      See more | Go to post

                        Leave a comment:

                      • dreamy
                        started a topic How to encrypt and decrypt password in php
                        in PHP

                        How to encrypt and decrypt password in php

                        can i ask
                        how to encrypt an password in php code?
                        then how to decrpty it after encrypt?

                        thanks
                        See more | Go to post
                        • dreamy
                          replied to Code produces blank page
                          in PHP
                          mean?
                          sending $Link instead of the $Query?

                          can tell me more? thz Canabeez.
                          See more | Go to post

                            Leave a comment:

                          • dreamy
                            replied to Code produces blank page
                            in PHP
                            ok, but how ro solve tat
                            You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #3' at line 1,

                            can u help me? thz
                            See more | Go to post

                              Leave a comment:

                            • dreamy
                              replied to how to sum the total of the column
                              in PHP
                              ok, i try it.
                              thz dormilich
                              See more | Go to post

                                Leave a comment:

                              • dreamy
                                replied to Code produces blank page
                                in PHP
                                ok, i try to change my text name.
                                ['name'] exact same wif my text file name.
                                thz ya, dheerajjoshim
                                See more | Go to post

                                  Leave a comment:

                                • dreamy
                                  replied to Code produces blank page
                                  in PHP
                                  Dear, dheerajjoshim
                                  if i put $name=$_POST ['name'];
                                  and i hv try this before, but it will get the error of undefined index.
                                  can i know why and ['name'] is the text name, rite?

                                  And Dear code green,
                                  i aldy change the isSet ti isset.
                                  and, u hv suspect i hv missing bracket, can gv me the tips?

                                  The last,
                                  beside the undefined text error, i also hv
                                  You have an error in your...
                                  See more | Go to post

                                    Leave a comment:

                                  • dreamy
                                    replied to SQL Question
                                    in PHP
                                    Dear, dheerajjoshim
                                    thz and sorry.
                                    ok, i need to store different data to different field.
                                    but when retireve all different data is in same page.

                                    i got find the code as using method JOIN or LEFT JOIN.

                                    but i still can get error.

                                    i have aldy set the primary key and the foreign key,
                                    then how to recall the data by using primary key and foreign key?

                                    can i know the different...
                                    See more | Go to post

                                      Leave a comment:

                                    • dreamy
                                      replied to SQL Question
                                      in PHP
                                      Can i ask how to get data to store in multiple table?
                                      and retrieve from multiple table?

                                      i got try many time but still got error.

                                      thz
                                      See more | Go to post

                                        Leave a comment:

                                      • dreamy
                                        replied to Code produces blank page
                                        in PHP
                                        Dear Canabeez

                                        if i follow ur way to put as
                                        $name = isset($_POST['name']) ? $_POST['name'] : false;

                                        but it will come out an error Parse error: parse error, expecting `','' or `')''

                                        so?
                                        See more | Go to post

                                          Leave a comment:

                                        • dreamy
                                          replied to how to sum the total of the column
                                          in PHP
                                          ok,
                                          i have try
                                          <?
                                          total=0;
                                          $total += $row['amount'];
                                          print $total;
                                          ?>

                                          and it can total up all the value.
                                          but it print every line.

                                          how can i print under the column?
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...