BLHTML.org

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

 
  INSERT 2996 0
Rights to use this function #INSERT#:
  • Data Magager

    • #INSERT# Inserts data in the current accounts table.
    • Fast insert: #INSERT(postdata)# postdata skall vara ordnad efter fielden in current table
    • Detect insert: #INSERT() id(8) field(data)# updatear/insert field in current table
      om nothing värde for field() sätts field=$field
    • Andvänds of Administrera Databas -> Create script to make intallations script for datapage

    • $blhtml_insert sätt to 1 if post updated, if post inte blir updated sätts $blhtml_insert to 0
    Example Fast INSERT:
    #SYSTEM[whoami] return=blhtml_id#

    #FIELDMIN id($blhtml_id) name(id) key=true type=H8 null=false auto_increment=true#
    #FIELDMIN id($blhtml_id) name(txt) type=str len=24#

    // Create/update field id and txt

    #INSERT("1", "Some text")#
    #INSERT("2", "this is post no two")#
    #INSERT("3", "Last post")#
    // insert 3 post into local table

    #FIELDMIN# Create a 2 field id and txt
    #INSERT(postdata)# insert data direkt with SQL INSERT

    Example Detect INSERT:
    #INSERT() id=1 txt(Some text)#
    #INSERT() txt(this is post no two) id=2#
    // Field don't need to be fixed

    #$txt(Last post)#
    #INSERT() id=3#
    // field txt=$txt

    Update samma field
  • If inte post, skrivs a new post
  • If post, updates posten
  • Fält behöver ej ordnas efter fieldordningen in table
  • If ej field txt=värde sätts field of variable $txt

  • More information:
  • #FIELDMIN#
  • MySQL INSERT
  • BLHTML forum  


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