PHP - Master And Local Values Phpinfo

I've been following http://nvie.com/post...branching-model, which recommends master, release, and develop branches, in addition to hotfix and feature branches. Since I work with another developer only, we did not use release branches as staging area but used everything else.   Well, to ease on merges, the new idea is as such:  use only master branch, and get rid of all others.  Feature and hotfix branches can branch off of master and be merged back into master.  So in short, only have one main branch called master, and remove the develop branch.   Since we have {local, develop, production} servers, this will not impact actual development and testing. Removing 'develop' branch will however remove that "extra" intermediate step between the master branch and feature branches   Do you see any problems with this?  Or it's "to each his own, however you want to use git, use it" type thing?

I need to configure my SMTP mail port so I can use mail() function to send out e-mails.  However, I am confused as to which php.ini to configure.  I see four files when I do a search under C:\WAMP\
php.ini (C:\wamp\bin\apache\Apache2.2.11\bin)
php.ini (C:\wamp\bin\php\php5.3.0)
php.ini-development (C:\wamp\bin\php\php5.3.0)
php.ini-production (C:\wamp\bin\php\php5.3.0)

Thanks

Hello,

I have a database with the following tables:

students       groups          exams           examDay      relation         master             detail
=======     =====          =====         =======     ======        ======          =====
idStudent    idGroup           idExam         idExDay        idRelation      idMaster          idDetail
idGroup       groupName     examName   exDate         idGroup          idGroup           idMaster
studName                                                                   idExDay          idRelation        idExam
                                                                                   idExam           idStudent
                                                                                   coursesAtt      idExDay

I am trying to make a report from the Master and Detail tables that will have the table header like this:

Group | Examination Date | Student Name | Exam1 | Exam2| .... | Exam n

in which Exam1, Exam2,... are the exams names and they had to take the values from coursesAtt column.

Is this possible? I could make a view (doing joins and group by) by the results will be displayed on row. That's why I ask for your help.

Thanks

My application has 3 user types. Admin , User and Super Admin. Users can register as either Admin or User. Each user type has different UI and functionality.
The problem:
If a particular type of user reports a problem/bug in his/her login, it is difficult to pin point to the exact problem. So if I could able to login as that user, then it will be very easy to point out the bug/problem.

So I'm looking for some kind of master password. Using any username and the master password I should be able to login AS that user.

Any suggestions..?

I want to create a master-detail page using PHP. Rather than getting data from a MYSQL database, I want to get the data from an associative array. Is this possible? Please someone show me the way forward. Please help.

Hello,

