PHP - Single Page Problem

PHP script return 20 UL LIST values like,

< ul >

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T

< /ul >

How to display UL LIST into row wise 5 columns like

A B C D
E F G H
I J K L
M N O P
Q R S T (20 ITEMS)

Edited December 7, 2019 by aveeva

Hi, I'm trying to type in a name of a song into an input field, for example:
I'll Be Missing you

This field is captured through $_POST and set to a variable $title

I then update the table with this new title. Once it is updated, all that is shown in the data is:

I

The single quote, and anything after it is gone completely.
Here is my query. How can I change this so it includes the single quote and everything after it?

$sql = "UPDATE sheets SET artist = '$artist', title = '$title', active = '$activestatus' WHERE id = $value";
        $result = mysql_query($sql) or die(mysql_error().'<br>'.$sql);  

If more code is required to understand what I'm talking about, let me know.

Hi, I've been scratching my head for a while now about how to do this, I'm relatively new to php and mysql and perhaps foolishly taking on creating a user area for a website.  I have everything else working, all of my register account functions and confirmations and all of the login scripts etc. 

I have created a profile page which returns various information to the user (this bit works fine) and I've got some nice show/hide toggles running with some javascript/css but my intention is to allow the user to change thier information (e-mail address, contact phone number and also whether they are subscribed to the e-mail list), it also displays any support tickets or messages.

So after the long intro, here's what I'm struggling with...  I have a form in a visibility toggled <div> which submits a 'change_email' script, so a user wants to change their e-mail, clicks on change, the <div> appears, they bang in the new e-mail and hit submit.

