Jump to content

dodgeitorelse3

Members
 View Profile  See their activity

  • Posts

    248

  • Joined

  • Last visited

  • Days Won

    4

 Content Type 

Posts posted by dodgeitorelse3

    Transitioning from Xampp

    in PHP Coding Help

    Posted · Edited by dodgeitorelse3
    added more content

    Have you tried putting this code into a php file and running it to see what you have?

      

    <?php

// Show all information, defaults to INFO_ALL
phpinfo();

?>

     

    in your web browser use edit/find in page and search for mysqlnd. That would be for firefox browser. Chrome browser would be search/find

    Could really use some basic assistance, please!

    in PHP Coding Help

    Posted · Edited by dodgeitorelse3

    changing your code from php short tag to <?php  and then adding error reporting and display errors as such displays 

    <?php
	error_reporting(E_ALL);
	ini_set('display_errors', '1');

     

    Warning: require_once(/var/www/vhosts/worldwide-gaming.com/httpdocs/squirrelcart/pre_common.php): failed to open stream: No such file or directory in /var/www/html/ProdFeedGen.php on line 6

    Fatal error: require_once(): Failed opening required '/var/www/vhosts/worldwide-gaming.com/httpdocs/squirrelcart/pre_common.php' (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/ProdFeedGen.php on line 6

    and does not print code to screen.

    These errors show for me due to the fact I am not using a full url to get to your require once file.

    I'm getting a session error

    in PHP Coding Help

    Posted · Edited by dodgeitorelse3
    Added more context.

    We know no more now than we did when you posted the 3 files. We already understood that is the file with the error. Please provide all 4 files using the actual file names and without any sensitive information that is in them. I have a suspicion you have not followed the majority of the advice you have already been given. There is obviously a mistake (or many) that is causing the error. It will be very hard for you to solve the error if you are going to pick and choose what advice is given.

    I'm getting a session error

    in PHP Coding Help

    Posted · Edited by dodgeitorelse3

    instead of saying first file, second file and third file use the actual file name. I am curious if your form is actually posting to second file (denetim.php)  and which file is your redirect (header("Location:sayfam.php")). The clearer you are determines the quickest path to your answer.

    not sure what to do with action equals index.php

    in PHP Coding Help

    Posted · Edited by dodgeitorelse3
    typo

    Using sort will sort numbers. so I if enter 12345 into input box results will be 12345. If I do same thing again then result will be the same. Without using sort, the numbers will be returned in different orders each time using same input of 12345.

    However entering more than 5 digits, lets say 1 through 9, then it will return 2 sets of numbers. the first set with 5 numbers and the second set with the remaining 4 numbers. So depending on what you are expecting for results depends on the code you use.

    How to pass parameter from HTML to PHP?

    in PHP Coding Help

    Posted 

    <?php
    if (!empty($from) && !empty($to)) {
?>
   <div class="card">
      <div class="card-datatable table-responsive card-body">
          <div class="col-md-12" >
              <table class="table dataTable" id="myTable2">
                  <thead>
                      <tr>
                          <th>Product</th>
                          <th>Amount</th>
                          <th>US$</th>
                      </tr>
                  </thead>
                  <tbody class="tbody">
                      <?= $tdata ?>
                  </tbody>
              </table>
          </div>				
      </div>					
  </div>
<?php
    }
?>

    I think that is what you need

     

     

    Query Multiple Tables using 1 common field

    in MySQL Help

    Posted

    @Barand I marked your  reply as a solution. There were actually 2 solutions, the first was the SQL tutorials in your signature and the second was your post about 

    19 hours ago, Barand said:

    Better to use fetch assoc() to get arrays with just the column names as keys

    Thank you very much.

    This post also turned into a database normalization issue and I am still working on that.

    Query Multiple Tables using 1 common field

    in MySQL Help

    Posted

    The query has Original_Name. I changed to fetch_assoc and now do not have the duplicate field values. Now I have to work on the normalization. Using design for database I currently have fails when I try to join all the tables. Thank you for that fix Barand. I tried to send sql files in message but I get the error too big. There are 1929 entries and file size of mapnames table is biggest weighing in at 600 kb. second biggest is 223 kb and the last five sql files are 100 kb or less.

     

    Query Multiple Tables using 1 common field

    in MySQL Help

    Posted

    Is it possible to run a query to get data from multiple tables where they have only 1 common field name?

    Below are images of the field names for each table as well as the web and database server info.

    If possible which join would I use?

    I can get 2 tables to return data using 

    SELECT id, size, Original_Name, resource, disabled, tickmark, image, type, creator, modder, beta, final, modded, classification, sf, tod, weather, es2
			FROM
				mapnames
					INNER JOIN mapnames_tooltips USING (id)
					ORDER BY id Asc"

    however this gives me double entries in array.

      

    Array
(
    [0] => Array
        (
            [0] => 1
            [id] => 1
            [1] => 11441673
            [size] => 11441673
            [2] => Border.aao
            [Original_Name] => Border.aao
            [3] => 2_8_5_default, abr, blannick, chevy, crypt, ffat, kool, rapidfire, vanoke, spectrum
            [resource] => 2_8_5_default, abr, blannick, chevy, crypt, ffat, kool, rapidfire, vanoke, spectrum
            [4] => 0
            [disabled] => 0
            [5] => 1
            [tickmark] => 1
            [6] => ../../gsreaders/lgsl/lgsl_files/maps/aarmy/armygame/border.jpg
            [image] => ../../gsreaders/lgsl/lgsl_files/maps/aarmy/armygame/border.jpg
            [7] => PVP
            [type] => PVP
            [8] => Richard Starr
            [creator] => Richard Starr
            [9] => 
            [modder] => 
            [10] => N
            [beta] => N
            [11] => Y
            [final] => Y
            [12] => N
            [modded] => N
            [13] => LAND
            [classification] => LAND
            [14] => N
            [sf] => N
            [15] => DAY
            [tod] => DAY
            [16] => HAZY
            [weather] => HAZY
            [17] => N
            [es2] => N
            [18] => 0
            [slots] => 0
        )

    [1] => Array
        (
            [0] => 2
            [id] => 2

    This gives me double entries though.

    Any advice would be greatly appreciated.

     

    web server.png

    db server.png

    locale.png

    mapnames.png

    modifications.png

    objectives.png

    terrain.png

    tooltips.png

    vehicles.png

×
×
  • Create New...

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.