PHP - How To Display 20 Single Column Ul(un-ordered List) Values Into Row Wise. Single Row 4 Items And 5 Columns

I have several forms which will request the user to select one of several options where the most common choices will be pronounced, and might look something like:

Select Option A Select Option B Select Option C Select Option D Click here for more choices

The client is responsible to determine which ones to display (opposed to hiding within "more choices") and the server is responsible to provide the list of options along with some means to determine which ones are most common.

For a new user, the order will be based on my "best guess", however, whenever a user selects a given option its ranking for that user only should go up, and in addition more recent activities should have more bearing on the returned order.  In addition, there will be more than one of these lists and each of these lists will expose a public identifier (most will use a string but some might use an incrementing integer series) instead of the primary key.

I have some fragmented ideas how to best implement but would like other people's thoughts on how to best do so.

Starting with the list schema, undecided on which approach below.  Any preferences or something else altogether?

Solution 1:

abstract_list
- id (INT PK)
- discriminator (string)
- name (string unique with discriminator)
- ranking (TBD whether float or integer. This represents my initial "best guess")

list1 (list2, etc)
- id (FK to abstract_list.id)
- discriminator (FK to abstract_list.discriminator)
- public_id (string or integer based on specific list. unique with discriminator)

Solution 2:

abstract_list
- id (INT PK)
- discriminator (string)
- name (string unique with discriminator)
- ranking (TBD whether float or integer. This represents my initial "best guess")
- public_id (Application responsible to cast as string or integer. unique with discriminator)

list1 (list2, etc.  This class has no properties and only a method to cast the public ID as required.  Seems like a waste...)
- id (FK to abstract_list.id)

I will then add another table to join each list to the user.

user_list_ranking
- abstract_list_id
- user_id
- ranking (TBD)

To retrieve the list options, will query abstract_list and LEFT JOIN user_list_ranking and then sort on some mathematical formula acting on abstract_list.ranking and COALESCE(user_list_ranking.ranking, 0).

To promote recent activity, maybe increment user_list_ranking.ranking every time the user selects a given option and also decrement all other options of the associated list.  To prevent excessive windup, cap the the value to some max value (i.e. If list1 has a total of 10 records, cap it three times that value resulting in 30), and cap the minimum at zero.  Uncharted territory here and am very open to other approaches.

I am undecided whether I should just return an ordered array of the options, or also include either an order integer or some normalized value from 0 to 1.

If there is a common way to do this, please let me know what it is so I may mimic it.  If not, please provide any critique or recommended changes to my intended approach.

Thanks

I have the form:

==> MySQL version    5.0.91-community

So once upon a time I was working on a CMS.
I worked on it for 3 months, had to wipe my computer - but didn't worry about it because I backed up the files on a flash drive... which got smushed by some boxes when I moved <.< awesome -.-
Anyway, a year later (ie: today), I've decided to start again from scratch.

For me - for whatever reason - the simplest things always seem to give me the most trouble.

I decided to start with a "user" table - naturally - and began working on the first page: user_view.php and added an include file that connects to the database (connectDB.php). Since I started today, everything is simple - no design elements yet - just good 'ol code.

The View Users Page is simply a page that grabs all the rows from Table: users and prints the information to the screen, as if you were viewing a Members page on a forum.  This Page works fine. No complaints, does everything I need it to, prints all the rows and cols from Table Users.

Then I created the Edit User Page. When I did this a year ago, and I wanted to print out all the data from the table, I used the while loop. When I wanted to only grab certain variables from a table, I just created a new set of variables, as show below. Using the same method from a year ago, I started working on printing various data to the screen (such as "Welcome $username"). 5 minutes of typing... refresh page... nada.
So I stripped away just about every tag but the essentials and it still wouldn't work

Code: [Select]
<?php
...
$userID = 3;
$sql = "SELECT * FROM users WHERE userID='$userID'";
$result = mysql_query($sql);
$rows = mysql_fetch_row($result);

echo $rows['username'];
...
?>
Normally, this would just grab the username from a row in Table users where the userID = 3
But instead - it does nothing. I just see a blank page. It's a simple 5 lines of code and it's like "im just gonna do w.e the fk i wanna do mmmk thxforplaying"

 

