Re: problem s edna funkcijka
| From: | Bogomil Shopov | Date: | Mon, 03 Jan 2005 14:54:43 +0000 |
| Subject: | Re: problem s edna funkcijka | ||
| References: | 1 2 3 4 5 | Groups: | php.general.bg php.general.bg |
| Request: | Send a blank email to general-bg+get-214@lists.php.net to get a copy of this message | ||
Здравей,
За да правиш заявка към MySQL сървъра, той трябва да знае
къде искаш да
направиш insert. Затова трябва да му укажеш коя е базата
данни. Това
става с функцията:
mysql_select_db(името на базата);
в твоя случай е
mysql_select_db($DB);
Логиката е следната:
1) връзваш се към базата с mysql_connect();
2) избираш базата данни с mysql_select_db();
3) изпълняваш заявка със mysql_query();
Това е
Успешна година
Богомил
Viktor Popov wrote:
> Zdravej Bogomile,
>
> Moje li da mi obiasnish kakvo tochno triabva da napravia s tozi kod?
>
> Blagodaria ti!
>
> Viktor
>
>
> "Bogomil Shopov" <bogomil@spisanie.com> wrote in message
> news:20050103103630.13848.qmail@pb1.pair.com...
>
>>Здравей
>>
>><code>
>>mysql_pconnect ($DB_SERVER, $DB_LOGIN, $DB_PASSWORD) or
>>die(mysql_error());
>>mysql_select_db(DB);
>>mysql_db_query(query) or die (mysql_error());
>></code>
>>
>>Viktor Popov wrote:
>>
>>>Zdravej!
>>>
>>>Blagodaria ti za otgovora smenih funkciata taka:
>>>
>>>function doReg($fname1="",$family1="",$company1="",
>>>$MOL1="",
>>>$dannum1="",
>>>
>>>$bulstat1="", $phone1="", $email1="",
>>>$username1="", $password1="",
>>>$payment1="",
>>>
>>>$maillist1="", $Addr1="", $City1="",
>>>$zipcode1="", $Country1="",
>>>$shippingName1="",
>>>
>>>$shippingFamily1="", $shippingphone1="",
>>>$shippingAddr1="",
>>>$shippingcity1="",
>>>
>>>$shippingzipcode1="", $shippingCountry1="")
>>>{
>>>
>>> mysql_pconnect ($DB_SERVER, $DB_LOGIN, $DB_PASSWORD) or
>>>die(mysql_error());
>>> mysql_select_db($DB) or die(mysql_error());
>>> mysql_query( "insert into users(name,family,company, MOL, taxnum,
>>>bulstat,
>>>phone, email, username, password, payment, maillist, Addr, City, zipcode,
>>>Country,
>>>shippingName, shippingFamily, shippingphone, shippingAddr, shippingcity,
>>>shippingzipcode, shippingCountry)
>>>values('$fname1','$family1','$company1',
>>>'$MOL1', '$dannum1', '$bulstat1', '$phone1',
>>>'$email1', '$username1',
>>>'$password1', '$payment1', '$maillist1',
>>>'$Addr1', '$City1', '$zipcode1',
>>>'$Country1','$shippingName1','$shippingFamily1',
>>>'$shippingphone1','$shippingAddr1', '$shippingcity1',
>>>'$shippingzipcode1',
>>>'$shippingCountry1')")
>>>or die (mysql_error());
>>>
>>>}
>>>
>>>Dava mi slednoto saobshtenie:
>>>"No Database Selected"
>>>
>>>Globalnite parametri sa opisani v "common.inc" i sa vkliucheni kakto vav
>>>daila s funkciite "functions.php", taka i v formata "register.php"
>>>po
>>>slednia nachin:
>>>
>>>require 'common.inc';
>>>
>>>common.inc izglejada taka:
>>>
>>><?php
>>> $DB_SERVER="localhost";
>>> $DB_LOGIN="admin";
>>> $DB_PASSWORD="******";
>>> $DB="emagazine";
>>> $HTTP_HOST="localhost:3000";
>>> $DOCROOT="emagazine";
>>>
>>>?>
>>>
>>>
>>>Znaesh li zashto ne moje da ne raboti?
>>>
>>>Blagodaria ti predvaritelno!
>>>
>>>Viktor