PHP - Insert One Table Id To Another For Loop Table Column Field.

Hi,
I'm developing an app using flash AS2 as the front end via PHP and a mySQL database at the backend on my server.

what i'm looking to do is update/insert into a table called 'cards' and at the same time update/insert into another table called 'jingle'. There is a field called 'cardID' in jingle that should be the same as the ID number created in 'cards' thus creating a link between entries in the different tables that can be called up as i choose.

hope i've been clear i just wouldn't know where to start any help would be appreciated.

MySQL client version: 5.0.91
PHPmyAdmin Version information: 3.2.4


thanks in advance

Hi,

Stuck again with the Joomla/K2 coding.  Trying to output this field in a 2 column table but failing badly.  Any help or ideas would be greatly appreciated.

     <?php if($this->item->params->get('catItemExtraFields') && count($this->item->extra_fields)): ?>
     <!-- Item extra fields -->
     <div class="catItemExtraFields">
        <h4><?php echo JText::_('K2_ADDITIONAL_INFO'); ?></h4>
        <ul>
         <?php foreach ($this->item->extra_fields as $key=>$extraField): ?>
         <?php if($extraField->value): ?>
         <li class="<?php echo ($key%2) ? "odd" : "even"; ?> type<?php echo ucfirst($extraField->type); ?> group<?php echo $extraField->group; ?>">
            
            
               <?php if ($extraField->name =='Closing date') : ?>

                    <span class="catItemExtraFieldsLabel"><?php echo $extraField->name; ?></span>
                      <span class="catItemDateCreated"><?php echo JHTML::_('date', $this->item->publish_down ); ?></span>
                    <?php else :?>
                     <span class="catItemExtraFieldsLabel"><?php echo $extraField->name; ?></span>
                    <span class="catItemExtraFieldsValue"><?php echo $extraField->value; ?></span>
       
                    <?php endif; ?>
               
         </li>
         <?php endif; ?>
         <?php endforeach; ?>
         </ul>
       <div class="clr"></div>
     </div>
     <?php endif; ?>
 

Hi,
I'm quite new to this and I'm trying to get this to line up in a table with 3 columns (unlimited rows)
I have searched and tried but I'm not having any luck.

Can any one help?
Thank you

Code: [Select]
<?php 
echo '<div class="resultados_sub_cat">';

foreach($this->subcats as $key => $subcat) {

$subcat->link = JRoute::_('index.php?option=classcliff&view=list&catid='.$subcat->id."&Itemid=".$this->Itemid);
if ($key != 0)
echo ' - ';
echo '<a href="'.$subcat->link.'">'.$subcat->name.'</a>';

} 
?>

I have a mysql table named songs with 3 columns, id, artist,title.

Most of the songs in the artist column are correct, ex:

artist
------------------
John Denver
Loretta Lynn
Shania Twain
Luke Bryan

But some of the songs in the artist column are reveresed with a comma, ex:

artist
-----------------
Dever, John
Lynn. Loretta
Twain, Shania
Bryan, Luke

Is there an easy php code snippet or mysql statement that i can use to reverse the order of first name and last name and remove the comma in the last example so the artst columd matches the first example?

I hope this makes sense, thanks, Dale.

Hello, 
I think this question is a bit of both php and mysql related. I hope I can get some help here. Especially with the mysql part. 

 

I have a table like this:

CREATE TABLE days (
    id INT AUTO_INCREMENT,
      daya INT,
      dayb INT,
    PRIMARY KEY (id)
);


INSERT INTO days VALUES
    (70, 19, 18),
    (69, 20, 17),
    (68, 24, 25),
    (67, 19, 18),   
    (66, 19, 17),    
    (65, 17, 16);

and mysql query and php snippet is this:

 $sql = "SELECT
    d1.id AS id1,
    d2.id AS id2,
    IF((d1.daya-d2.daya)=1,1,0) +
    IF((d1.daya-d2.dayb)=1,1,0) +
    IF((d1.dayb-d2.daya)=1,1,0) +
    IF((d1.dayb-d2.dayb)=1,1,0)   AS tcount