I have three arrays of integers $arrayA, $arrayB, and $arrayC.  $ArrayA is a "master array" meaning the array I need to match the other two to.  $arrayB and $arrayC are generated by my functions in the application and meet specific criteria.  As such, arrays B and C will never have any intersecting values, but both should have matches in $arrayA, and I need to generate an array which contains only the values of arrayA which match either B or C.

  After finding some documentation here (http://www.metrocomp.mocsi.eu/w3/php/func_array_intersect.html)

I tried using array_intersect :

array_intersect ($arrayA, $arrayB, $arrayC)

However this does not work as described and returns no results as there are no values which are contained in all three arrays.

I wrote the below as a work around, and it works just fine but I would think there is a better way?

$temp1 = array_intersect($arrA, $arrB);
$temp2 = array_intersect($arrA, $arrC);
$temp3 = array_merge($temp1, $temp2);
$final_array = array_unique($temp3);


Thanks for looking!
Carmen

Hello:

Seeking some input, please.

I use single-pages in my admin panel to update and maintain each corresponding page on the front end.
Code: [Select]
ADMIN = FRONT END
a_Home.php = Home.php
a_About.php = About.php
Etc...

The code is the same for each page, except I have to rename the TABLE everytime I make a new page:
Code: [Select]
<?php

include('../include/myConn.php'); //contains your mysql connection and table selection
include('../include/myCodeLib.php');
include('include/myCheckLogin.php');
include('include/myAdminNav.php');

include('ckfinder/ckfinder.php');
include('ckeditor/ckeditor.php');

if ($_SERVER['REQUEST_METHOD'] == 'POST')
{

$myTitle = mysql_real_escape_string($_POST['myTitle']);
$myDesc = mysql_real_escape_string($_POST['myDesc']);
$myHeader = mysql_real_escape_string($_POST['myHeader']);
$mySubHeader = mysql_real_escape_string($_POST['mySubHeader']);
$myPageData = mysql_real_escape_string($_POST['myPageData']);

$sql = "
UPDATE myTestimonials
   SET
      myTitle = '$myTitle',
      myDesc = '$myDesc',
      myHeader = '$myHeader',
      mySubHeader = '$mySubHeader',
      myPageData = '$myPageData'
  ";
    
mysql_query($sql) && mysql_affected_rows()
    
?>

<script language="JavaScript">
alert("This page was updated!");
location.href = "a_Testimonials.php";
</script>

<?php
}


$query=mysql_query("SELECT * FROM myTestimonials") or die("Could not get data from db: ".mysql_error());
while($result=mysql_fetch_array($query))
{
  $myTitle=$result['myTitle'];
  $myDesc=$result['myDesc'];
  $myHeader=$result['myHeader'];
  $mySubHeader=$result['mySubHeader'];
  $myPageData=$result['myPageData'];
}
?>

<!DOCTYPE HTML>

<html>

<head>

<meta name="author" content="MontyTheWebmaster.com" />
<meta charset="ISO-8859-1" />

<title>Admin Area</title>

<?php echo spAdminLinks(); ?>

</head>

<body>

<div id="siteContainer">

<div id="topContainer">
<?php echo spAdminTopMenu(); ?>
</div>

<div id="topMenuContainer">
<div id="topMenu">
<?php echo spAdminMenu(); ?>
</div>
</div>

<div id="contentContainer">


<div id="mainContent">

<h1>Editing: Testimonials</h1>

<p>

         <form method="post" action="<?php echo $PHP_SELF;?>">
         <input type="hidden" name="POSTBACK" value="EDIT">
         
         
         <div style="float: left; width: 120px; margin-right: 30px;">
         
         Page Title:
         
         </div>
         
         <div style="float: left; width: 550px;">
         
         <textarea cols="80" rows="1" name="myTitle"><?php echo $myTitle; ?></textarea>
         
         </div>

         <div style="clear: both;"><br /></div>
         

         <div style="float: left; width: 120px; margin-right: 30px;">
         
         Page Description:
         
         </div>
         
         <div style="float: left; width: 550px;">
         
         <textarea cols="80" rows="1" name="myDesc"><?php echo $myDesc; ?></textarea>
         
         </div>

         <div style="clear: both;"><br /></div>
         
         <div style="float: left; width: 120px; margin-right: 30px;">
         
         Page Header:
         
         </div>
         
         <div style="float: left; width: 550px;">
                 
         <textarea cols="80" rows="1" name="myHeader"><?php echo $myHeader; ?></textarea>
         
         </div>

         <div style="clear: both;"><br /></div>

         <div style="float: left; width: 120px; margin-right: 30px;">
         
         Page SubHeader:
         
         </div>
         
         <div style="float: left; width: 550px;">
                 
         <textarea cols="80" rows="1" name="mySubHeader"><?php echo $mySubHeader; ?></textarea>
         
         </div>

         <div style="clear: both;"><br /></div>
         
         Page Content:<br />         
         
         <textarea cols="80" id="myPageData" name="myPageData"><?php echo $myPageData; ?></textarea>




            <script type="text/javascript">
             
             CKEDITOR.replace( 'myPageData',
      {
          filebrowserBrowseUrl : 'ckfinder/ckfinder.html',
          filebrowserImageBrowseUrl : 'ckfinder/ckfinder.html?Type=Images',
          filebrowserFlashBrowseUrl : 'ckfinder/ckfinder.html?Type=Flash',
          filebrowserUploadUrl : 'ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Files',
          filebrowserImageUploadUrl : 'ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Images',
          filebrowserFlashUploadUrl : 'ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Flash'
      }
);

            </script>




       
         <br />
         
         <input type="submit" value="Submit" />

         </form>

</p>

</div>

<div style="clear: both;"></div>

</div>

<div id="footerContainer">

<?php echo spAdminFooter(); ?>

</div>

</div>

</body>

</html>

What I am curious about is how can I take this page and make it so I can add a new page, delete a page, etc. all from just one page like above?

And on the frontend, what would be the best way to display the data in a search engine friendly way (i.e. without QueryStrings like MyPage.php?id=2

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=326872.0

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=352271.0

Hi,

I would like to display my master details page links to the details pages in three columns rather than a single column.

Below is the do-while code I have thus far, and I am stuck.  Could someone please mock up this code quick, because I know it is a simple syntax error somewhere.

<?php do {
   echo "<table border='0'>";
   for ($y=1; ; $y++) {
      echo "<tr>";
      for ($x=1; $x<=3; $x++) {
         echo "<td align='left'><a href="plantdetails.php?recordID=echo $row_rsBotanicalA['PlantID'];">; echo $row_rsBotanicalA['BotanicalName']; </a></td>"
      }
      echo "</tr>";
   }
}
while ($row_rsBotanicalA = mysql_fetch_assoc($rsBotanicalA));
echo "</table>";
?>

Hi,

I am stuck. I have used dreamweaver to create a master details page with links to the details page successfully, but I would like to display the master details page results in 3 columns rather than the 1 column that dreamweaver defaults. As the site becomes richer the content will increase yielding many results, therfore the content displayed in a single column will require the users to scroll way down the page.

So, as it is now the results display as follows:

Plant1
Plant2
Plant3
Plant4
Plant5
Plant6
Plant7
Plant8
Plant9
etc...

I would like them to display as follows:
Plant1        Plant4        Plant7
Plant2        Plant5        Plant8
Plant3        Plant6        Plant9

Here is my code thus far:
<?php require_once('Connections/connGND.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_connGND, $connGND);
$query_rsBotanicalA = "SELECT * FROM plants WHERE CatIDB = 'A'";
$rsBotanicalA = mysql_query($query_rsBotanicalA, $connGND) or die(mysql_error());
$row_rsBotanicalA = mysql_fetch_assoc($rsBotanicalA);
$totalRows_rsBotanicalA = mysql_num_rows($rsBotanicalA);
?>
<table border="0" align="left">
  <?php do { ?>
    <tr>
      <td align="left"><a href="plantdetails.php?recordID=<?php echo $row_rsBotanicalA['PlantID']; ?>"> <?php echo $row_rsBotanicalA['BotanicalName']; ?>&nbsp; </a></td>
    </tr>
    <?php } while ($row_rsBotanicalA = mysql_fetch_assoc($rsBotanicalA)); ?>
</table>

Could someone help me to write this code, as I have been unsuccessful maintaining the links. I have been able get the results to display in the columsn as I would like, but I haven't been able to figure it out while maintaining the links!

Thanks.

Hi Friends ,

We have the JSON Data coming in this format,

$invoice_data = {
    "CONTACT_ID": "1",
    "INV_SERIAL_NO": "100",
    "NAME": "baby",
    "INV_DATE": "2018-06-27",
    "DUE_DATE": "2018-06-27",
    "CURRENCY": "KD",
    "SUBTOTAL": "143",
    "TAX_TOTAL": "13",
     "shipment_data": [
         {
            "SHIP_SERIAL_NO": "44",
            "MASTER_NO": "55",
            "HOUSE_NO": "88",
            "cost_revenue_items": [
                {
                    "CHARGE_REF": "tt",
                    "CURRENCY": "INR",
                    "QUANTITY": "2",
                    "SELLING_RATE": "45",
                    "EXCHANGE_RATE": "987"                                       
                },{
                    "CHARGE_REF": "ii",
                    "CURRENCY": "INR",
                    "QUANTITY": "2",
                    "SELLING_RATE": "45",
                    "EXCHANGE_RATE": "456"
                },{
                    "CHARGE_REF": "op",
                    "CURRENCY": "INR",
                    "QUANTITY": "2",
                    "SELLING_RATE": "45",
                    "EXCHANGE_RATE": "456"
                }
            ]
        }
    ]
}

How to write DELETE End-point for child data-set "cost_revenue_items". What I mean to say is how to handle the request to delete one of item from "cost_revenue_items".

When "cost_revenue_items" will be deleted ,master "invoice_data" will be updated. This update , we can handle by PUT, but how do we know under that PUT, we have to
DELETE one of "cost_revenue_items". Like how the JSON request to only delete one of "cost_revenue_items" will look like.

Will JSON request to delete "cost_revenue_items" looks like this ,if it want to delete last record :

$invoice_data = {
    "CONTACT_ID": "1",
    "INV_SERIAL_NO": "100",
    "NAME": "baby",
    "INV_DATE": "2018-06-27",
    "DUE_DATE": "2018-06-27",
    "CURRENCY": "KD",
    "SUBTOTAL": "143",
    "TAX_TOTAL": "13",
     "shipment_data": [
         {
            "SHIP_SERIAL_NO": "44",
            "MASTER_NO": "55",
            "HOUSE_NO": "88",
            "cost_revenue_items": [
                {
                    "CHARGE_REF": "tt",
                    "CURRENCY": "INR",
                    "QUANTITY": "2",
                    "SELLING_RATE": "45",
                    "EXCHANGE_RATE": "987"
                },{
                    "CHARGE_REF": "ii",
                    "CURRENCY": "INR",
                    "QUANTITY": "2",
                    "SELLING_RATE": "45",
                    "EXCHANGE_RATE": "456"
                }
            ]
        }
    ]
}

Kindly help me to know , how JSON request will look like ?

 

Thanks a lot

Dear All Members

here is my table data..

(4 Columns/1row in mysql table)

id                 order_no               order_date                  miles
310                001                   02-15-2020                MI,108.53
                                                                                     Oh,194.57
                                                                                     PA,182.22
                                                                                     WA,238.57

How to split(miles) single column into (state, miles) two columns and output like following 5 columns /4rows in mysql using php code.

(5 Columns in mysql table)
------------------------------------------------------------------------------------

id                  order_no              order_date              state      miles

310                001                   02-15-2020               MI          108.53

310                001                   02-15-2020              Oh          194.57

310                001                   02-15-2020              PA          182.22

310                001                   02-15-2020             WA          238.57
 

------------------my php code -----------

 

<?php
//invoice.php  
include('../includes/config.php');

if(isset($_POST["add"]))
{
$order_no=$_GET['order_no'];
$order_date=$_GET['order_date'];
$miles=$_POST['miles'];

$miles = explode("\r\n", $_POST["miles"]);
$newdata = "'" . implode("','", $_POST["miles"]) . "'";
$sql ="INSERT INTO tble_states_miles(order_no,order_date, miles) VALUES(:order_no, :order_date, :newdata)";

$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);
$query-> bindParam(':order_date', $order_date, PDO::PARAM_STR);
$query-> bindParam(':miles', $newdata, PDO::PARAM_STR);

$lastInsertId = $dbh->lastInsertId();
if($lastInsertId)
{
echo "<script type='text/javascript'>alert('Added Sucessfull!');</script>";
echo "<script type='text/javascript'> document.location = 'ifta_miles_calculationlist_added.php'; </script>";
}
else 
{
$error="Something went wrong. Please try again";
}

if($query->execute()) {

$sql = "update tis_invoice set flag='1' where order_no=:order_no";
$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);

$query->execute();

}
}
?>

----------------- my form code ------------------

 

 <?php
                   $order_no=$_GET['order_no'];
        $sql = "SELECT * from tis_invoice where order_no = :order_no";
        $query = $dbh -> prepare($sql);
        $query->execute(
  array(
   ':order_no'       =>  $_GET["order_no"]
  )
 );
        $result = $query->fetchAll();
        foreach($result as $row)
?>
    
                    <form method="post">
                        <table align="center" style="width: 55%">
                        <tr><td>Invoice Number</td></tr>
                        <tr><td><input type="text" name="order_no" value="<?php echo $row["order_no"]; ?>" readonly=""></td></tr>
                        <tr><td>Invoice Date</td></tr>
                        <tr><td><input type="text" name="order_no" value="<?php echo $row["order_date"]; ?>" readonly=""></td></tr>
                        <tr><td>
                               <textarea name="miles" class="form-control" rows="10" placeholder="" required></textarea>
                           </td></tr>
                           <tr><td>
                         
                            <input type="submit" name="add" class="btn btn-primary" value="Add" />
                       </td></tr></table>
                    </form>

-- Can any one help how to correct my code..present nothing inserted on table

 

Thank You

Edited February 8, 2020 by karthicbabu

Hi,

My company has 240+ locations and as such some users (general managers) cover multiple sites.  When I run a query to pull user information, when the user has multiple sites to his or her name, its adds the second / third sites to the next columns, rather than wrapping it inside the same table cell.  It also works the opposite way, if a piece of data is missing in the database and is blank, its pull the following columns in.  Both cases mess up the table and formatting.  I'm extremely new to any kind of programming and maybe this isn't the forum for this question but figured I'd give it a chance since I'm stuck.

The HTML/PHP code is below:

<table id="datatables-column-search-select-inputs" class="table table-striped" style="width:100%">

                                        <thead>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                                <th>Actions</th>

                                            </tr>

                                        </thead>

                                        <tbody>

                                            <?php

                                            //QUERY TO SELECT ALL USERS FROM DATABASE

                                            $query = "SELECT * FROM users";

                                            $select_users = mysqli_query($connection,$query);

                                            

                                            // SET VARIABLE TO ARRAY FROM QUERY

                                            while($row = mysqli_fetch_assoc($select_users)) {

                                                $user_id = $row['user_id'];

                                                $user_firstname = $row['user_firstname'];

                                                $user_lastname = $row['user_lastname'];

                                                $username = $row['username'];

                                                $user_phone = $row['user_phone'];

                                                $user_image = $row['user_image'];

                                                $user_title_id = $row['user_title_id'];

                                                $user_role_id = $row['user_role_id'];

                                            

                                                // POPULATES DATA INTO THE TABLE

                                                echo "<tr>";

                                                echo "<td>{$user_id}</td>";

                                                echo "<td>{$user_firstname}</td>";

                                                echo "<td>{$user_lastname}</td>";

                                                echo "<td>{$username}</td>";

                                                echo "<td>{$user_phone}</td>";

                                            

                                                //PULL SITE STATUS BASED ON SITE STATUS ID

                                                $query = "SELECT * FROM sites WHERE site_manager_id = {$user_id} ";

                                                $select_site = mysqli_query($connection, $query);

                                                while($row = mysqli_fetch_assoc($select_site)) {

                                                    $site_name = $row['site_name'];

                                                    echo "<td>{$site_name}</td>";

                                                }

                                                echo "<td>{$user_title_id}</td>";

                                                echo "<td>{$user_role_id}</td>";

                                                echo "<td class='table-action'>

                                                    <a href='#'><i class='align-middle' data-feather='edit-2'></i></a>

                                                    <a href='#'><i class='align-middle' data-feather='trash'></i></a>

                                                    </td>";

                                                //echo "<td><a href='users.php?source=edit_user&p_id={$user_id}'>Edit</a></td>";

                                                echo "</tr>";

                                            }   

                                            ?>

 

                                            <tr>

                                                <td>ID</td>

                                                <td>FirstName</td>

                                                <td>LastName</td>

                                                <td>Username</td>

                                                <td>Phone #</td>

                                                <td>Location</td>

                                                <td>Title</td>

                                                <td>Role</td>

                                                <td class="table-action">

                                                <a href="#"><i class="align-middle" data-feather="edit-2"></i></a>

                                                <a href="#"><i class="align-middle" data-feather="trash"></i></a>

                                                </td>

                                            </tr>

                                        </tbody>

                                        <tfoot>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                            </tr>

                                        </tfoot>

                                    </table>

Hi all,

I'm a first time poster here and I would really appreciate some guidance with my latest php challenge! I've spent the entire day googling and reading and to be honest I think I'm really over my head and need the assistance of someone experienced to advise the best way to go!

I have a multi dimensional array that looks like (see below); the array is created by CodeIgniter's database library (the rows returned from a select query) but I think this is a generic PHP question as opposed to having anything to do with CI because it related to working with arrays.

I'm wondering how I might go about searching the array below for the key problem_id and a value equal to a variable which I would provide. Then, when it finds an array with a the matching key and variable, it outputs the other values in that part of the array too.

For example, using the sample data below. How would you recommend that I search the array for all the arrays that have the key problem_id and the value 3 and then have it output the value of the key problem_update_date  and the value of the key problem_update_text. Then keep searching to find the next occurrence?

Thanks in advance, as above, I've been searching really hard for the answer and believe i'm over my head!

Output of print_r($updates);

CI_DB_mysql_result Object
(
    [conn_id] => Resource id #30
    [result_id] => Resource id #35
    [result_array] => Array
        (
        )

    [result_object] => Array
        (
        )

    [current_row] => 0
    [num_rows] => 5
    [row_data] => 
)


Output of print_r($updates->result_array());

Array
(
    [0] => Array
        (
            [problem_update_id] => 1
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Some details about a paricular issue
            [problem_update_active] => 1
        )

    [1] => Array
        (
            [problem_update_id] => 4
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Another update about the problem with an ID of 3
            [problem_update_active] => 1
        )

    [2] => Array
        (
            [problem_update_id] => 5
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of four
            [problem_update_active] => 1
        )

    [3] => Array
        (
            [problem_update_id] => 6
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of 6
            [problem_update_active] => 1
        )

    [4] => Array
        (
            [problem_update_id] => 7
            [problem_id] => 3
            [problem_update_date] => 2010-10-12
            [problem_update_text] => Some new update about the problem with the ID of 3
            [problem_update_active] => 1
        )

)