• Member Avatar for alan.davies
    alan.davies

    Replied To a Post in This is me venting

    Just checked-in out of interest after a long time away. Glad to see a lot of old friends still active here. Then I came across this post. It upset me …
  • Member Avatar for alan.davies
    alan.davies

    Began Watching This is me venting

    This is definitely not a targeted attack at *anyone*. Please take it just as me having a bad day and venting. I'm kinda tired of people constantly telling me that …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in Making pagination with php and mysql

    [https://www.daniweb.com/programming/web-development/tutorials/499320/common-issues-with-mysql-and-php#post2183865](https://www.daniweb.com/programming/web-development/tutorials/499320/common-issues-with-mysql-and-php#post2183865) Item #6 'Twas an old post of mine, possibly still useful.
  • Member Avatar for alan.davies
    alan.davies

    Began Watching Making pagination with php and mysql

    I'm making a movie website and want to make the limit of movies for example 10 per page but every pagination tutorial or guide I find shows only how to …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in PHP laravel framework

    Sorry, bit late with reply. Laravel used to be really lightweight, easy to set up and go. It's still a great product but as it's continued to develop, so the …
  • Member Avatar for alan.davies
    alan.davies

    Began Watching PHP laravel framework

    Is there anyone who have tried the Laravel framework, is it worth starting to study it?
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in Hello all, again

    Hi P! Wondering if you'd pop over again :) Nice to hear things going well for you. I pop in maybe once a month these days, Cheers diafol (I deleted …
  • Member Avatar for alan.davies
    alan.davies

    Began Watching Hello all, again

    It's been a while ;) Still very busy, but hoping to pop in on a regular basis. How's everyone been?
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in pivoting without Aggregate function

    May be my display, but I can't see any tags so not sure which rdbms you're using. Each flavour of sql deals with different syntax. Also need an idea of …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in pivoting without Aggregate function

    Why do you need to avoid aggregate functions? What data are you trying to pivot? No info supplied so it's v difficult to help you.
  • Member Avatar for alan.davies
    alan.davies

    Began Watching pivoting without Aggregate function

    How to use pivoting WIth join of 3 tables without Aggregate function within it
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in question pertaining to sessions and cookies

    The server will store "session cookies" and check against that. It doesn't matter if you do from accessible to limited access pages. Every page should have a session_start(); usually at …
  • Member Avatar for alan.davies
    alan.davies

    Began Watching question pertaining to sessions and cookies

    hi everyone! I am wondering if anyone can point me in the right direction regarding cookies and sessions. What I need to know is this; I am developing a website …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in Radio buttons value reset in database with Ajax and php

    Depends how you are storing the data. If a person has to log in then you search for the users id in the table. If it doesn't exist, add the …
  • Member Avatar for alan.davies
    alan.davies

    Began Watching Radio buttons value reset in database with Ajax and php

    Hi everyone! i have a question that, if there are two radio buttons Male and Female, if some select male,this value will be store into database, but if he select …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in How to Create Relational Database Table to Show data from Subcategory?

    This is like a menu submenu system... https://www.daniweb.com/programming/web-development/tutorials/499320/common-issues-with-mysql-and-php#post2183865 Item #10
  • Member Avatar for alan.davies
    alan.davies

    Began Watching How to Create Relational Database Table to Show data from Subcategory?

    This is the process I want to attain: 1. I have 4 buttons 2. Each 4 buttons have categories under it 3. When those categories is selected it shows list …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in Can I learn web Development all by myself?

    I set up my own webdev business - full stack LAMP development. Never took a paid course. You build things up incrementally over years, learning the limitations and foibles of …
  • Member Avatar for alan.davies
    alan.davies

    Began Watching Can I learn web Development all by myself?

    I have been thinking about getting into web development. So far, i have been able to absord lots and lots of information about HTML, CSS and Java... But there is …
  • Member Avatar for alan.davies
    alan.davies

    Gave Reputation to rproffitt in Some feedback on the design

    @alan.davies, busted. Photo evidence at https://imgur.com/gallery/x8nJN
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in Some feedback on the design

    >Click literally anywhere except for the avatars :) Clicking on reply count goes to last post in the thread. Anywhere else to the first post. Yes I understand, but two …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in displaying multiple values of single cookies

    We can't copy and paste screenshots in order to test your code. Please paste your code
  • Member Avatar for alan.davies
    alan.davies

    Began Watching displaying multiple values of single cookies

    i have a problem in displaying the values of a cookie dynamically code goes as... <?php $x=array(); include("connect.php");//database connection file $temp=$_GET['id']; setcookie(count($x)+1,$temp); echo $_COOKIE['$x[1]']; ?> // how do i display …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in Create Crystal Report using PHP, Mysql

    Probably best to start your own thread. A 12 year old well dead thread ain't going to attract much attention. Seeing as you also posted this to stackoverflow: https://stackoverflow.com/questions/56817045/using-crystal-report-with-php Let …
  • Member Avatar for alan.davies
    alan.davies

    Began Watching Create Crystal Report using PHP, Mysql

    Hi Pls tell me how to create a Crystal Report in php, mysql using com component Thanks in advance Arry :rolleyes:
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in QR Code generate using PHP MYSQl by fetching data from database row by row

    You are duplicating HTML fields instead of setting them up as an array: <td><input type="text" value="<?php echo $row['student_id']; ?>" name="student_id" ></td> <td><input type="text" value="<?php echo $row['fname']; ?>" name="fname" > Try …
  • Member Avatar for alan.davies
    alan.davies

    Began Watching QR Code generate using PHP MYSQl by fetching data from database row by row

    Hello Experts! I am stuck here while generating QR Code using php sql. Basically I am generating code for students using their ids and other information while fetching data from …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in Some feedback on the design

    Like previous iterations, too many hidden features. How to do this or that should be obvious eg esc for full page editor. Not that intuitive. Hate trying to get to …
  • Member Avatar for alan.davies
    alan.davies

    Began Watching Some feedback on the design

    Hi all, I haven't used the forum for a while so lot of the functionalities are new to me and I have to admit I found some of them really …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in Images upload help

    OK for this you need to have a new table. Let's call it game_images for now. You will need a minimum of three fields: id (pk) , game_id (fk), filename. …
  • Member Avatar for alan.davies
    alan.davies

    Began Watching Images upload help

    I am learning database and php I have made a database with a list of my game collection with the following fields, 1. ID 2. game_name 3. game_year 4. platform …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in Check user permission to a php page and display an error

    <?php session_start(); if (!isset($_SESSION["username"])) { header("userLogin/?notloggedin=true"); //may need to use absolute or different relative address exit; }elseif($_SESSION["user_group"] !== 'admin') { header("whateverPage/?notadmin=true"); //may need to use absolute or different relative address …
  • Member Avatar for alan.davies
    alan.davies

    Began Watching Check user permission to a php page and display an error

    I am using the following code to check the user permission (User Role). This is to check whether the user is logged in or not <?php session_start(); if (!isset($_SESSION["username"])) { …
  • Member Avatar for alan.davies
    alan.davies

    Marked Solved Status for Update on DW usage

    Just wondering how DW is doing re posts. I pass by from time to time and peruse the webdev forum. Apart from code snippets from Dani, I see very little …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in Update on DW usage

    OK thanks guys :)
  • Member Avatar for alan.davies
    alan.davies

    Created Update on DW usage

    Just wondering how DW is doing re posts. I pass by from time to time and peruse the webdev forum. Apart from code snippets from Dani, I see very little …
  • Member Avatar for alan.davies
    alan.davies

    Began Watching Update on DW usage

    Just wondering how DW is doing re posts. I pass by from time to time and peruse the webdev forum. Apart from code snippets from Dani, I see very little …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in How do solve this error

    Is that it? No code? Show your relevant code and on which does this happen.
  • Member Avatar for alan.davies
    alan.davies

    Began Watching How do solve this error

    Parse error: syntax error, unexpected '||' (T_BOOLEAN_OR) in php pdo
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in Error in php project

    >Then again if line 6 fails so will 7. OP needs to test for that. That was my point. I believe Line 6 is returning 'false'. From the manual on …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in Error in php project

    While I like the oop method, I can't see anything wrong with the procedural code other than I'd enclose the whole thing in a conditional. As in `if($q =....) `
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in Error in php project

    I'm assuming mysqli query is returning false, hence the boolean msg.
  • Member Avatar for alan.davies
    alan.davies

    Began Watching Error in php project

    Please suggest something ---- Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\tourtravel\index.php on line 14** <?php include 'header.php'; include 'slider.php'; ?> <div class="container" > <div class="row"> …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in Help! - ability to hide/show (toggle) on PHP/MySql Database

    What type are your users? Causual browsers or registered users? Both? This can direct your solution. If you have registered users, then DB storage would be the preferred method, as …
  • Member Avatar for alan.davies
    alan.davies

    Began Watching Help! - ability to hide/show (toggle) on PHP/MySql Database

    Hello everyone, I am new to this daniweb community and I really hope you guys will help me with this as I am baffled at what I couldn't come up …
  • Member Avatar for alan.davies
    alan.davies

    Gave Reputation to ariowishnu in missing leading zero id from db using ajax

    the problem solved , it was the quotes that must surround all part of number. so reffer to article that i found in internet just add backslash. $id = $row['nip']; …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in How to use more than one form action URL in PHP?

    As webmachine states send the form to one file and then send data onwards from there once everything has been validated and cleaned. If you need the data to perform …
  • Member Avatar for alan.davies
    alan.davies

    Began Watching How to use more than one form action URL in PHP?

    I need to add couple of php page as from action like, <form action=“one.php”, “two.php” method=“POST”> The code above is not working, how can i use more than one form …
  • Member Avatar for alan.davies
    alan.davies

    Replied To a Post in how to handle multiple resultset in php & mssql

    How about you repost your code as a proper code block?
  • Member Avatar for alan.davies
    alan.davies

    Began Watching how to handle multiple resultset in php & mssql

    I have a sp in mssql which gives multiple resultsets.I need to display the result in html table using php . I am using mssql_fetch_assoc() & mssql_next_result(). How to store …

The End.