FROM days AS d1 , days AS d2
WHERE d1.id IS NOT NULL AND d2.id IS NOT NULL AND d1.id > d2.id";

  $result = $conn->query($sql);
  if ($result->num_rows > 0) {

   while($row = $result->fetch_assoc()) 
   {
        echo "<tr><td>" . $row["id1"] . "</td><td>". $row["id2"] . "</td><td>" . $row["tcount"]. 
                        "</td></tr>";   
             
    }
echo "</table>";

which gives me a table like this:

Id1  Id2   Count
50    49    1
50    48    0
49    48    0
50    47    1
49    47    1
48    47    0
50    46    1
49    46    1
48    46    0
47    46    1
50    45    1
49    45    1
48    45    0
47    45    1
46    45    1

I need to convert the table into this form: id1 goes down the first column, and id2 is in the first row.  How can i do this, please? can you give me some help? thank you!

id2    49    48    47    46    45
id1                    
50     1      0     1     1     1
49            0     1     1     1
48                  0     0     0
47                        1     1
46                              1
45                    

 

I have a table and one column has links that point to index.php?id= but I want it to display the info of that row of my database. On the index.php page i have this code Code: [Select]
<?php
include "dbaptsConfig.php";

// test id, you need to replace this with whatever id you want the result from
$id = "1";

// what you want to ask the db
$query = "SELECT * FROM `apartments` WHERE `id` = ".$id;

// actually asking the db
$res = mysql_query($query, $ms);

// recieving the answer from the db (you can only use this line if there is always only one result, otherwise will give error)
$result = mysql_fetch_assoc($res);

// if you uncomment the next line it prints out the whole result as an array (prints out the image as weird characters)
// print_r($result);

// print out specific information (not the whole array)
   echo "id: ".$result['id']."<br />";
echo "username: ".$result['username']."<br />";
   echo "type: ".$result['type']."<br />";
   echo "title: ".$result['title']."<br />";
   echo "description: ".$result['description']."<br />";  
echo "county: ".$result['county']."<br />";
   echo "town: ".$result['town']."<br />";
   echo "phone: ".$result['phone']."<br />";
   echo "rooms: ".$result['rooms']."<br />";
   echo "bath: ".$result['bath']."<br />";
   echo "squa  ".$result['square']."<br />";
echo "rent: ".$result['rent']."<br />";
echo "time: ".$result['time']."<br />";

?>I know there is something wrong with this cause I always get the same info no matter which apartment I click. Do I use the $_GET function and how do I implement this?

I have an existing two table structure where sub-data is related to main data in a many-to-one relationship.   There are several identically named columns in both tables.   (The PHP database class will return an associative array that did not deal with identical keys in the row.)   I'm LEFT JOINing the sub-data to the main-data tables.   When using a stand-alone query browser (to experiment), the display shows all columns, even those column names that appear more than once in the row.   Is there a general approach to making keys (column names) unique strictly using a MySQL SELECT statement?   Perhaps using table aliases, how can I concat the alias to the columns that come from each table?   What I am trying to avoid is giving an alias to each column in a list of column names, such as: SELECT C.name AS C_name C.numb AS C_numb D.name AS D_name D.numb AS D_numb etc.   I am wanting more like the result one could guess would be from: C.* AS C_* D.* AS D_*   Or better: * AS CONCAT(__TABLE__, '_', *) if __TABLE was a magic constant (like PHP's __LINE__, __FILE__, etc).  

Hi there,
I have a form which I want to submit data into my tables.
There are going to be 4 tables involved with this form, and these 4 tables should relate to one another in some sort of way.

My problem is either PHP or MySQL, but I keep getting a warning which I can't figure out.
I remember this warning appearing even if the code before it is wrong, therefore I am not relying on it.

This is what the error says:
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in G:\xampp\htdocs\xampp\dsa\wp3.php on line 40

Here's my code:
Code: [Select]
<html>
<head>
<title>WP3</title>
</head>
<body>
<form id="search" name="search" id="search" method="get" action="searchresults.php" />
<input type="text" name="terms" value="Search..." />
<input class="button" type="submit" name="Search" value="Search" />
</form>

<?php

include_once('connectvars.php');

$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);


