BLHTML.org

BLHTML.org / Web Programming / BLHTML / BLHTML Manual / BLHTML funktion list / BLHTML funktion list /

 
  SQLGET 3113 0
#SQLGET# is an admin, database function
Rights to use this function #SQLGET#:
  • Only Admin Accounts

  • #SQLGET#:
  • Hämtar ett or flera value from databasen
  • Kan hämta data from table pictures (that not har key field)
  • Forum sets #SYSTEM[forum]# to 1 for att forhindra att #SQLGET# används in forum
  • #SQLGET# can ej läsa password in table member

  • values:  defaults:  description:
    valueSQL fråga som can läsa ett field
    typetype=show shows only svaret
    blhtmlblhtml=on BLHTML executes value
    returnreturn=variable stores the results in $variable

    Ett field en variable:
    #SQLGET value(select no from pictures where user='$user' and no=$pic) return=pic#
    // Lagrar outcome from no to variable $pic

    Lagra in arrayer

    Returnera hela sökoutcome:
    #SQLGET value(select * from product where id=$id)#
    // Lagrar contents in fielden: $0, $fieldname1, $1, $fieldname2, $2 and $fieldname3 osv...

    Lagra array[-] with fieldindex:
    #SQLGET value(select id, user, rubric from Artiklar where id=1) return(A[-])# // Lagrar $A[0], $A[1] and $A[2]

    A: #$A#<br>
    A[+]: #$A[+]#<br>
    A[*]: #$A[*]#

    Returns:
    A: Array
    A[+]: 1 BLHTML (Web Programmering)
    A[*]: 0 1 1 BLHTML 2(Web Programmering)

    Lagra array[+] with fieldname:
    #SQLGET value(select id, user, rubric from Artiklar where id=1) return(B[+])# // Lagrar $B[id], $B[user] and $B[rubric]

    B: #$B#<br>
    B[+]: #$B[+]#<br>
    B[*]: #$B[*]#

    Returns:
    A: Array
    A[+]: 1 BLHTML (Web Programmering)
    A[*]: id 1 user BLHTML rubric(Web Programmering)

    Lagra array[*] with fieldindex and fieldname:
    #SQLGET value(select id, user, rubric from Artiklar where id=1) return(C[*])#
    // Lagrar $C[0], $C[id], $C[1], $C[id], $C[2] and $C[rubric]

    C: #$C#<br>
    C[+]: #$C[+]#<br>
    C[*]: #$C[*]#

    Returns:
    C: Array
    C[+]: 1 1 BLHTML BLHTML (Web Programmering) (Web Programmering)
    C[*]: 0 1 id 1 1 BLHTML user BLHTML 2(Web Programmering) rubric(Web Programmering)

    More information:
  • #FIELD#
  • #READ#
  • Array handling
  • array
  • #ARRAY#
  • BLHTML forum  


    apache MySQL PHP No to software patents! BLHTML
    © 2003, 2010 BLHTML
    This page is created with BLHTML in 0.0704 seconds