Web Development

hello dear experts, good day, 


i want to connect two pages  on which a plugin like

- participants_database or 
- wp-job-manager runs 


i want to do that via wpdb to another database :: how to combine two wp-pages - here i want to discuss a approach that works  - see https://wordpress.stackexchange.com/questions/1604/using-wpdb-to-connect-to-a-separate-database.  There are serveral options - to do that. 
- use Rest-API 
- user other methods such als the following one which i want to discuss with you 


If they are all on the same server under the same hosting account,  that is helpful. In a case like that, you could write your custom code to access the other site’s database directly. This is discussed here, and it’s quite feasible:  link: Using wpdb to connect to a separate database

see here the discussion of several approaches - which is so fruitful that i want to share it with you... - see https://wordpress.stackexchange.com/questions/1604/using-wpdb-to-connect-to-a-separate-database


[b]question[/b]: I want to connect wpdb to another database. How do I create the instance and pass it the database name/username/password?

Answer1: 134 votes  Yes it's possible. The wpdb object can be used to access any database and query any table. Absolutely no need to be Wordpress related, which is very interesting. The benefit is the ability to use all the wpdb classes and functions like get_results, etc so that there's no need to re-invent the wheel.  Here's how:



[CODE]

$mydb = new wpdb('username','password','database','localhost');

$rows = $mydb->get_results("select Name from my_table");

echo "<ul>";

foreach ($rows as $obj) :

   echo "<li>".$obj->Name."</li>";

endforeach;

echo "</ul>";[/CODE]

comment 1: you can also save time by using global $wpdb. But before firing ;[/CODE]$wpdb->get_results method,;[/CODE]

you must include wp-load.php as: [CODE]require_once('/your/wordpress/wp-load.php');[/CODE]

comment 2: Set WPDB prefix to make WP_Query and get_post to generate correct sql query by calling $mydb->set_prefix('wp_');



answer2: [ 30 votes ] Connecting to a second database is easy in WordPress, you simply create a new instance of the WPDB class and use it the same way you would use the standard $wpdb instance we all know and love.

Assuming the second database has the same login information as the main WP one you can even use the predefined constants

from wp-config.php to avoid hardcoding the login information.

[CODE]/**

 * Instantiate the wpdb class to connect to your second database, $database_name

 */

$second_db = new wpdb(DB_USER, DB_PASSWORD, $database_name, DB_HOST);

/**

 * Use the new database object just like you would use $wpdb

 */

$results = $second_db->get_results($your_query);[/CODE]



comment 1: This is somewhat redundant to Wadih's answer but I think my code example is a bit clearer and its also important to remember the db login constant's as they are almost always the right ones to use and otherwise you risk issues when moving from dev->stage->live environments where the login details might change. – jerclarke Sep 11 '10 at 20:55

comment 2: Set WPDB prefix to make WP_Query and get_post to generate correct sql query by calling [CODE]$second_db->set_prefix('wp_'); [/CODE]



answer3: [ 21 votes ] no one has said this so I thought I'd add an even easier way..as long as your additional database has the same user/pass details to access it as your wordpress database you can use the database name before the table name like this

[CODE]$query = $wpdb->prepare('SELECT * FROM dbname.dbtable WHERE 1');

$result = $wpdb->get_results($query);[/CODE]

comment 1: From my experience, this only works to get data, i.e. using SELECT. You can't insert data.

comment 2: it will not work externally,

  - see https://wordpress.stackexchange.com/questions/1604/using-wpdb-to-connect-to-a-separate-database


[b]Conclusio[/b]: well i like this approach very very much.  The good thing - i am with the sites in question - i am on the same server - so i guess that this will work for me.



see the discussion of several approaches - which is so fruitful that i want to share it with you... - see https://wordpress.stackexchange.com/questions/1604/using-wpdb-to-connect-to-a-separate-database


any idea any experience !? 

love to hear from you