PS: Keep in mind there is nothing wrong with the connection to the database, and as already stated I'm able to print ALL values from the Users Table using this same method: Code: [Select]
<?php
...
$user_sql = "SELECT * FROM users ORDER BY username ASC";
$user_result = mysql_query($user_sql);
while ( $user_rows = mysql_fetch_array($user_result) )
...
?>

Hey,

If i have a string which contains numbers and symbols... such as 1:2:4  (its not always : for the symbol it changes)


Is there a function that can convert the numbers that are 9 or less to have a 0 infront of them such as:

01:02:04

(also this is not timestamp format - just normal strings)

Hello everyone.

I'm new here and to php mvc. Been trying to hone my skills with mvc, mysql, classes and functions. But I am stuck. Can display all blog posts from DB but not a single post. The Readmore link only leads to post 1 (or the next published post from the db). Please I need your help. My code is below. Thanx in advance.

BlogsModel.php (PDO db):

public static function getBlog($blogsID) {

try {

$db = static::getDB();

$stmt = $db->query('SELECT *

FROM blogs

WHERE blogsStatus=1 AND blogsID=blogsID

');

$result = $stmt->fetch(PDO::FETCH_ASSOC);

return $result;

} catch (PDOException $e) {

echo $e->getMessage();

}

}

Blogs.php (Controller):

public function blogAction() {

$blog = BlogsModel::getBlog($blogsID = 'blogsID');

$user = BlogsModel::getBlog($blogsUserID = 'blogsUserID');

$data = [

'blog' => $blog,

'user' => $user

];

View::renderTemplate("Services/Blogs/blog.php", $data);

}

index.php (front controller):

$router->add('blogs/{id:[\w-]+}', ['controller' => 'Services\Blogs', 'action' => 'show']);

ReadMore link:

<a id="readMore" href="/blogs/{{ blog.blogsAlias }}" >ReadMore</a>

 

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.

My Php Buddies,

I have mysql tbl columns these:

id: 
date_&_time: 
account_activation_code: 
account_activation_status: 
id_video_verification_status: 
id_verification_video_file_url: 
username: 
password: 
primary_domain: 
primary_website_email: 
sponsor_username: 
 

Now, I want to display their row data by excluded a few columns.

Want to exclude these columns:

date_&_time

account_activation_code

account_activation_status

id_verification_video_file_url

password

 

So, the User's (eg. your's) homepage inside his account should display labels like these where labels match the column names but the underscores are removed and each words' first chars CAPITALISED:

Id: 1
Id Video Verification Status: 1
Username: requinix
Primary_domain: requinix.majesty
Primary Website Email: requeen@requinix.majesty
Sponsor Username: phpsane
Recruits Number: 2

 

For your convenience only PART 1 works. Need help on Part 2

My attempted code:

 

	PART 1
	<?php 
	// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
	// Query to get columns from table
$query = $conn->query("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'members' AND TABLE_NAME = 'users'");
	while($row = $query->fetch_assoc()){
    $result[] = $row;
}
	// Array of all column names
$columnArr = array_column($result, 'COLUMN_NAME');
	foreach ($columnArr as $value) { 
echo "<b>$value</b>: ";?><br><?php 
} 
	?>
	 
	PART 2
	<?php 
	//Display User Account Details 
echo "<h3>User: <a href=\"user.php?user=$user\">$user</a> Details</h3>";?><br> 
<?php 
$excluded_columns = array("date_&_time","account_activation_code","account_activation_status","id_verification_video_file_url","password"); 
foreach ($excluded_columns as $value2) 
{    
    echo "Excluded Column: <b>$value2</b><br>";
}
foreach ($columnArr as $value) 
{ 
    
    if($value != "$value2")
    { 
        $label = str_replace("_"," ","$value"); 
        $label = ucwords("$label"); 
        //echo "<b>$label</b>: "; echo "$_SESSION[$value]";?><br><?php 
        echo "<b>$label</b>: "; echo "${$value}";?><br><?php 
    }
} 
?>
	

PROBLEM: Columns from the excluded list still get displayed.

Edited November 19, 2018 by phpsane

Is there a way to take data that is listed like a,b,c,d,e and turn that into an unordered list?

