|
PHP - Concatenate The Values Of Some Columns Of Csv Into One String Column Of Table
Hello,
I am trying insert the values of csv file into a table. I want to concatenate the values of some columns of csv into one String column of table by delimiting them my commas. $im="INSERT into TB1 (col1, col2 ) values ('$a[2]','$a[3]')"; $b = ""; $b=".'$a[6]'."||".'$a[7]'."||".'$a[8]'."||".'$a[9]'."; $im1=$im+"UPDATE TB1 set latlng=.'$aline'."; mysql_query($im1) OR die(mysql_error()); I need to enter the value of $a[6] till $a[9] into a string column with delimiters and insert into the column col3 of TB1 with value as $a[4]. I am stuck up here could anyone help me with this issue. Similar Tutorials
Table Issue - Multiple Location Values For User Pushes Values Out Of Row Instead Of Wrapping In Cell
PHP script return 20 UL LIST values like, < ul >
A < /ul > How to display UL LIST into row wise 5 columns like
A B C D First project in php and mysql, I've searched but can't find the answer to stringing together two numbers and a "-" without php giving me the results as it thinks I'm creating an equation. I need the string as text. Example, I need the following as a text string, id_have (INT) and id_have (INT) joined together as id_have-id_want, or, as they will be numbers, 23-45. When I use this; $havewant = $id_have . "-" . $id_have; The result will be $id_have (23) minus $id_want (45), I get -22, not what I'm looking for!!! I need the text string of "23-45" to store in a table. Thanks! Hello I have an array where i want the join values (not sum) where the date are the same This my array(var_export)
array (
0 =>
array (
0 =>
array (
0 =>
array (
'dataAula' => '2020-09-21',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 4,
),
),
1 =>
array (
1 =>
array (
'dataAula' => '2020-09-22',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 8,
),
),
2 =>
array (
2 =>
array (
'dataAula' => '2020-09-28',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 12,
),
),
3 =>
array (
3 =>
array (
'dataAula' => '2020-09-29',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 16,
),
),
4 =>
array (
4 =>
array (
'dataAula' => '2020-10-06',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 20,
),
),
5 =>
array (
5 =>
array (
'dataAula' => '2020-10-12',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 24,
),
),
6 =>
array (
6 =>
array (
'dataAula' => '2020-10-13',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 28,
),
),
7 =>
array (
7 =>
array (
'dataAula' => '2020-10-19',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 32,
),
),
8 =>
array (
8 =>
array (
'dataAula' => '2020-10-20',
'tempos' => 1,
'tempos2' => 'Terça',
'total' => 33,
),
),
),
1 =>
array (
0 =>
array (
0 =>
array (
'dataAula' => '2020-10-20',
'tempos' => 3,
'tempos2' => 'Segunda',
'total' => 3,
),
),
1 =>
array (
1 =>
array (
'dataAula' => '2020-10-27',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 7,
),
),
2 =>
array (
2 =>
array (
'dataAula' => '2020-11-02',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 11,
),
),
3 =>
array (
3 =>
array (
'dataAula' => '2020-11-03',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 15,
),
),
4 =>
array (
4 =>
array (
'dataAula' => '2020-11-09',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 19,
),
),
5 =>
array (
5 =>
array (
'dataAula' => '2020-11-10',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 23,
),
),
6 =>
array (
6 =>
array (
'dataAula' => '2020-11-16',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 27,
),
),
7 =>
array (
7 =>
array (
'dataAula' => '2020-11-17',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 31,
),
),
8 =>
array (
8 =>
array (
'dataAula' => '2020-11-23',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 35,
),
),
9 =>
array (
9 =>
array (
'dataAula' => '2020-11-24',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 39,
),
),
10 =>
array (
10 =>
array (
'dataAula' => '2020-11-30',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 43,
),
),
11 =>
array (
11 =>
array (
'dataAula' => '2020-12-07',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 47,
),
),
12 =>
array (
12 =>
array (
'dataAula' => '2020-12-14',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 51,
),
),
13 =>
array (
13 =>
array (
'dataAula' => '2020-12-15',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 55,
),
),
14 =>
array (
14 =>
array (
'dataAula' => '2021-01-04',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 59,
),
),
15 =>
array (
15 =>
array (
'dataAula' => '2021-01-05',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 63,
),
),
16 =>
array (
16 =>
array (
'dataAula' => '2021-01-11',
'tempos' => 4,
'tempos2' => 'Segunda',
'total' => 67,
),
),
),
2 =>
array (
0 =>
array (
0 =>
array (
'dataAula' => '2021-01-12',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 4,
),
),
1 =>
array (
1 =>
array (
'dataAula' => '2021-01-18',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 8,
),
),
2 =>
array (
2 =>
array (
'dataAula' => '2021-01-19',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 12,
),
),
3 =>
array (
3 =>
array (
'dataAula' => '2021-01-25',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 16,
),
),
4 =>
array (
4 =>
array (
'dataAula' => '2021-01-26',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 20,
),
),
5 =>
array (
5 =>
array (
'dataAula' => '2021-02-01',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 24,
),
),
6 =>
array (
6 =>
array (
'dataAula' => '2021-02-02',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 28,
),
),
7 =>
array (
7 =>
array (
'dataAula' => '2021-02-08',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 32,
),
),
8 =>
array (
8 =>
array (
'dataAula' => '2021-02-09',
'tempos' => 1,
'tempos2' => 'Terça',
'total' => 33,
),
),
),
)[]
So, for example i have repeated the date 2020-10-20, one with "tempos =1" and another with "tempos=3" I'm looking to have only one date with concatened tempos field Example
array (
'dataAula' => '2020-10-20',
'tempos' => 1+3,
'tempos2' => 'Terça',
'total' => 33,
),
So what i have now is this code but not getting what i need
foreach ($finalCronograma as $sub) {
$row = current($sub);
if (isset($result[$row[0]['dataAula']])) {
$result[$row[0]['dataAula']]['tempos'] .= '+' . $row[0]['tempos'];
} else {
$result[$row[0]['dataAula']] = $sub;
}
}
any help? Hi all, I have a table... id | Name | Downloads | 01 | tom | 5 02 | thomas | 2 03 | tommy | 15 I need a button in my page whcih on submit would resent the 'downloads' column so all values are set to 0, Is this possible and how if it is? Thanks for any advice I have a kind of search and react on my site. The user can search for a number in a column as below $search = mysqli_real_escape_string($link, $_POST["query"]); $query = "SELECT * FROM $table[$i] WHERE oemnr LIKE '".$search."%' ORDER BY model";
The code works fine but I want to expand the function to get match for other numbers also. The oemnr column today can be 12345 which shows up if the user type 12.... I want to expand the oemnr column as 12345/03124/34713, numbers separated with / or another character. If the user type 03... or 34... I want to find and show 12345 because it is on the same row and corresponds to the numbers on the same row. Is it possible to do in mysql? In php that kind of operation can be done with the explode function but I don't know how to use with mysql. Edited February 14 by jiggaAlthough I am deciding on the best route to go on this, I was hoping for any feedback or ideas on the best and simplest approach to the below problem: Here is my table structu old_code_1 old_code_2 new_code_1 new_code_2 prod_code_1 prod_code_2 Each of the following fields has 5 digits e.g. 00045, 12654, etc. What I need to achieve is this: Concatenate each set (of the 3 sets above) data into one variable e.g. old_code_1 + old_code_2 = 0004512654. So old_code_1 & old_code_2 would become a combined data and the same for the othe 2 sets. Then. Once concatenated, I need to compa prod_code_1+prod_code_2 with old_code_1+old_code_2 and replace prod_code_1+prod_code_2 with new_code_1+new_code_2 where matches are found. The new_code_1 & 2 are in the same row as the old_code 1 & 2. So the data is in alignment that way for comparison. Thanks for any insight or suggestions on how to make this happen in the simplest form possible. Hi, I have this script that returns the entire table including column names and the row data. However I only want certain column names and the corresponding data to be returned. Code: [Select] <?php include_once("data/mysql.php"); $mysqlPassword = (base64_decode($mysqlpword)); $db = mysql_connect("$localhost", "$mysqlusername", "$mysqlPassword") or die ("Error connecting to database"); mysql_select_db("$dbname", $db) or die ("An error occured when connecting to database"); // sending query $result = mysql_query("SELECT * FROM members"); if (!$result) { die("Query to show fields from table failed"); } $fields_num = mysql_num_fields($result); echo "<h1>Table: members</h1>"; echo "<table border='1'><tr>"; for($i=0; $i<$fields_num; $i++) { $field = mysql_fetch_field($result); echo "<td>{$field->name}</td>"; } echo "</tr>\n"; while($row = mysql_fetch_row($result)) { echo "<tr>"; foreach($row as $cell) echo "<td>$cell</td>"; echo "</tr>\n"; } mysql_query($result); ?> Any help is always appreciated I am trying to create an autocomplete form for 'city,state zip' I want to be able to search by either a distinct zip code that will show 'city, state zip' or by distinct city 'city, state' Can anyone tell me how to fix my script? $sql = "SELECT DISTINCT zip,city,state FROM `residential` WHERE `zip` LIKE '$input%' OR `city` LIKE '$input%' OR `state` LIKE '$input%' UNION SELECT DISTINCT city,state,zip FROM `residential` WHERE `zip` LIKE '$input%' OR `city` LIKE '$input%' OR `state` LIKE '$input%' UNION SELECT DISTINCT state,city,zip FROM `residential` WHERE `zip` LIKE '$input%' OR `city` LIKE '$input%' OR `state` LIKE '$input%' LIMIT $limit"; $result = mysql_query($sql); if (!$result || !mysql_num_rows($result)) exit; include_once "headers.php"; echo "<response>"; while ($row = mysql_fetch_array($result)) { $keywords = "$row[city], $row[state] $row[zip]"; echo "<keywords>". $keywords ."</keywords>"; } while ($row = mysql_fetch_array($result)) { $keywords = "$row[city], $row[state]"; echo "<keywords>". $keywords ."</keywords>"; } echo "</response>"; This: Code: [Select] echo "<pre>"; print_r($torrent->content()); echo "</pre>"; Returns: Code: [Select] Array ( [Eureka.S05E01.HDTV.XviD-ASAP\Eureka.S05E01.HDTV.XviD-ASAP.avi] => 367011826 [Eureka.S05E01.HDTV.XviD-ASAP\eureka.s05e01.hdtv.xvid-asap.nfo] => 4798 [Eureka.S05E01.HDTV.XviD-ASAP\Sample\eureka.s05e01.hdtv.xvid-asap.sample.avi] => 7883092 ) Needs to be inserted to MySQL like: In other words, the array $torrent->content() needs to be inserted to MySQL as new lines at columns "filename" and "size". Please help me.. This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=313325.0 Hello,
I've been going about reading different posts on here and other forums but so far I haven't been able to come across something that works for my purpose so after all the reading I thought I'd finally just ask. I'm rather new at php/sql queries so please bare with me.
First what I'm trying to accomplish.
I need a form with several fields (options) to fetch information from a table that will then display the results based on the options selected.
- from date
- to date
- employee name
- department
- branch
- product line
In other words, the purpose is to be able to choose a date range (from one day to up to a year or more) and then to be able to choose either ONE employee name to view statistics invididually from a given department and branch or to select a department to view all the statistics for everyone under that given department and/or brach and/or product line.
Now the tricky part is that besides fetching the records, calculations need to be made before the records are displayed and that part right here is what is giving me a huge headache.
This is the query that I have.
SELECT report_daily_id, report_date, emp_id, emp_fullname, emp_dept, emp_branch prod_line calls, tk_time, hld_time, ac_time, tran_calls, work_time, tran_rate, ah_time FROM daily_report GROUP BY emp_id, emp_fullname, emp_branch, emp_dept, prod_lineThe calculations based on the date range and one or more of the other options need to give me the following results. SUM(calls) AS 'Total Calls' SUM(tk_time) / SUM(calls) AS 'Talk Time' SUM(hld_time) / SUM(calls) AS 'Held Time' SUM(ac_time) / SUM(calls) AS 'AC Time' SUM(tran_calls) AS 'Total Trans' SUM(tran_calls) / SUM(calls) AS 'Tran Rate' SUM(ah_time) / SUM(calls) AS 'AH Time'I don't know how else to explain myself past this point but if you have any questions, perhaps I can answer it and give more details. Thank you, I created a simple search box which will query my table and match the input value to one of my columns. two of these columns store comma separated values. if i query a column other than a column which stores my csv i can see my search results. if i query a column which stores my csv i will not see results unless the search value matches the first value within the column. how would i be able to get say the second or third or forth value. here is the code i am using to query the table any help would be appreciated thanks. Code: [Select] $q = $this->db->query("SELECT * FROM table WHERE col1 LIKE 'searchvalue'". " OR col2 LIKE 'searchvalue'". " OR col3 LIKE 'searchvalue'". " OR col4 LIKE 'searchvalue'". " OR FIND_IN_SET('searchvalue', col5) > 0 ". " OR FIND_IN_SET('searchvalue', col6) > 0"); 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 there, I am working on a page. That has all the products listed on it. Every product has a Shipping profile associated with it. Whenever a new product is created, we assign a Shipping profile to that new Product. And its product ID is then inserted into the Shipping profile table. Note: One Shipping Profile can have multiple Products under it. The scenario is that when we create the 2nd product and assign Shipping Profile and insert the 2nd product ID to Shipping Profile, the old value gets replaced with the new ProductID. We just need to somehow append the new ProductID to the existing ProductIDs in the Shipping Profile table. We can do an Update query but that will replace the Old Product ID with the new ProductID. Here we just need to append the new Product ID to the Old product ID. eg ............................... Shipping Profile Table| `````````````````` ShippingProfileID ProductID 1 1,4,6 2 3,7 Now at the moment, the ProductID gets stored but it just replaces the Old product ID. We just need to append to the existing IDs Any comments or feedback are always welcomed. Thank you! I am trying to find a loop type script that starts at a particular row in a particular column in an excel file and keeps adding values in each row until the last value is reached. I have searched and am pretty new to loops. can anyone point me in the right direction please? Hello, I am trying to add all rows in the same column together. So here is the basic scheme: id l column1 1 l 1 2 l 2 3 l 3 Second table id l variable1 1 l 3 2 l 5 3 l 6 I basically want to add 5+3+6 and set it to a variable named '$total'. Would this be done using while loops? Here is the code I have been messing with. $sql="SELECT column1 from table1 where id='$userid'"; // userid would be set near the top of the page $sql2=mysql_query($sql,$conn); while($rows=mysql_fetch_array($sql2)){ $getid = $rows['column1']; $sql3="SELECT variable1 FROM table2 where id='$getid'"; $sql4=mysql_query($sql3,$conn); while($items=mysql_fetch_array($sql4)){ // Then I'm getting lost... } } Can you at least see what I am trying to do? I'm not even sure if this is the right approach, any help would be appreciated! Hi, I have this form currently setup and is showing the value from the table. <form action="updaterates.php" method="post"> <table width="350"> <tr> <td width="100">7 Nights</td> <td width="100"><input type="text" name="rates1" value="<?php echo ($row['rates1']); ?>" maxlength="3" size="3"></td> </tr> </table> </form> What do I need to do in order for it to update the value in the table... Thanks in advance... Hi
I am very new to PHP & Mysql.
I am trying to insert values into two tables at the same time. One table will insert a single row and the other table will insert multiple records based on user insertion.
Everything is working well, but in my second table, 1st Table ID simply insert one time and rest of the values are inserting from 2nd table itself.
Now I want to insert the first table's ID Field value (auto-incrementing) to a specific column in the second table (only all last inserted rows).
Ripon.
Below is my Code:
<?php
$con = mysql_connect("localhost","root","aaa");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("ccc", $con);
$PI_No = $_POST['PI_No'];
$PO_No = $_POST['PO_No'];
$qry = "INSERT INTO wm_order_entry (
Order_No,
PI_No,
PO_No)
VALUES(
NULL,
'$PI_No',
'$PO_No')";
$result = @mysql_query($qry);
$val1=$_POST['Size'];
$val2=$_POST['Style'];
$val3=$_POST['Colour'];
$val4=$_POST['Season_Code'];
$val5=$_POST['Dept'];
$val6=$_POST['Sub_Item'];
$val7=$_POST['Item_Desc'];
$val8=$_POST['UPC'];
$val9=$_POST['Qty'];
$N = count($val1);
for($i=0; $i < $N; $i++)
{
$profile_query = "INSERT INTO order_entry(Size,
Style,
Colour,
Season_Code,
Dept,
Sub_Item,
Item_Desc,
UPC,
Qty,
Order_No
) VALUES( '$val1[$i]','$val2[$i]','$val3[$i]','$val4[$i]','$val5[$i]','$val6[$i]','$val7[$i]','$val8[$i]','$val9[$i]',LAST_INSERT_ID())";
$t_query=mysql_query($profile_query);
}
header("location: WMView.php");
mysql_close($con);
?>
Output is attached.Hi, I have downloads that are available for users. They can click the links to download the file. Once they do this, I have a query that updates the number of downloads that file has received. I need to create a query that adds up all the rows Total Downloads. So for example: i have 3 rows: Name - Total Downloads First - 2 Second - 23 Third - 7 Using the query for these rows would give me an amount of 32. Any idea how to do this? I don't want to have to create a new column to find the total number of downloads. Any other ways? |
|||||||