class Program
 {
     private const string HUB_NAME = "ChatHub";

     private static IHubProxy HubProxy;

     static void Main(string[] args)
     {
         try
         {
             string url = "<a href="http://192.168.50.83:8062">http://192.168.50.83:8062</a>";

             var connection = new HubConnection(url);

             HubProxy = connection.CreateHubProxy(HUB_NAME);
             HubProxy.On<string, string>("send", HandleSendResponse);

             connection.StateChanged += Connection_StateChanged;
             connection.Error += Connection_Error;

             Console.WriteLine($"Connecting to hub named '{HUB_NAME}' at {url}");
             connection.Start().ContinueWith(task =>
             {
                 if (task.IsFaulted)
                 {
                     Console.WriteLine("Connection failed");
                     foreach (var ex in task.Exception.InnerExceptions)
                     {
                         Console.WriteLine(ex.Message);  // <================== EXCEPTION HERE
                     }
                 }
                 else
                 {
                     Console.WriteLine("Connection succeeded");
                 }
             });

         }
         catch (Exception e)
         {
             Console.WriteLine("EXCEPTION OCCURED" + Environment.NewLine + e.ToString());
         }

         Console.WriteLine("Press any key to quit");
         Console.ReadLine();
     }

     private static void Connection_Error(Exception obj)
     {
         Console.WriteLine($"Connection attempt threw '{obj.ToString()}'");
     }

     private static void Connection_StateChanged(StateChange obj)
     {
         Console.WriteLine($"Connection state is '{obj.NewState}'");

         if (obj.NewState == ConnectionState.Connected)
         {
             string[] args = new string[2];
             args[0] = "John Doe";
             args[1] = "Hello there!";

             HubProxy.Invoke("Send", args).ContinueWith(task =>
             {
                 if (task.IsFaulted)
                 {
                     Console.WriteLine("There was an error calling Send: {0}", task.Exception.GetBaseException());
                     Console.WriteLine(task.Status.ToString());
                 }
                 else
                 {
                     Console.WriteLine("Send Complete.");
                 }
             }).Wait();
         }
     }

     private static void HandleSendResponse(string name, string message)
     {
         Console.WriteLine($"Server returned: '{message}' from '{name}'");
     }
 }

I'm working in VS2019 on a web project and once in a while this pops up when I go to simply run the code from within Visual Studios..... I know it has something to do with permissions at the URL but in this case I'm running to loacal server from within VS.  How can my permissions change like that and what can I do to fix it? Thanks.

Hide   Copy Code
HTTP Error 403.14 - Forbidden
The Web server is configured to not list the contents of this directory.

Most likely causes:
A default document is not configured for the requested URL, and directory browsing is not enabled on the server.

Html.RenderAction("Index", "FileUpload");

Code:Index.cshtml

@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>index</title>
    <link href="~/Content/FileUpload/FileUpload.css" rel="stylesheet" />
</head>
<body>
    <div class="upload">
        <div>
            <form id="upload" method="post" action="/FileUpload/UploadFiles" enctype="multipart/form-data">

                <div id="drop">
                    <a>Upload File</a>
                    <input type="file" name="upl" multiple id="fileuploader" />
                </div>

                <ul>
                    <!-- The file uploads will be shown here -->
                </ul>

            </form>
            <script src="~/Scripts/jquery-3.1.0.min.js"></script>
            <!-- JavaScript Includes -->
            @*<script src="~/Scripts/jquery.knob.js"></script>*@
            <script src="~/Scripts/FileUpload/jquery.knob.js"></script>
            <!-- JavaScript Includes -->
            <!-- jQuery File Upload Dependencies -->
            @*<script src="~/Scripts/jquery.ui.widget.js"></script>*@
            <script src="~/Scripts/FileUpload/jquery.ui.widget.js"></script>

            @*<script src="~/Scripts/jquery.iframe-transport.js"></script>*@
            <script src="~/Scripts/FileUpload/jquery.iframe-transport.js"></script>

            @*<script src="~/Scripts/jquery.fileupload.js"></script>*@
            <script src="~/Scripts/FileUpload/jquery.fileupload.js"></script>

            <!-- jQuery File Upload Dependencies -->
            <!-- Main JavaScript file -->
            @*<script src="~/Scripts/script.js"></script>*@
            <script src="~/Scripts/script.js"></script>
            <!-- Main JavaScript file -->

        </div>
    </div>
</body>
</html>

