php 如何把兩段數(shù)據(jù)庫內(nèi)容拼接？

程序開始建立兩個數(shù)據(jù)庫連接，函數(shù)mysql_query()原型：

員工經(jīng)過長期磨合與沉淀，具備了協(xié)作精神，得以通過團隊的力量開發(fā)出優(yōu)質(zhì)的產(chǎn)品。創(chuàng)新互聯(lián)建站堅持“專注、創(chuàng)新、易用”的產(chǎn)品理念，因為“專注所以專業(yè)、創(chuàng)新互聯(lián)網(wǎng)站所以易用所以簡單”。公司專注于為企業(yè)提供成都網(wǎng)站設計、成都做網(wǎng)站、微信公眾號開發(fā)、電商網(wǎng)站開發(fā)，微信平臺小程序開發(fā)，軟件定制開發(fā)等一站式互聯(lián)網(wǎng)企業(yè)服務。

resource?mysql_query?(?string?$query?[,?resource?$link_identifier?] )

方法1：在mysql_query函數(shù)中指定所用連接，即：

方法2：在sql語句中關(guān)聯(lián)所用數(shù)據(jù)庫，此時可以省略mysql_query的第二個參數(shù)，即：

php 如何用foreach 將表中數(shù)據(jù)拼接顯示

ID???u_name??price??preant_id

1?????水果????

2?????文具????

3?????荔枝?????12?????1????

4?????蘋果?????10?????1????

5?????香蕉?????5?????1????

6?????橘子?????3?????1????

7?????橙子?????6?????1????

8?????鉛筆?????.5?????2????

9?????圓珠筆?????1?????2????

10?????水筆?????5?????2????

11?????電腦配件??0?

12?????主板?????????????11????

13?????CPU?????????????11????

14?????顯卡????????????11????

15?????內(nèi)存?????????????11????

16?????顯示器??????????11????

17?????散熱風扇???????????11????

18?????硬盤??????????????11????

19?????華碩主板?????300?????12????

20?????技嘉主板?????400?????12????

21?????GTX970顯卡?????1800?????14????

22?????GTX960顯卡?????1400?????14????

23?????金士頓2G內(nèi)存?????100?????15????

24?????I3?4160?????600?????13????

25?????I5?2500K?????800?????13????

26?????AOC?19寸?????500?????16????

27?????宏基24寸?????800?????16????

28?????60G硬盤?????30?????18????

29?????80G硬盤?????40?????18????

30?????散熱400?????40?????17????

31?????散熱300?????20?????17

你數(shù)據(jù)庫設計是這樣設計..

SQL語句:

SELECT?p1.u_name?as?商品類型,p2.u_name?as?商品名稱?,p2.price?as?價格?from?product?p1,product?p2?where?p1.id=p2.preant_id

得到結(jié)果

商品類型?商品名稱????價格

水果?????荔枝?????12????

水果?????蘋果?????10????

水果?????香蕉?????5????

水果?????橘子?????3????

水果?????橙子?????6????

文具?????鉛筆?????.5????

文具?????圓珠筆?????1????

文具?????水筆?????5????

電腦配件?????主板????

電腦配件?????CPU????

電腦配件?????顯卡????

電腦配件?????內(nèi)存????

電腦配件?????顯示器????

電腦配件?????散熱風扇????

電腦配件?????硬盤????

主板?????華碩主板?????300????

主板?????技嘉主板?????400????

顯卡?????GTX970顯卡?????1800????

顯卡?????GTX960顯卡?????1400????

內(nèi)存?????金士頓2G內(nèi)存?????100????

CPU?????I3?4160?????600????

CPU?????I5?2500K?????800????

顯示器?????AOC?19寸?????500????

顯示器?????宏基24寸?????800????

硬盤?????60G硬盤?????30????

硬盤?????80G硬盤?????40????

散熱風扇?????散熱400?????40????

散熱風扇?????散熱300?????20

一個復雜的PHP表單處理方案

JS 實現(xiàn)BASE64_ENCODE 和 BASE64_DECODE

script language='javascript'

/* utf.js - UTF-8 = UTF-16 convertion

*

* Copyright (C) 1999 Masanao Izumo iz@onicos.co.jp

* Version: 1.0

* LastModified: Dec 25 1999

* This library is free. You can redistribute it and/or modify it.

*/

/*

* Interfaces:

* utf8 = utf16to8(utf16);

* utf16 = utf16to8(utf8);

*/

function utf16to8(str) {

var out, i, len, c;

out = "";

len = str.length;

for(i = 0; i len; i++) {

c = str.charCodeAt(i);

if ((c = 0x0001) (c = 0x007F)) {

out += str.charAt(i);

} else if (c 0x07FF) {

out += String.fromCharCode(0xE0 | ((c 12) 0x0F));

out += String.fromCharCode(0x80 | ((c 6) 0x3F));

out += String.fromCharCode(0x80 | ((c 0) 0x3F));

} else {

out += String.fromCharCode(0xC0 | ((c 6) 0x1F));

out += String.fromCharCode(0x80 | ((c 0) 0x3F));

}

}

return out;

}