if(isset($_POST['report'])){

$firstname = mysqli_real_escape_string($dbc, trim($_POST['firstName']));
$middlename = mysqli_real_escape_string($dbc, trim($_POST['middleName']));
$lastname = mysqli_real_escape_string($dbc, trim($_POST['lastName']));
$image = mysqli_real_escape_string($dbc, trim($_POST['image']));
$phone = mysqli_real_escape_string($dbc, trim($_POST['phone']));
$organisation = mysqli_real_escape_string($dbc, trim($_POST['organisation']));
$street = mysqli_real_escape_string($dbc, trim($_POST['street']));
$town = mysqli_real_escape_string($dbc, trim($_POST['town']));
$city = mysqli_real_escape_string($dbc, trim($_POST['city']));


if (!empty($firstname) && !empty($middlename) && !empty($lastname) && !empty($image) && !empty($phone) && !empty($organisation) && !empty($city)) {

$query = "INSERT INTO report (organisation, phoneNo) VALUES ('$organisation', '$phone');
  INSERT INTO person (firstName, middleName, lastName) VALUES ('$firstname', '$middlename', '$lastname');
  INSERT INTO identification (image) VALUES ('$image');
  INSERT INTO location (street, town, city) VALUES ('$street', '$town', '$city')";

$data = mysqli_query($dbc, $query);

if (mysqli_num_rows($data) == 0) {

mysqli_query($dbc, $query);
echo "Thank you, your report has been received.";

}

else {
        // An account already exists for this username, so display an error message
        echo '<p>This report already exists.</p>';
        $username = "";
}
}
else echo "Please enter all of the fields";
}

?>

<form id="report_sighting" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<h2>Report a sighting</h2>
<table>
<tr>
<td>
<label>First name:</label>
</td>
<td>
<input type="text" id="firstname" name="firstName" value="<?php if (!empty($firstname)) echo $firstname; ?>" />
</td>
</tr>
<tr>
<td>
<label>Middle name:</label>
</td>
<td>
<input type="text" id="middlename" name="middleName" value="<?php if (!empty($middlename)) echo $middlename; ?>" />
</td>
</tr>
<tr>
<td>
<label>Last name:</label>
</td>
<td>
<input type="text" id="lastname" name="lastName" value="<?php if (!empty($lastname)) echo $lastname; ?>" />
</td>
<tr>
<td>
<label>Upload Identification:</label>
</td>
<td>
<input type="file" id="image" name="image" />
</td>
<tr>
<tr>
<td>
<label>Contact phone number: </label>
</td>
<td>
<input type="text" id="phone" name="phone" />
</td>
<tr>
<tr>
<td>
<label>Organisation: </label>
</td>
<td>
<input type="text" id="organisation" name="organisation" />
</td>
</tr>
<tr>
<td>
<label>Street seen: </label>
</td>
<td>
<input type="text" id="street" name="street" />
</td>
</tr>
<tr>
<td>
<label>Town seen: </label>
</td>
<td>
<input type="text" id="town" name="town" />
</td>
</tr>
<tr>
<td>
<label>City seen: </label>
</td>
<td>
<input type="text" id="city" name="city" />
</td>
</tr>
<tr>
<td>
&nbsp;
</td>
<td>
<input type="submit" value="Report" name="report" />
</td>
</tr>
</table>
</form>

</body>
</html>

I've checked out the SQL statement and it's alright, so that leaves me with the PHP.

I would very much appreciate if anyone could help me out here,
thanks.

hello, anybody able to see what im doing wrong?

Code: [Select]
$id2=mysql_insert_id();
$year=$_POST['y'];
$yr=substr($year,-2);
$mth=$_POST['m'];
$init=$_POST['initial'];
$jobnumber=$yr.$mth.'-'.$id2.$init;

$query = "INSERT INTO jobs VALUES (
'',
'$id2',
'$_POST[initial]',
'$_POST[y]-$_POST[m]-$_POST[d]',date
'$_POST[contact]',
'$_POST[contactphone]',
'$_POST[customer]',
'$_POST[address]',
'$_POST[city]',
'$_POST[postal]',
'$_POST[province]',
'$_POST[description]'
)";
mysql_query($query) or die('Error, adding new job failed.  Check you fields and try again.');

echo "You have successfully entered a new job.  The job number is $jobnumber";

Hey guys,
it seems that so far in my little script everything is working except for the MySQL insert
Nothing seems to appear in the table it's supposed to insert too but i dont see any errors anywhere.

Any help would be appreciated.

I know it's very messy but it's my first actual 'project'
  Code: [Select]
<?php
$apiKey="<omitted>";
$playeritemsURL="http://api.steampowered.com/IEconItems_440/GetPlayerItems/v0001/";
$fullURL=$playeritemsURL."?key=".$apiKey."&SteamID=".$_GET["SteamID64"]."&format=xml";
$playerLocalName=$_GET["SteamID64"].".xml";
$ch=curl_init($fullURL);
$fh=fopen($playerLocalName, 'w');
?>

You entered ID: <?php echo $_GET["SteamID64"];?></br>

