Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About madjack87

  • Rank
    ( ͡° ͜ʖ ͡°)

Profile Information

  • Gender
    Not Telling
  1. madjack87

    Php Query In loop not updating database

    Its very random when it does and doesnt work. Even when doing the exact same steps. The array that is being printed is always correct. I see no problem in the SQL queries that are stored in the array. When I tried to add error checking before I received no errors.. What do you mean by I should be using a prepared query?
  2. I am using jquery and ajax to have a drag and drop sortable table. My problem is that it only works about 10 percent of the time. Here is my js code. <script type="text/javascript"> // When the document is ready set up our sortable with it's inherant function(s) $(document).ready(function() { $("#test-list").sortable({ handle : '.handle', update : function () { var order = $('#test-list').sortable('serialize'); $("#info").load("tow_sort2.php?"+order); } }); }); </script> Here is the tow_sort2.php page: <?php include("../_includes/db_connection.php"); /** * This is where you would inject your sql into the database * but we're just going to format it and send it back */ $array =array(); foreach ($_GET['listItem'] as $position => $item) { $sql = "UPDATE tow SET tow_order = '$position' WHERE tow_id = '$item'"; $conn->query($sql); $array[] = $sql; } print_r($array); ?> Here is the array that is being printed: Array ( [0] => UPDATE tow SET tow_order = '0' WHERE tow_id = '5924' [1] => UPDATE tow SET tow_order = '1' WHERE tow_id = '5925' [2] => UPDATE tow SET tow_order = '2' WHERE tow_id = '5922' [3] => UPDATE tow SET tow_order = '3' WHERE tow_id = '5923' )
  3. madjack87

    Help with auto creation after payment

    Well in my case there are multiple users per company. They all access their companies data.. What if I want to add a completely seperate company, but I want it to be at the same URL / domain. Do I create a new folder and database for each company? I already have the system built for one company with many tables all relational. We have been using it for two years. What my question is if I want to sell this where other companies can create an account and have there own system for their company how do I go about doing that. That is where the multiple database questions come in.
  4. I am not sure what to look for to even get started. If some one could help point me in the right direction that would be appreciated. I created a customer system that tracks contracts and invoices ect. Where do I start if I would want a customer to be able to go to the website, sign up, and their own version of the system would be created. Do I just write a script that creates a new database with the correct credentials? Do all of the users access the same files but just have different database. Do I have to copy the directory of files to a specific folder for each customer? I know there must be tons of websites that once you sign up for example a calendar app that keeps your data seperate from everyone else. Any help is appreciated. Thanks Jack

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.