插入Mysql并获得唯一id


Insert into Mysql and get unique id

我有以下内容:index.php

<form method="get" action="rezultat.php" name="form-area" id="form-area" class="form-area" />
   <h4>Informatii despre prieten</h4>
   <input type="text" id="name" name="nu" placeholder="" maxlength="25" required />
   <input type="text" id="name" name="pr" placeholder="" maxlength="25" required />
   <input type="text" id="name" name="va" placeholder="" maxlength="2" required  />
   <input type="text" id="name" name="lo" placeholder="" maxlength="25" required />
   <h4>Informatii despre tine</h4>
   <input type="text" id="name" name="np" placeholder="" maxlength="25" required />    
   <input type="text" id="name" name="pn" placeholder="" maxlength="4" required />
   <select name="stire" required >
       <option value="Nu ai selectat">Selecteaza</option>
       <option value="0">................................ </option>
       <option value="Bautor de sperma">[MASCULIN] - Bautor de sperma </option>
       <option value="Protest in chiloti">[MASCULIN] - Protest in chiloti </option>
       <option value="Si-a taiat penisul">[MASCULIN] - Si-a taiat penisul </option>
       <option value="Masturbare in public">[MASCULIN] - Masturbare in public </option>
       <option value="Fan Facebook">[MASCULIN] - Fan Facebook </option>
       <option value="0">................................ </option>
       <option value="Prostituata anului">[FEMININ] - Prostituata anului </option>
       <option value="Cu sanii la vedere">[FEMININ] - Cu sanii la vedere </option>
       <option value="Sex oral in public">[FEMININ] - Sex oral in public </option>
       <option value="A violat un mos">[FEMININ] - A violat un mos </option>
       <option value="Miss Urzica">[FEMININ] - Miss Urzica </option>
  </select>
  <input type="submit" name="submit" value="Submit" />  
</form>

rezultat.php

    <?php include 'config.php'; include 'colectare.php'; ?>
    <? echo $link; ?> //that show url link

config.php

    <?php
    $host="localhost";
    $user_name="USER";
    $pwd="PWD";
    $database_name="DB";
    $conexiune = mysql_connect($host,$user_name,$pwd) or die("Nu ma pot conecta la MySQL!");
     mysql_select_db($database_name, $conexiune) or die("Nu gasesc baza de date");
    $adresa="http://site.com/";
    ?>

colectare.php

    <?
    $host="localhost";
    $user_name="USER";
    $pwd="PWD";
    $database_name="DB";
    $db=mysql_connect($host, $user_name, $pwd);
    if (mysql_error() > "") print mysql_error() . "<br>";
    mysql_select_db($database_name, $db);
    if (mysql_error() > "") print mysql_error() . "<br>";
      $find = array ("/ /");
      $replace = array ("+");
      $link = $adresa.'stiri.php?        pn='.ucwords($_GET["pn"]).'&nu='.ucwords($_GET["nu"]).'&pr='.ucwords($_GET["pr"]).'&va='.ucwords($_GET["va"]).'&lo='.ucwords($_GET["lo"]).'&stire='.$_GET["stire"];
      $link = preg_replace($find,$replace,$link);
      $stire = $_GET["stire"];
      $np = htmlentities($_GET['np'], ENT_QUOTES | ENT_HTML5);
      $pn = $_GET["pn"];
      $datetime = gmDate('Y-m-d H:i:s');


      $query = "insert into stiri (url, stire, np, pn, hits, datetime) values ('" . $link . "', '" . $stire . "', '" . $np . "', '" . $pn . "', '" . $hits . "',  NOW())";
    $result = mysql_query($query);
      ?>

stiri.php

    <? include_once "config.php"; ?>
      <?
      $find = array ("+");
      $replace = array ("/ /");
      $pn = ucwords($_GET["pn"]);
      $nu = ucwords($_GET["nu"]); 
      $pr = ucwords($_GET["pr"]); 
      $va = ucwords($_GET["va"]); 
      $lo = ucwords($_GET["lo"]); 
      $stire = $_GET["stire"];    
      ?>
    <?php
    if($stire == "Bautor de sperma"){  // TITLUL FARSEI
       echo include("bautor-de-sperma.php");   // PAGINA PHP A FARSEI
    }
    elseif($stire == "Protest in chiloti"){       // TITLUL FARSEI
       echo include("protest.php");   // PAGINA PHP A FARSEI
    }
    elseif($stire == "Si-a taiat penisul"){       // TITLUL FARSEI
       echo include("taiat.php");   // PAGINA PHP A FARSEI
    }
    elseif($stire == "Masturbare in public"){       // TITLUL FARSEI
       echo include("masturbare.php");   // PAGINA PHP A FARSEI
    }
    elseif($stire == "Fan Facebook"){       // TITLUL FARSEI
       echo include("facebook.php");   // PAGINA PHP A FARSEI
    }
    elseif($stire == "Prostituata anului"){       // TITLUL FARSEI
       echo include("prostituata.php");   // PAGINA PHP A FARSEI
    }
    elseif($stire == "Cu sanii la vedere"){       // TITLUL FARSEI
       echo include("sani.php");   // PAGINA PHP A FARSEI
    }
    elseif($stire == "Sex oral in public"){       // TITLUL FARSEI
       echo include("sex.php");   // PAGINA PHP A FARSEI
    }
    elseif($stire == "A violat un mos"){       // TITLUL FARSEI
       echo include("viol.php");   // PAGINA PHP A FARSEI
    }
    elseif($stire == "Miss Urzica"){    
       echo include("urzica.php");  
    }
    else
    {
      echo "Ne pare rau, insa aceasta stire nu mai exista. Vezi mai multe <a         href='http://site.ro'>AICI</a>";
    }
    ?>  

我给u和一个页面,例如urzica.php,它包含以下内容::

    <? echo $nu; ?> , <? echo $pr; ?> , <? echo $va; ?> , <? echo $lo; ?>

用这种方法,所有信息都存储在数据库中,但链接它显示所有信息,因为我使用get方法。链接是这样提供的:http://site.ro/stiri.php?pn=SOMETHING&nu=某些&pr=某些&va=某些&lo=某些&stire=选择一个

我想使用post方法,这让我的大脑变得复杂,并向我展示这样的东西:http://site.ro/stire.php?nume=NAME-从选择形式

我希望能理解一些东西伙计们

我不能100%确定你想要什么,但这个MySQL类应该会有所帮助。基本上,您在数据库上的所有操作都在这里完成,您将在MySQL INSERT命令上获得所需的唯一id:

https://gist.github.com/jbnunn/6297071

要使用它,请设置您的连接参数:

$db_host     = 'localhost';
$db_username = 'USER';
$db_password = 'PWD';
$db_database = 'DB';
$GLOBALS['db'] = new MySQL($db_host, $db_username, $db_password, $db_database);     
if(!function_exists("getDB")) {
  function getDB() {
    return($GLOBALS['db']);
  }
}

然后,在您的代码中,要求MySQL类

require_once('mysql.php')

并制作像这样的插件

$db = getDB();
$id = $db->insert("insert into stiri (url, stire, np, pn, hits, datetime) values ('" . $link . "', '" . $stire . "', '" . $np . "', '" . $pn . "', '" . $hits . "',  NOW())");

并从CCD_ 1变量中获取该行的ID。

要从数据库中获取数据,您可以通过以下方法进行查询:

$result = $db->execute("SELECT * FROM stiri WHERE id = '$id'");