function utf8to16(str) {

var out, i, len, c;

var char2, char3;

out = "";

len = str.length;

i = 0;

while(i len) {

c = str.charCodeAt(i++);

switch(c 4)

{

case 0: case 1: case 2: case 3: case 4: case 5: case 6: case 7:

// 0xxxxxxx

out += str.charAt(i-1);

break;

case 12: case 13:

// 110x xxxx 10xx xxxx

char2 = str.charCodeAt(i++);

out += String.fromCharCode(((c 0x1F) 6) | (char2 0x3F));

break;

case 14:

// 1110 xxxx 10xx xxxx 10xx xxxx

char2 = str.charCodeAt(i++);

char3 = str.charCodeAt(i++);

out += String.fromCharCode(((c 0x0F) 12) |

((char2 0x3F) 6) |

((char3 0x3F) 0));

break;

}

}

return out;

}

/* Copyright (C) 1999 Masanao Izumo iz@onicos.co.jp

* Version: 1.0

* LastModified: Dec 25 1999

* This library is free. You can redistribute it and/or modify it.

*/

/*

* Interfaces:

* b64 = base64encode(data);

* data = base64decode(b64);

*/

var base64EncodeChars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/";

var base64DecodeChars = new Array(

-1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1,

-1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1,

-1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, 62, -1, -1, -1, 63,

52, 53, 54, 55, 56, 57, 58, 59, 60, 61, -1, -1, -1, -1, -1, -1,

-1, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14,

15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, -1, -1, -1, -1, -1,

-1, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40,

41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, -1, -1, -1, -1, -1);

function base64encode(str) {

var out, i, len;

var c1, c2, c3;

len = str.length;

i = 0;

out = "";

while(i len) {

c1 = str.charCodeAt(i++) 0xff;

if(i == len)

{

out += base64EncodeChars.charAt(c1 2);

out += base64EncodeChars.charAt((c1 0x3) 4);

out += "==";

break;

}

c2 = str.charCodeAt(i++);

if(i == len)

{

out += base64EncodeChars.charAt(c1 2);

out += base64EncodeChars.charAt(((c1 0x3) 4) | ((c2 0xF0) 4));

out += base64EncodeChars.charAt((c2 0xF) 2);

out += "=";

break;

}

c3 = str.charCodeAt(i++);

out += base64EncodeChars.charAt(c1 2);

out += base64EncodeChars.charAt(((c1 0x3) 4) | ((c2 0xF0) 4));

out += base64EncodeChars.charAt(((c2 0xF) 2) | ((c3 0xC0) 6));

out += base64EncodeChars.charAt(c3 0x3F);

}

return out;

}

function base64decode(str) {

var c1, c2, c3, c4;

var i, len, out;

len = str.length;

i = 0;

out = "";

while(i len) {

/* c1 */

do {

c1 = base64DecodeChars[str.charCodeAt(i++) 0xff];

} while(i len c1 == -1);

if(c1 == -1)

break;

/* c2 */

do {

c2 = base64DecodeChars[str.charCodeAt(i++) 0xff];

} while(i len c2 == -1);

if(c2 == -1)

break;

out += String.fromCharCode((c1 2) | ((c2 0x30) 4));

/* c3 */

do {

c3 = str.charCodeAt(i++) 0xff;

if(c3 == 61)

return out;

c3 = base64DecodeChars[c3];

} while(i len c3 == -1);

if(c3 == -1)

break;

out += String.fromCharCode(((c2 0XF) 4) | ((c3 0x3C) 2));

/* c4 */

do {

c4 = str.charCodeAt(i++) 0xff;

if(c4 == 61)

return out;

c4 = base64DecodeChars[c4];

} while(i len c4 == -1);

if(c4 == -1)

break;

out += String.fromCharCode(((c3 0x03) 6) | c4);

}

return out;

}

//input base64 encode

function strdecode(str){

return utf8to16(base64decode(str));

}

document.write(strdecode('5L2g5aW9Iee+juWlsyE='));

/script

首先直接做成一頁，中間步驟的數(shù)據(jù)處理用JS，然后就可以正常提交，交給原系統(tǒng)的注冊處理頁面

PHP連接到數(shù)據(jù)庫表單代碼

mysql_connect("localhost","username","password");

PDO方式,比較通用

new PDO('mysql:host=localhost;dbname=db',"$username","password");

mysqli方式

new mysqli("localhost", "username", "password", "db");

odbc方式

odbc_connect("'DRIVER={SQL Server};SERVER=local;DATABASE=db", $username, $password)

new COM("ADODB.Connection");