public class FileUploadController : Controller
    {
        // GET: FileUpload
        [ChildActionOnly]
        public ActionResult Index()
        {
            return PartialView();
        }

        [HttpPost]

        public void UploadFiles()
        {
            if (Request.Files?.Count > 0)
            {
                var filesCount = Request.Files.Count;
                for (int i = 0; i < filesCount; i++)
                {
                    var file = Request.Files[i];
                    var fileName = Path.GetFileName(file.FileName);
                    var path = Path.Combine(Server.MapPath("~/Uploads/"), fileName);

                    file.SaveAs(path);
                }
            }
        }

@{.
  .
  Html.RenderAction("Index", "FileUpload");
    }

function ReloadTable()
{


    $(document).ready(function () {
        var table =  $('#DashboardTable').DataTable({

            "processing": true, // for show progress bar
            "serverSide": true, // for process server side
            "filter": true, // this is for disable filter (search box)
            "orderMulti": false, // for disable multiple column at once
            //"pageLength": 5,
        

            "ajax": {
                "url": "/Chargeback/Index",
                "type": "GET",
                "datatype": "json"
            },
            "columns": [
            { "data": "ChargebackCode" },
            { "data": "StatusName" },
            { "data": "BusinessUnitName" },
            { "data": "InvoiceCode" },
            { "data": "OrderCode" },
            { "data": "PickTicketCode" },
            { "data": "CustomerPo" },
            { "data": "AssignedDepartment" },
            { "data": "DivisionName" },
            { "data": "Customer" },
            { "data": "WarehouseName" },
            { "data": "Coordinator" },
            { "data": "ChargebackDate" },
            { "data": "ModDate" },
            { "data": "ChargebackDeadline" },
            { "data": "ChargebackCloseDate" },
            { "data": " DaysOpen" },
            { "data": "ChargebackAmount" },
            { "data": "ChargebackBalance" },
            { "data": "FaultName" },
            { "data": "ResponsibleName" }
            ]

        });
        table.ajax.reload();
    });

}

@using (Html.BeginForm("Index", "Chargeback"))
{
   <label id = "Include" > @Html.CheckBox("IncludeClosed", (bool)ViewBag.IncludeClosed, new { onChange = "ReloadTable()" }) Include Closed</label>

<table id="DashboardTable" class="table table-striped" >
    <thead>
        <tr>
            <th>Code</th>
            <th>Status</th>
            <th>Business</th>
            <th>Invoice</th>
            <th>Order</th>
            <th>Pick Tickets</th>
            <th>Customer PO</th>
            <th>Assigned</th>
            <th>Division</th>
            <th>Customer</th>
            <th>Warehouse</th>
            <th>Coordinator</th>
            <th>Open Date</th>
            <th>Last Activity</th>
            <th>Deadline</th>
            <th>Closed Date</th>
            <th>Days Open</th>
            <th>Amount</th>
            <th>Balance</th>
            <th>Fault</th>
            <th>Responsible</th>
        </tr>
    </thead>
    <tbody>
        @foreach (var item in Model)
        {
            var chargebackDeadline = item.ChargebackDeadline == null ? "" : ((DateTime)item.ChargebackDeadline).ToString("MM/dd/yyyy");
            var chargebackCloseDateAsString = item.ChargebackCloseDate == null ? "" : ((DateTime)item.ChargebackCloseDate).ToString("MM/dd/yyyy");

            <tr>
                <td>@Html.ActionLink(item.ChargebackCode, "Details", "Chargeback", new { id = item.Id }, null)</td>
                <td>@item.StatusName</td>
                <td>@item.BusinessUnitName</td>
                <td>@item.InvoiceCode</td>
                <td>@item.OrderCode</td>
                <td>@item.PickTicketCode</td>
                <td>@item.CustomerPo</td>
                <td>@item.AssignedDepartment</td>
                <td>@item.DivisionName</td>
                <td>@item.Customer</td>
                <td>@item.WarehouseName</td>
                <td>@item.Coordinator</td>
                <td>@item.ChargebackDate.ToString("MM/dd/yyyy")</td>
                <td>@item.ModDate.ToString("MM/dd/yyyy")</td>
                <td>@chargebackDeadline</td>
                <td>@chargebackCloseDateAsString</td>
                <td>@item.DaysOpen</td>
                <td>$@item.ChargebackAmount</td>
                <td>$@item.ChargebackBalance</td>
                <td>@item.FaultName</td>
                <td>@item.ResponsibleName</td>
            </tr>
        }
    </tbody>
</table>
}

<script>
    $(document).ready(function () {
        $("#DashboardTable").DataTable({

            "processing": true, // for show progress bar
            "serverSide": true, // for process server side
            "filter": true, // this is for disable filter (search box)
            "orderMulti": false, // for disable multiple column at once
            "pageLength": 5,

            "ajax": {
                "url": "/Chargeback/Index",
                "type": "GET",
                "datatype": "json"
            },

            "columnDefs":
            [{
                "targets": [0],
                "visible": false,
                "searchable": false
            },
            {
                "targets": [7],
                "searchable": false,
                "orderable": false
            },
            {
                "targets": [8],
                "searchable": false,
                "orderable": false
            },
            {
                "targets": [9],
                "searchable": false,
                "orderable": false
            }],

            "columns": [

            

            {"data":"ChargebackCode"},
            {"data":"StatusName"},
            {"data":"BusinessUnitName"},
            {"data":"InvoiceCode"},
            {"data":"OrderCode"},
            {"data":"PickTicketCode"},
            {"data":"CustomerPo"},
            {"data":"AssignedDepartment"},
            {"data":"DivisionName"},
            {"data":"Customer"},
            {"data":"WarehouseName"},
            {"data":"Coordinator"},
            {"data":"ChargebackDate"},
            {"data":"ModDate"},
            {"data":"ChargebackDeadline"},
            {"data":"ChargebackCloseDate"},
            {"data":" DaysOpen"},
            {"data":"ChargebackAmount"},
            {"data":"ChargebackBalance"},
            {"data":"FaultName"},
            {"data":"ResponsibleName"}
            ]
        });
    });
    </script>

@using (Html.BeginForm("Index", "Chargeback"))
{
   <label id = "Include" > @Html.CheckBox("IncludeClosed", (bool)ViewBag.IncludeClosed, new { onChange = "this.form.submit()" }) Include Closed</label>

<table id="DashboardTable" class="table table-striped" >
    <thead>
        <tr>
            <th>Code</th>
            <th>Status</th>
            <th>Business</th>
            <th>Invoice</th>
            <th>Order</th>
            <th>Pick Tickets</th>
            <th>Customer PO</th>
            <th>Assigned</th>
            <th>Division</th>
            <th>Customer</th>
            <th>Warehouse</th>
            <th>Coordinator</th>
            <th>Open Date</th>
            <th>Last Activity</th>
            <th>Deadline</th>
            <th>Closed Date</th>
            <th>Days Open</th>
            <th>Amount</th>
            <th>Balance</th>
            <th>Fault</th>
            <th>Responsible</th>
        </tr>
    </thead>
    <tbody>
        @foreach (var item in Model)
        {
            var chargebackDeadline = item.ChargebackDeadline == null ? "" : ((DateTime)item.ChargebackDeadline).ToString("MM/dd/yyyy");
            var chargebackCloseDateAsString = item.ChargebackCloseDate == null ? "" : ((DateTime)item.ChargebackCloseDate).ToString("MM/dd/yyyy");

            <tr>
                <td>@Html.ActionLink(item.ChargebackCode, "Details", "Chargeback", new { id = item.Id }, null)</td>
                <td>@item.StatusName</td>
                <td>@item.BusinessUnitName</td>
                <td>@item.InvoiceCode</td>
                <td>@item.OrderCode</td>
                <td>@item.PickTicketCode</td>
                <td>@item.CustomerPo</td>
                <td>@item.AssignedDepartment</td>
                <td>@item.DivisionName</td>
                <td>@item.Customer</td>
                <td>@item.WarehouseName</td>
                <td>@item.Coordinator</td>
                <td>@item.ChargebackDate.ToString("MM/dd/yyyy")</td>
                <td>@item.ModDate.ToString("MM/dd/yyyy")</td>
                <td>@chargebackDeadline</td>
                <td>@chargebackCloseDateAsString</td>
                <td>@item.DaysOpen</td>
                <td>$@item.ChargebackAmount</td>
                <td>$@item.ChargebackBalance</td>
                <td>@item.FaultName</td>
                <td>@item.ResponsibleName</td>
            </tr>
        }
    </tbody>
</table>
}