<?php
echo $fullURL;
curl_setopt($ch,CURLOPT_FILE,$fh);
curl_exec($ch);
curl_close($ch);
?>

</br>

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("csv_db", $con);
$readXML=file_get_contents($playerLocalName);
$xml=simplexml_load_file($playerLocalName);
$output=$_GET["SteamID64"].".defindex.txt";
$fh=fopen($output, 'w') or die("can't open file");
//echo $xml->items->item->defindex[0];
foreach ($xml->xpath('//defindex') as $defindex) 
{
fwrite($fh, $defindex."\n");
echo $defindex."</br>";
mysql_query("INSERT INTO ".$_GET["SteamID64"]." (defindex) VALUES (".$defindex.")");
} 
?>

Hello guys, this is my first post so sorry if I made any mistake   I need select record from one table and move to another table   But I get this message saying "Warning: mysqli_query() expects at least 2 parameters, 1 given in" I had that on line 158, but now i get on line 156   I start to do PHP and mysql few weeks ago, only respond i get from teacher is search and search.

<?php

				if (isset($_POST['username'])) 
				{
					$searchq = $_POST['username'];
					
					mysqli_query("SELECT * FROM login WHERE username='$searchq'")or die ("could not search");
					
			while($row = mysqli_fetch_array($con, $query)) 
			{
				$username = $row['username'];
				$password = $row['password'];
				$age = $row['age'];
				$phonenumber = $row['phonenumber'];
				$nationality = $row['nationality'];
				
					mysqli_query("INSERT INTO admin SET username ='$username', password='$password', age='$age', phonenumber='$phonenumber', nationality='$nationality'" ) ;
					echo"Data successfully inserted";
			}

				}
	?> 

When i search i see this type of code "$data = mysqli_query" add variable before mysqli   What should I do, to make it work. And send record from one table to another. Thank you

Hi everyone, I'm having real problems trying to retrieve database records in a 3 column layout, I got there eventually with a huge amount of help.

Unfortunately the code will only display records that are divisable by by three; for example for a database table that has 45 records there is no problem, as all records can be displayed in a 3 column layout. However if the table contains 47 records it won't display the 2 odd records.  My php skills are limited so I need all the help I can get.

I'm a bit desperate to sort this out for a project I'm doing, any help would be greatly appreciated - here is the php code:


$total = count($records);
  $nocol = 3;
  $norows = $total / $nocol;

for ($i=1; $i <= $norows; $i++) {
    $cell = 0;
    echo "<tr>";
    for($col=1; $col <= $nocol; $col++) {
       echo "<td>";
       if
       ($col == 1) {
       $cell += $i;
       echo '<strong class="navtext">'.$records[$cell - 1]['ret_name'].'</strong><br />';
       echo $records[$cell - 1]['ret_add1'].'<br />';
       echo $records[$cell - 1]['ret_add2'].'<br />';
       echo $records[$cell - 1]['ret_town'].'<br />';
       echo $records[$cell - 1]['ret_county'].'<br />';
       echo $records[$cell - 1]['ret_pcode'].'<br />';
       echo $records[$cell - 1]['ret_phone'].'<br />';
       echo $records[$cell - 1]['ret_email'].'<br />';
       echo $records[$cell - 1]['ret_web'].'<br />';
       } else {
        $cell += $norows;
       echo '<strong class="navtext">'.$records[$cell - 1]['ret_name'].'</strong><br />';
       echo $records[$cell - 1]['ret_add1'].'<br />';
       echo $records[$cell - 1]['ret_add2'].'<br />';
       echo $records[$cell - 1]['ret_town'].'<br />';
       echo $records[$cell - 1]['ret_county'].'<br />';
       echo $records[$cell - 1]['ret_pcode'].'<br />';
       echo $records[$cell - 1]['ret_phone'].'<br />';
       echo $records[$cell - 1]['ret_email'].'<br />';
       echo $records[$cell - 1]['ret_web'].'<br />';
       
       }
       echo"</td>";
    }
      echo"</tr>";
} 


I'm also trying to paginate the results, is this actually possible when using a three column layout?  I look forward to any suggestions.

I have been trying to work out how to get my results into a 3 column layout using css and not using tables in any way.

I found the code for tables:

echo '<table>'; 

