logo
down
shadow

Dynamic PHP string as MySQL table name


Dynamic PHP string as MySQL table name

Content Index :

Dynamic PHP string as MySQL table name
Tag : php , By : afds
Date : November 23 2020, 01:01 AM

I think the issue was by ths following , I have mySQL tables namely q1 , q2 , q3 and so on.... , $query="SELECT MAX(QNO) AS max2 FROM $table"; is enough

Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

Saving a option field from a dynamic MySQL populated selectbox into another MySQL Table


Tag : php , By : Angel Paunchev
Date : March 29 2020, 07:55 AM
hop of those help? can you echo $_POST['Select_Name'] and see what is its value? Maybe you are not doing it right in the
Can I see what are you doing on you controller? Also why dont you pass data from controller like a variable and do a foreach between the select command?
//codeigniter syntax

    <select class="form-control3" name="Select_Name" id="Select_Name">
        <?php foreach($var as $key):?>
            <option value="<?=$key?>"><?=$key?></option>//sth like this
        <? endforeach ?>
    </select>

Inserting dynamic table values from PHP array to MySQL table


Tag : php , By : Enrique Anaya
Date : March 29 2020, 07:55 AM
I wish this helpful for you Assuming that you have first three values already (branch, date, account_no) and $clientname is also assigned, you can use foreach(), so the script should be like this:
<?php
    $branch = 'br001';
    $date   = '2016-03-31';
    $accNo  = '0010GL001';
    $clientname = 'client_name';
    $data = array('client' => $clientname,
        'amount' => 12000,
        'balance' => 6000,
        'term' => 6,
        'maturitydate' => '2016-05-31'
    );
    foreach ($data as $field => $value) {
        $query = "INSERT INTO db_table 
                (`branch`, `date`, `account_no`, `field`, `value`) 
            VALUES 
                ('" . $branch . "', '" . $date . "', '" . $accNo . "', '" . $field . "', '" . $value . "')";
        echo $query . '<br>';
        mysqli_query($link, $query) or die(mysqli_error($link));
    }
?>
INSERT INTO db_table (`branch`, `date`, `account_no`, `field`, `value`) VALUES ('br001', '2016-03-31', '0010GL001', 'client', 'client_name')
INSERT INTO db_table (`branch`, `date`, `account_no`, `field`, `value`) VALUES ('br001', '2016-03-31', '0010GL001', 'amount', '12000')
INSERT INTO db_table (`branch`, `date`, `account_no`, `field`, `value`) VALUES ('br001', '2016-03-31', '0010GL001', 'balance', '6000')
INSERT INTO db_table (`branch`, `date`, `account_no`, `field`, `value`) VALUES ('br001', '2016-03-31', '0010GL001', 'term', '6')
INSERT INTO db_table (`branch`, `date`, `account_no`, `field`, `value`) VALUES ('br001', '2016-03-31', '0010GL001', 'maturitydate', '2016-05-31')

How to display MySql records in a table with multi-level headers in PHP. Dynamic Pivot Table in PHP using MySqli


Tag : php , By : bashmish
Date : March 29 2020, 07:55 AM
seems to work fine How do I generate Dynamic Pivot table in PHP using MySqli , You can create a new array using the mysql result
    <?php
       $output = array();
       while($result = mysqli_fetch_array( $res )) 
       {
           $key=$result['accyear'];
           if(!array_key_exists($key,$output)){
               $output[$key]=array();
               array_push($output[$key],array(
                     $result['headcode'] =array(
                         "fundamt" =>  $result['fundamt'],
                         "fundutiamt" =>  $result['fundutiamt'],  
                     ) 
               ));
           }
       }
    ?>
    print_r($output);
2019 => [ 061182 => [fundamt => 12, fundutiamt => 23] ]
        [ 961182 => [fundamt => 2, fundutiamt => 23] ]

Update table from another table using dynamic column references in MySql 5.7