Basically, I'm going to have a list of schools that will be listed with comma separators.  I'll print that data out in two places, one will be printed as it's in the database.  The other I would like to echo as an unordered list.

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.

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

Could somebody please point me in the right direction....

I want to block the US, AUS, NZ, CAN, IRE from the index.php of my site. But not the rest of the site.

The following site (like many others) provides a pretty neat list for the htaccess http://www.ipinfodb.com/ip_country_block.php

I did a test. I got the list for blocking the UK. After copying the UK list to my htaccess i couldn't view my site.

The thing i don't get is... my ip address was not in the list but i was still blocked,

The 1st 2 sets from my ip are '2.100'

The only ip's in the list starting with 2 a
deny from 2.24.0.0/13
deny from 2.96.0.0/13
deny from 2.120.0.0/12
deny from 2.136.0.0/13

How exactly is this all working? And what's the best way of blocking the above countries from just my index.php?

Any links to manuals or anything here would be great...


Thank You.

John

Greetings,

I'm trying to execute a shell command with a user-supplied password as input.  The password may contain apostrophes and and virtually any other character.  Unfortunately, when using escapeshellarg(), the password argument is interpreted as two separate arguments, as escapeshellarg() will handle apostrophes (single quotes) by breaking out of the already quoted text and using a backslash escape.


$password = escapeshellarg("ex'ample!%");  // The password will actually be supplied by an HTML form.

$command = ('echo '.$password);

echo "$command";

// Returns 'ex'\''ample!%'


Does anyone have any input on how to accomplish what I'm trying to do?  I'd like to allow obscure passwords without disallowing specific characters, while still being "safe" in passing the information to a shell command.  Double quotes would work for passing single quotes, but I'm afraid I might break other characters there.

Thanks.

Greetings,

I'm looking for a way to pass a query string (from page1) as part of a query string (to page2) as a single key=>value pair. The idea is the use the query string to return the user to the previous page after the action has been completed.

query results[page1]->view record/action selection[page2]->back to results[page1]

I'm sure someone has been down this path before. P.S. the script is all contained within one file, thus the filename.ext is already known.

Thanks

hello.

I have some oop code that pulls information about a page out of a mysql db but i dont want to put the code on every page. Instead in want to put it in the a function and pass it back to each page.

do i put it in a function in my functions.php file or can i put it into my includes/pages.php includes file ??

the code looks for the page name on the page and then pulls that pages info from the db.
this code works on the page - home.php

Code: [Select]
<?PHP
require_once("../includes/initialize.php");

$currentPages = Pages::find_all();

$pName = "adminHome";

$page_id = "";
$visible = "";
$pageZones = "";
$pageCRUD = "";
$pageTypes = "";
$module = "";
$title = "";
$sub_title = "";
$description = "";
$image = "";
$about = "";


foreach($currentPages as $currentPage){

$page_id = $currentPage->id;
$pageName = $currentPage->pageName;
$visible = $currentPage->visible;
$pageZone = $currentPage->pageZones_id;
$pageCRUD = $currentPage->pageCRUD_id;
$pageType = $currentPage->pageTypes_id;
$module = $currentPage->module_id;
$title = $currentPage->title;
$sub_title = $currentPage->sub_title;
$description = $currentPage->description;
$image = $currentPage->image;
$about = $currentPage->about;



if($pageName == $pName){

echo $pageName.'<br/>';
echo $page_id.'<br/>';
echo $visible.'<br/>';
echo $pageZone.'<br/>';
echo $pageCRUD.'<br/>';
echo $pageType.'<br/>';
echo $module.'<br/>';
echo $title.'<br/>';
echo $sub_title.'<br/>';
echo $description.'<br/>';
echo $image.'<br/>';
echo $about.'<br/>';
}
}
?>

i would like to be able to just put global $page or something like that to get all the db info for each page.


i tried this in my  includes/pages.php includes file but it cant get the page name.

Code: [Select]
public static function find_by_pageName(){
global $database;
global $pName;

$sql = "SELECT * FROM ".self::$table_name." WHERE pageName=".$pName."";
$result_array = self::find_by_sql($sql);
return !empty($result_array) ? array_shift($result_array) : false;
}



any suggestions ???? whats the best way to do this ?

thanks
ricky