note 126983 added to book.pdo
| From: | tamer at tameryigit dot com | Date: | Tue, 12 Apr 2022 21:27:33 +0000 |
| Subject: | note 126983 added to book.pdo | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-218241@lists.php.net to get a copy of this message | ||
Hocam merhaba kusura bakmayın sizi rahatsız ediyorum. Ãzür Dilerim
AÅaÄıdaki gibi bir iÅlem yapmak istiyorum. bana bu konuda yardımcı ola
bilirmisiniz.
update komutunu beceremedim.
<?php
$server = "192.168.100.199,5214"; //kaynak
$database = "TAREKSDB";
$kullaniciadi = "sa";
$sifre = "Show1234*";
try {
$baglan = new PDO("sqlsrv:Server=$server;Database=$database", $kullaniciadi, $sifre);
} catch ( PDOException $e ){
echo $e->getMessage();
}
if ($baglan) {
// echo "ERP BaÄlantı BaÅarılı";
}else {
echo "ERP BaÅarısız";
}
?>
<?php
try {
$db=new
PDO("mysql:host=localhost;dbname=tameryigitcomtr;charset=utf8",'eticaret','T1a2m3e4r5');
//hedef
echo "Siteye BaÄlantınız BaÅarılı"
} catch (PDOException $e) {
echo $e->getMessage();
}
?>
<?php
update oc_product_description set language_id = kaynak..language_id where
hedef..language_id=kaynak..language_id;
update oc_product_description set name = kaynak..name where hedef..name=kaynak..name;
update oc_product_description set description = kaynak..description where
hedef..description=kaynak..description;
update oc_product_description set tag = kaynak..tag where hedef..tag=kaynak..tag;
update oc_product_description set meta_title = kaynak..meta_title where
hedef..meta_title=kaynak..meta_title;
update oc_product_description set meta_description = kaynak..meta_description where
hedef..meta_description=kaynak..meta_description;
update oc_product_description set meta_keyword = kaynak..meta_keyword where
hedef..meta_keyword=kaynak..meta_keyword;
----
Server IP: 45.112.84.4
Probable Submitter: 80.90.5.135 (proxied: 78.179.236.219)
----
Manual Page -- https://php.net/manual/en/book.pdo.php
Edit -- https://main.php.net/note/edit/126983
Del: integrated -- https://main.php.net/note/delete/126983/integrated
Del: useless -- https://main.php.net/note/delete/126983/useless
Del: bad code -- https://main.php.net/note/delete/126983/bad+code
Del: spam -- https://main.php.net/note/delete/126983/spam
Del: non-english -- https://main.php.net/note/delete/126983/non-english
Del: in docs -- https://main.php.net/note/delete/126983/in+docs
Del: other reasons-- https://main.php.net/note/delete/126983
Reject -- https://main.php.net/note/reject/126983
Search -- https://main.php.net/manage/user-notes.php