My php script appears to work (because it doesn't throw up any errors), until you realise that actually it's not updated the record in the db...

I'm using mysql_query("UPDATE users SET email='$new_email' WHERE username='$user'");

Do I need to setup variables for all of the information in the db (name, username, password, email, contno etc etc) and include them in the command to get it to work or should that just pick the correct record and then update it? If that is the case is there a way I can include 'blank' variables so I don't have to set them all up...

e.g.  mysql_query("UPDATE users SET user='',password='',email='$new_email', etc WHERE username='$user'");

Many thanks in anticipation

I'm so sorry for this question but I not really know how to play with single and double quote.

If I have a query like this:

Code: [Select]
  mysql_query('UPDATE table SET Status=1,Sending=Done WHERE ID IN ('.implode(',', $done).')');
And I wish to add Code: [Select]
SentAt='$date' in the query as well , and I try this:

Code: [Select]
  mysql_query('UPDATE table SET Status=1,Sending=Done,SentAt='$date' WHERE ID IN ('.implode(',', $done).')');
Not working...how should I write it?

Thank you.

About a year ago I wrote a mod_rewrite in at sites htaccess file.  It was to call a page that queried the database based on a unite code that was assigned to a member.  If the member was assigned a code that was FL1001, the URL www.marketingteammates.com/FL1001 would bring up a page that quaried that member and displayed their database content.   In the users table of the site, it quaried the field webPageID and the information was called.  It called a page webpage.php that quaried the info.  The URL in the address bar still displayed www.marketingteammates.com/FL1001.  Here are the lines of code in the htaccess file.

RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^([A-Za-z])([A-Za-z])([0-9]+)$ /webpage.php?webPageID=$1$2$3 [NC,L]

I now have a second page completely different from the webpage.php.  It is a page storeNumber.php and would query a field storeNumberID.  This field could contain any kind of string such as Store#101, or mystore101, or #101 is my store.   I tried using the same rewite rule just replaceing the webpage.php and variable with storeNumber.php and $storeNumberID.   This doesn't work.  It also leads me to wonder if there can even be two different pages in the mod_rewrite.  How would it diferentiate one from the other.   Thanks for any help in advance.   Mike

Hi,

I'm trying to delete a string that's single quoted. From: Cyto's to Cyto, but doesn't work. It works when I add 's to the string with stripslashes, but I can't seem to delete a quote from a string.
Does someone know how?

My $_post code:
Code: [Select]
$name=mysql_real_escape_string(stripslashes($_POST["ename"]));
Cheers

How to pull just I record of a column out of the 20 columns? This is not showing the results.

$SomeVar = 'pets';
$query =  "SELECT field1 FROM db1 WHERE id1 = '".$SomeVar."'";
$results=mysql_query($link);

echo $link;

So I'm rebuilding an existing joomla component in laravel and this time I want to get it right. Hopefully my explanation is not too complicated.   I have this situation:   I have an order. The order has many products. The product has many parameters in the form of input fields such as radio, select list and text (think of color, size, engraving, logo select). An order also has some parameters such as address etc.   My question is how I should structure this considering the following:   1. The parameters of either an order itself or a product can change from time to time. Sometimes I need to add several fields for a certain amount of time. 2. Each product has 1 or more production pages (production steps) where some of the parameters set by the order need to be visible. Each production step has its own set of parameters (3d model, logo file). This means that the step1 page should show its own parameters INCLUDING a predetermined set of product parameters. So the columns could look like this: color - engraving - logo select - 3d model - logo file. 3. Each production page lists all the products belonging to that step. 4. Each product can belong to 1 or more production steps. 5. A product is only visible at 1 step at a time. The steps have a specific ordering.   A little note: it's not a usual webshop, but rather we sell custom sports products. Currently we have 3 products where 1 product has 2 production steps and another has 3 production steps.   Don't get me wrong, I have a working application for this, but currently it's just a database mess. The application kept growing as per bosses request so thinking it through was not possible  at the time.

Having a problem with my website I just can't resolve - guess it is quite simple but have been trying to sort it for 3 days without success!!

I have used PHP instead of HTML frames, which has been brilliant except for the Home / Welcome page. For some reason the fonts are different on this page when I enter the site www.field-herpetology.co.uk and one of my photos is not displayed but the url does appear correct. If you enter the (half finished) site you will see the font is different from all other pages despite pointing at the same CSS style sheet. If you then click on the "Welcome" hyperlink everything displays as it should do but this is the same page it is pointing to....what have I done wrong??

If someone could spare two minutes to check the site any information would be gratefully received...many thanks in advance.

Tone

Hay wut's happening forum?

so i am currently working on a mailing list and its function is to send EVERY single user a notification email once an entry they are looking for on a database is available

below is the mailing_list.php which sets up database connection and deals with the fields of the table:




<?php
include('view_function.php');
global $connect;
$connect = mysqli_connect("localhost", "", "") or die(mysqli_error($connect));
$error = mysqli_error($connect);
$db_select = mysqli_select_db($connect, "");

$select5 = "SELECT LS_CELL_TYPE FROM link_specificities
INNER JOIN links ON link_specificities.LS_LINK = links.L_ID
WHERE links.L_ID = $LinkID";
$get5 = mysqli_query($connect, $select5) or die(mysqli_error($connect));
while ($row5 = mysqli_fetch_array($get5)){

extract($row5);

$cellType = $row5['LS_CELL_TYPE'];

}

$select6 = "SELECT CT_NAME FROM cell_type WHERE CT_ID = '$cellType'";
$get6 = mysqli_query($connect, $select6) or die(mysqli_error($connect));

$i = 0;
while ($row6 = mysqli_fetch_array($get6)){

extract($row6);

$query[$i] = $row6['CT_NAME'];
$check = "select first_name, email from mailing_list WHERE query = '$query[$i]'";
$i++;
echo $query;
}
update($check);

?>




And below is the view_function.php that's included above:





<?php

function update($check){
global $query;
global $connect;
global $LinkID;

$result = mysqli_query($connect, $check) or die(mysqli_error($connect));

while ($row3 = mysqli_fetch_array($result)){

extract($row3);

$fname = $row3['first_name'];
$email = $row3['email'];

$to = "$fname <$email>";
$subject = "The query is updated.";
$headers = "From: asdfasdfasdf";
$body = "
Hello $fname,\r\n\nThis is to inform you that $query is updated, please go to this link to search for it:\r\n\nhttp:/asdfasdfasdfasdf/view/View.php?LinkID=$LinkID \r\n\nRegards,\r\n\";
if(send_email($to,$subject,$body,$headers)){
//there are no errors, return empty array
$errors = array();
} else {
$errors[] = "Server error, mail could not be sent.";
}

}
}
?>




As you can c in mailing_list.php, i echoed out $query, but it only echoed ONE result of that entire array

so wut i am trying to do is to make a while loop with a counter in it, but still only one result shows up

Basically, i want the $query to output all items in an array so that following SELECT statement can choose the item which matches the required query and send the users the notification email bout such particular query

How should i fix it in order to do just that?

thanks   

I was talking to some friends, who are just as new as me in programming, and they think it would be better to use a single navigation file for every link in a web site.

Something like this:

Code: [Select]
<a href="nav.php?id=home&otherparams" >Home</a>
<a href="nav.php?id=products&otherparams" >Products</a>
<a href="nav.php?id=contact&otherparams" >Contact</a>
I told them I think this might be easier to maintain, but also might take up on loading time, as the site viewer will have to go through an extra node to get where he wants.
Is this single navigation file a good practice or should it be avoided?

Thanks for any comments...

I need to get the 2nd code working. Please help.

This works
$query = "SELECT DISTINCT addressz FROM abs WHERE statez = 'AZ'";
$results = mysql_query($query);

But this dosen't.
$SomeVar = $_POST['disloc'];
$query = "SELECT DISTINCT addressz FROM abs WHERE statez = '".$SomeVar."' ORDER BY addressz ASC";
$results = mysql_query($query);

This topic has been moved to Third Party PHP Scripts.

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

I want to use all five results separately in order to use in a Jquery slider.

Code: [Select]
<?php
           $a = "SELECT * FROM blog_posts ORDER BY id DESC LIMIT 5";
   $query = mysql_query($a) or die (mysql_error());
           $query_results = mysql_fetch_array($query);
?>

I know if i was going to grab vars from an normal array i would just use...

Code: [Select]
<?php echo $array_reults['0'] ?>

Can any one help me with this problem?

Hi all,

Just to check if it is possible to have 2 while loops in a single code? Below are my codes.


SQL code

$tutor_id = mysqli_real_escape_string($dbc, $_GET['tutor_id']);
    $query = "SELECT tl.level_id, tl.level_name,
                     ts.subject_id, ts.subject_name, tsl.subject_level_id, 
                     IF(tosl.tutor_id='{$tutor_id}', 1, 0) as checked
              FROM tutor_level AS tl
              INNER JOIN tutor_subject_level AS tsl
                  USING (level_id)
              INNER JOIN tutor_subject AS ts
                  USING (subject_id)
              LEFT JOIN tutor_overall_level_subject AS tosl
                  ON tosl.subject_level_id = tsl.subject_level_id
                  AND tosl.tutor_id = '{$tutor_id}'
              ORDER BY tl.level_id, ts.subject_name";
    $sql = mysqli_query($dbc, $query) or die(mysqli_error($dbc));

$query1 = "SELECT tl.level_id, tl.level_name,
                     IF(tslvl.tutor_id='{$tutor_id}', 1, 0) as checked
              FROM tutor_level AS tl
              LEFT JOIN tutor_selected_level AS tslvl
                  ON tslvl.level_id = tl.level_id
                  AND tslvl.tutor_id='{$tutor_id}'
              ORDER BY tl.level_id, tl.level_name";
    $sql1 = mysqli_query($dbc, $query1) or die(mysqli_error($dbc));

PHP code (2 while loops)

//Process the results
    $checkboxes = ''; //Create variable for output
    $current_level_id = false; //Flag to check when records change level
   while($data = mysqli_fetch_array($sql)) //Iterate throug the DB results
    {
        if($current_level_id != $data1['level_id']) //Determine if this level is different from the last
        {

print_r ($data);
            $checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);
            $current_level_id = $data['level_id'];
            $subject_data = array();
        }
        //Add the current record to the $level_data array
        $subject_data[] = $data;
    }

//$checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);

while($data1 = mysqli_fetch_array($sql1))

{

print_r ($data1);

$checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);
            $level_data = array();

$level_data[] = $data1;

}

    //Call the createLevelCheckboxes() function to generate the HTML for the LAST level records
    $checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);