$counter = 0; 
$cells_per_row = 3; 
while($row=mysql_fetch_array($result)) 
{ 
    $counter++; 
    if(($counter % $cells_per_row) == 1)  { echo '<tr>'; } 
    echo '<td>' . (whatever you echo from your $row array) . '</td>'; 
    if(($counter %  $cells_per_row) == 0) { echo '</tr>'; } 
} 
// just in case we haven't closed the last row 
// this would happen if our result set isn't divisible by $cells_per_row 
if(($counter % $cells_per_row) != 0) { echo '</tr>'; } 

echo '</table>'; 


How Can I adapt this or how should I use divs here?
I am fine with the css code, just need to work out how to get the 3 column layout correct in the loop.

while($row = mysql_fetch_row($query)) {

echo "<tr>";

echo '<td>' . $row[0] . '</td>';

echo '<td>' . $row[1] . '</td>';

echo '<td>' . $row[2] . '</td>';

echo '<td>' . $row[3] . '</td>';

echo '<td>' . $row[4] . '</td>';

echo "</tr>\n";
}
Currently I have this code. I would like to make it print certain text, let's say... 'car', if the value of table's column 'automobiles' is equal to 0. Otherwise - print the real value.
I've tried if statement and $one = $two... But that apparently didn't worked.

Thanks.

I'm wondering how to do this with javascript for a table that i have made in php and html.

I want to hide the row for the table based on the value inside my first column for each row of the table.

Like if column 1 has "apple" inside it, then the row would not be shown.
I'm pretty sure this can be done in javascript but i'm not a coding guy, so any help would be appreciated!

My table.php file that has the table i want to do this for:
Code: [Select]
<script language="javascript">

imageX1='plus';
imageX2='plus';
imageX3='plus';

function toggleDisplay(e){
imgX="imagePM"+e;
tableX="table"+e;
imageX="imageX"+e;
tableLink="tableHref"+e;
imageXval=eval("imageX"+e);
element = document.getElementById(tableX).style;
 if (element.display=='none') {element.display='block';}
 else {element.display='none';}
 if (imageXval=='plus') {document.getElementById(imgX).src='http://www.pvpstreams.com/icons/wowicon.png';eval("imageX"+e+"='minus';");document.getElementById(tableLink).title='Hide WoW';}
 else {document.getElementById(imgX).src='http://www.pvpstreams.com/icons/wowicon.png';eval("imageX"+e+"='plus';");document.getElementById(tableLink).title='Show WoW';}
}
</script>

<?php
$username="user";
$password="password";
$tmp="database";

mysql_connect(localhost,$username,$password);
@mysql_select_db($tmp) or die( "Unable to select database");
$query="SELECT * FROM users";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table class="sortable" id="wow" border="1" cellpadding="0" cellspacing="0" style="margin-left:auto;margin-right:auto;text-align:left">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Game</font></th>
<th><font face="Arial, Helvetica, sans-serif">Character</font></th>
<th><font face="Arial, Helvetica, sans-serif">Rating</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/xfirelogo.png">&nbsp;Status</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/xfirelogo.png">&nbsp;Link</font></th>
<th><font face="Arial, Helvetica, sans-serif">Realm</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/livestreamlogo.png">&nbsp;Status</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/livestreamlogo.png">&nbsp;Link</font></th>
<th><font face="Arial, Helvetica, sans-serif">Team&nbsp;Setup</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"wowcharacter");
$f2=mysql_result($result,$i,"username");
$f3=mysql_result($result,$i,"livestream");
$f4=mysql_result($result,$i,"wowserver");

$f5=mysql_result($result,$i,"wowplayer1");
$f6=mysql_result($result,$i,"wowplayer2");
$f9=mysql_result($result,$i,"wowplayer3");

$f7=mysql_result($result,$i,"wowrealm");
$f8=mysql_result($result,$i,"xfire");
$f10=mysql_result($result,$i,"xfirecheck");
$f11=mysql_result($result,$i,"wowrating");
?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<center><img src=http://www.pvpstreams.com/table-images/wowtable.png>"; ?></center></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<a class=blue href=http://$f4.battle.net/wow/en/character/$f7/$f1/simple>$f1</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f11; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "$f10"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<a class=blue href=http://www.pvpstreams.com/xfire.php?user=$f2>$f8</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f7; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php include("livestreamcheck.php"); ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<a class=blue href=http://www.pvpstreams.com/livestream.php?user=$f2>$f3</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<img src=http://www.pvpstreams.com/wclassicons/$f5.png><img src=http://www.pvpstreams.com/wclassicons/$f6.png><img src=http://www.pvpstreams.com/wclassicons/$f9.png>" ?></font></td>
</tr>


<?php
$i++;
}
?>
</table>