laravel 连接同一服务器上多个数据库操作 、 连接多个不同服务器上的不同数据库操作以及多个数据库操作的事务处理
2019-11-24sad creeper
laravel 连接同一服务器上多个数据库操作 、 连接多个不同服务器上的不同数据库操作以及多个数据库操作的事务处理
！注意：标红的要注意区分开
第一步、配置.env文件（同一服务器上多个数据库）
DB_CONNECTION=pgsql
DB_HOST=IP（例如：127.0.0.1）
DB_PORT=端口号（例如：5432）
DB_DATABASE=连接的第一个数据库名（例如：user）
DB_USERNAME=账号（例如：root）
DB_PASSWORD=密码（例如：root）
DB_DATABASE2=连接的第二个数据库名（例如：user2）
DB_DATABASE3=连接的第三个数据库名（例如：user3）
第一步、配置.env文件（多个服务器上的数据库）
第二部分把不相同的改改就行了，注意区分
第二部、配置config/database.php（上面两个第一步的配置是差不多的，注意区分好就行了）
//这个是默认的
'pgsql' => [
'driver' => 'pgsql',
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '5432'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'charset' => 'utf8',
'prefix' => '',
'schema' => 'public',
'sslmode' => 'prefer',
],
//根据需求要连几个数据库就重复写下面的配置几遍，注意这里面'database'要跟 .env 里标红的相对应
'pgsql2' => [
'driver' => 'pgsql',
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '5432'),
'database' => env('DB_DATABASE2', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'charset' => 'utf8',
'prefix' => '',
'schema' => 'public',
'sslmode' => 'prefer',
],
'pgsql3' => [
'driver' => 'pgsql',
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '5432'),
'database' => env('DB_DATABASE3', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'charset' => 'utf8',
'prefix' => '',
'schema' => 'public',
'sslmode' => 'prefer',
],
第三步、使用方法
方法1：
$user1 = DB::connection('pgsql')->select("SQL语句");
$user2 = DB::connection('pgsql2')->update("SQL语句");
$user3 = DB::connection('pgsql3')->select("SQL语句");
DB::connection('pgsql3')->delete("delete from changeinfo where id=1");
DB::connection('pgsql3')->insert("insert into changeinfo(name,idcard,iccid) values ('$maxin','$cardid','$iccid')");
DB::connection('pgsql')->update("update radcheck SET value='$data' where username='$phone'");
DB::connection('pgsql3')->select("select * from changeinfo where iccid='$iccid'");
方法2：
protected $connection = 'pgsql'; //指明你要使用的连接
protected $connection = 'pgsql2'; //指明你要使用的连接
protected $connection = 'pgsql3'; //指明你要使用的连接
第四步、多个数据库操作事务处理
use socket;
DB::connection('pgsql1')->beginTransaction(); //开启
DB::connection('pgsql')->beginTransaction();
$rs1 = DB::connection('pgsql1')->update("update radcheck SET value='$data' where username='$phone'");
$rs2 = DB::connection('pgsql')->update("update radcheck SET value='$data' where username='$phone'");
if($rs1&&$rs2)
{
DB::connection('pgsql')->commit(); //提交
DB::connection('pgsql1')->commit();
return true;
}
else
{
DB::connection('pgsql')->rollback(); //回滚
DB::connection('pgsql1')->rollback();
return false;
}
阅读 1460 评论
h
https://apunto.it/user/profile/283791
hgh female dosage
3周前 ·
e
enoticias.site
hgh vs testosterone bodybuilding
3周前 ·
h
https://support.mikrodev.com/index.php?qa=user&qa_1=hatwave4
wat betekent hgh
3周前 ·
h
https://doc.adminforge.de/fTruV29ZRkuihEEI4vKpZA/
hgh anti aging dosage
3周前 ·
F
Firsturl.De
hgh iu per day
3周前 ·
h
https://notes.io/eehkx
hgh dose for men
3周前 ·
l
lit-book.ru
how long is an hgh cycle
3周前 ·
s
stackoverflow.qastan.be
first hgh cycle
3周前 ·
w
www.Divephotoguide.com
hgh injection
3周前 ·
h
https://berntsen-palm.hubstack.net/hormone-de-croissance-jusqu-c3-a0-quel-c3-a2ge-peut-on-en-b-c3-a9n-c3-a9ficier-3f
2 iu hgh per day results
3周前 ·
B
Blogfreely.Net
hgh dosage for muscle gain
3周前 ·
h
http://premiumdesignsinc.com/forums/user/writermilk89
before and after hgh pics
3周前 ·
w
www.udrpsearch.com
hgh fat loss cycle
3周前 ·
p
pads.jeito.nl
hgh dosage calculator
3周前 ·
c
coolpot.stream
hgh wirkung bodybuilding
3周前 ·
w
www.ozodagon.com
hgh versus testosterone
3周前 ·
h
https://travelersqa.com/user/lunchisland2
hgh daily dosage for bodybuilding
3周前 ·
w
www.instapaper.com
hgh cutting cycle
3周前 ·
W
Www.bitsdujour.com
testosterone vs hgh bodybuilding
3周前 ·
m
masjidwasl.com
hgh safety
3周前 ·
h
hedgedoc.info.uqam.ca
hgh x2 review
3周前 ·
h
https://platform.joinus4health.eu/
hgh anti-aging dosierung
3周前 ·
A
Apunto.It
hgh kaufen ohne rezept
3周前 ·
h
https://schoolido.lu/user/budgettop38/
is hgh bad for you
1个月前 ·
c
cuwip.ucsd.Edu
hgh hormoon
1个月前 ·
h
http://autoexotic.lv/
how much is a cycle of hgh
1个月前 ·
e
etuitionking.net
hgh cycle bodybuilding
1个月前 ·
l
luna-freedman-3.technetbloggers.de
is buying steroids online illegal
1个月前 ·
e
enregistre-le.top
where do pro bodybuilders get steroids
1个月前 ·
H
Http://Support.Roombird.Ru/
hgh bad for you
1个月前 ·
h
https://zenwriting.net/europetea63/the-anavar-candy-spot-low-dose-big-outcomes
1 iu hgh per day
1个月前 ·
h
https://musicvideo80.com
hgh anti aging dose
1个月前 ·
Ο
Οδηγίες για τη χρήση κλενβουτερόλης κατά το γυμναστικό πρόγραμμα
You may choose to both take your entire dosage once daily or cut up it in two each day. This is solely due to the near certainty that exceeding the really helpful dose will quickly bring indicators of virilization. Your expertise level and targets will significantly determine the dosage you’ll be comfy with. As A Outcome Of of liver toxicity points, higher doses than this are only beneficial to be carried out when injecting Winstrol. Each forms of Winny (oral and injectable) contain a methyl group attachment at the 17th carbon, making them C17-aa steroids that can resist liver metabolism. Importantly, deepening of the voice is thought to be irreversible (88). AAS customers considerably commonly experience erectile dysfunction (65), with 8% of topics in the HAARLEM study reporting it at baseline and 12% reporting to have skilled it throughout AAS use. Three months after ceasing AAS use and 1 year after the beginning of the AAS cycle it was reported by 14% and 1% of users, respectively. None of these modifications have been considerably different from baseline, which may be a type II error. Nevertheless, since not all AAS users completed follow up, attrition bias may additionally (partly) explain the distinction. Regardless, erectile dysfunction would possibly develop after an AAS cycle as a outcome of the transient hypogonadal state. Testosterone is generally an injectable steroid, whereas Anadrol 50 is an oral steroid. This mixture of a high-sodium food plan and the estrogenic nature of Anadrol causes water to spill outdoors the muscle cells, giving them a puffy appearance. This cycle is usually taken by novices who haven’t used Anadrol earlier than. Though Anadrol isn't generally beneficial for novices, the above cycle could additionally be tolerable as a outcome of lower doses. Overall, weight achieve may even embody water, and women should work hard after the cycle to maintain any muscle positive aspects. 10lbs of weight acquire on a 25mg/day cycle for eight weeks is achievable for females. Zits and a few virilization are possible at this dose, but if the cycle runs for no longer than eight weeks, these effects ought to fade away completely. You’ll get individuals injecting steroids as a end result of it’s perceived as more excessive and a few people think that you get better results – this isn’t at all times the case. On the flip aspect you get people who assume tablets like Anavar are less invasive and trigger less damage. For instance, and as we’ve already touched upon earlier on this submit oral steroids can result in greater liver injury. Generally you don’t realise until it’s too late – that is why you need to get regular testosterone checks and blood exams by your doctor to guard yourself from as many unfavorable consequences as possible. Trying to acquire it with no proper prescription can outcome in severe legal penalties, together with fines and potential imprisonment. The worth of Dianabol 50 mg tablets can range broadly relying on the supply, location, and whether it's purchased legally or on the black market. Nonetheless, you will want to note that purchasing Dianabol and not using a prescription is against the law in plenty of nations. Maintaining track of your progress, unwanted aspect effects, and total well-being is important when using Dianabol. Regular blood work and monitoring of vital signs might help you identify potential points early and make essential adjustments to your routine. This is a quick lived side impact but could be debilitating for some individuals because it impacts every a part of your life. This facet impact will differ between individuals, but it’s frequent for people to report a low mood, melancholy, or extreme temper swings. Testosterone can improve vascularity, and if you need to harden and dry up towards the end of the cycle, we can optionally run Anavar for two to three weeks to finish off. There are a quantity of methods to combine these two, however I like Anadrol as a kickstart when using a medium to slower-acting testosterone. You can then choose to increase your testosterone use for so long as desired, however I limit mine to 12 weeks right here. Trenbolone’s extra unwanted facet effects (and it’s a really long list) are worse than anything that Anadrol can throw at you. Your testosterone will bounce again pretty quickly with PCT following Anadrol use, whereas with Tren being a Nandrolone AAS, you'll be able to keep suppressed for months afterward. When the liver is being taxed, as a defense mechanism, the body reduces urge for food in a bid to lower the quantity of food the organ has to course of. Buying from unknown websites with no evaluations or trusting somebody at your fitness center, where nobody can vouch for the product, will increase the probabilities of being scammed. Pharmaceutical-grade Anadrol is created by scientists in a lab for medical functions. These rising levels of testosterone also provide the indicators to stop development 121. When a baby or adolescent takes anabolic steroids, the resulting artificially excessive sex hormone ranges can prematurely sign the bones to stop growing 122. Many individuals who inject anabolic steroids could use nonsterile injection techniques or share contaminated needles with different customers. This places these steroid users at risk for buying life threatening viral infections, corresponding to HIV and hepatitis B and C 111. In addition, animal fashions point out that anabolic steroids suppress the immune system, which could worsen infections 112.
1个月前 ·
r
rohitab.com
anavar stack
1个月前 ·
g
gratisafhalen.be
best muscle building pills on the market
2个月前 ·
h
http://ezproxy.cityu.edu.hk/
bodybuilding steroid alternatives
2个月前 ·
h
https://dougherty-slot-4.technetbloggers.de
side effects of anabolic steroids include
2个月前 ·
m
maps.google.com.sa
steroids good
2个月前 ·
i
images.google.bi
cons of drugs
2个月前 ·
h
https://bookmarking.stream/story.php?title=stanozolol-winstrol-cycles-outcomes-and-advantages
anavar steroid com
2个月前 ·
h
https://endpiano8.bravejournal.net
define androgens
2个月前 ·
s
school-of-safety-russia.ru
monster muscle pills
2个月前 ·
c
codimd.fiksel.info
side effects of steroids for muscle building
2个月前 ·
c
code.openmobius.com
top steroid labs
2个月前 ·
G
Gitea.Ideaopen.cn
gnc muscle growth supplements
2个月前 ·
i
ipamorelin dosage recommended
ipamorelin wells pharmacy
3个月前 ·
p
priligy amazon
I have been exploring for a little for any high-quality articles or blog posts on this kind of space . Exploring in Yahoo I ultimately stumbled upon this website. Reading this information So i'm glad to exhibit that I've an incredibly excellent uncanny feeling I discovered just what I needed. I so much definitely will make sure to do not forget this web site and give it a look regularly.
1年前 ·