Tag : mysql , By : user96271
Date : March 29 2020, 07:55 AM
this will help I came up with a solution that dynamically creates the portion of the SQL statement comparing columns (i.e. "currentTable.cost = newTable.cost") then runs an UPDATE JOIN with the dynamic list of columns.
DELIMITER //
 CREATE PROCEDURE matchCurrentToNew()
 COMMENT 'Update currentTable to match newTable'
 BEGIN

    DECLARE num_rows INT;
    DECLARE col_name TINYTEXT;
    DECLARE concatStatement TINYTEXT;
    DECLARE concatFields TINYTEXT;
    DECLARE done TINYINT DEFAULT FALSE; 

    DECLARE col_names 
      CURSOR FOR
        SELECT column_name
        FROM INFORMATION_SCHEMA.COLUMNS
        WHERE table_name = 'TASKS'
        ORDER BY ordinal_position;

    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    SET concatStatement = "";
    OPEN col_names;

    SELECT FOUND_ROWS() into num_rows;

    the_loop: LOOP

        FETCH NEXT FROM col_names    
        INTO col_name; 

        IF done THEN
          CLOSE col_names;
          LEAVE the_loop;
        END IF;

        IF col_name <> "UniqueId" AND col_name <> "ProjectId" THEN
            SET concatFields = CONCAT_WS("=",
                                     CONCAT_WS(".","currentTable",col_name),
                                     CONCAT_WS(".","newTable",col_name)
                                    );

            SET concatStatement = CONCAT(concatStatement,",",concatFields);         
        END IF;

    END LOOP the_loop;

    #     Remove comma at the beginning of the concatStatement string

    SET concatStatement = TRIM(LEADING "," FROM concatStatement);

    SET @sqlText = CONCAT(
      'UPDATE currentTable  
      JOIN newTable
      ON currentTable .UniqueId = newTable.UniqueId 
      AND currentTable .ProjectId = newTable.ProjectId
      SET ', concatStatement
    );

    PREPARE stmt FROM @sqlText;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;

 END //
 DELIMITER ;

Dynamic table creation in mysql database based on dynamic form builder


Tag : php , By : Alex S
Date : March 29 2020, 07:55 AM
Related Posts Related QUESTIONS :
  • Keeping leading zeros column Mysql
  • Current level navigation in Wordpress
  • Add a custom text to WooCommerce cart items if the product has a specific shipping class
  • Error connecting to CommissionJunction Token : [60] SSL certificate problem: unable to get local issuer certificate
  • How do I add a new key value pair to an object in PHP?
  • Http post request to php with dart
  • How to add a route in with blade into parameters of a component
  • How can i get the source of a 777 - CHMOD php file?
  • Convert 2010-04-16 16:30:00 to "Tomorrow Afternoon"
  • How can I hide a $_GET variable to be more secured in PHP?
  • Login to Gmail Inbox using Curl?
  • Upload Excel or CSV file to MySQL with PHP
  • Outlook Marking Email as Junk Email
  • Upload an image using class.upload.php via AJAX, display image in form using jQuery
  • mysql_connect() causes page to not display (WAMP)
  • How to limit a users uploaded image size using PHP
  • What's the difference whether or not to run PHP in safe mode?
  • Logging in to a website cURL
  • Using php to create a password system with chinese characters
  • PHP is not called properly in IE using set interval function in Javascript
  • How to read pdf, ppt, xl, doc files content into a string in php/python
  • php script for currency conversion
  • In PHP... best way to turn string representation of a folder structure into nested array
  • PayPal for Indian Rupees (INR) any solution
  • PHP Deployment to Live Server
  • Ideal Multi-Developer Lamp Stack?
  • How can I save an image from a file input field using PHP & MySQL?
  • Warning: array_multisort() [function.array-multisort]: Argument #1 is expected to be an array or a sort flag in
  • Connecting to external MySQL DB from a web server not running MySQL
  • Is it possible to add custom fields to a Drupal taxonomy term?
  • PHP 6.0 - Roadmap?
  • jQuery wait for ajax call to be over before continuing
  • checkUnique function?
  • How to define an n-m relation in doctrine?
  • Sort the unsorted text file and rewrite to same text file in sorted order
  • Version control a content management system?
  • How can i run Single PHP File using apache-tomcat-6.0.18?
  • Array of objects is empty when I come to retrieve one from the array
  • PHP Library: Calculate a bounding box for a given lat/lng location
  • Good Wordpress Theme/plugin for showing off code examples and scripts
  • Replace all spaces and special symbols with dash in URL using PHP language
  • globally get any field value in user table of logged in user
  • Can you get a job if you know XHTML, CSS and Basic PHP?
  • HTML Upload Form will only upload files found in the directory of the PHP file
  • Determine if a PHP array uses keys or indices
  • Are frameworks really necessary for beginners/intermediates?
  • PHP File Downloading Questions
  • Who owns a php exec tar extracted file?
  • Best way to get timezone of user based on area code
  • Mysql BETWEEN clause being ignored. No syntax error
  • Zend Framework: Getting request object in bootstrap
  • PHP + GD: imagetruecolortopalette not keeping transparency
  • Good Guide For Web App Security?
  • Creating a new wordpress post from twitter tweets
  • Query to show images with recent posts in Wordpress sidebar/widget
  • select & print multiple value from dropdown list
  • Storing a digital signature for bookings on a web based system
  • How to generate all permutations of a string in PHP?
  • How do I get the PostgreSQL PHP extension working on Windows?
  • Parsing WordPress XML, slash:comments syntax?
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com