anthonyjpv

Hi! 1. Whats the difference between using these PL/SQL records? -Table Based -Cursor Based -Programmer Based 2. Whats the importance of using PL/SQL Table? 3. Whats the importance of using VARRAYS? 4. When to use these 3 RECORDS, TABLES, VARRAYS Thanks!

Hi! Im kinda new to c# devt I used to do a php project and Im wondering if theres anyway sql commands in php have comparable commands in c# for example if I wanna read a data in php I use $query = "SELECT * FROM table"; then execute that …

After INSERTing record(s) to payments_table (from paypal IPN), $query = "SELECT sum(payments) FROM payments_table WHERE customer_id='{$customer_ID}'"; $result = mysql_query($query); //get the value from result here $query = "SELECT customer_id FROM discounts_table WHERE customer_id='{$customer_ID}'"; $result = mysql_query($query); //if row > 1 //loop until reached a certain condition THEN genarate a NEW …

Hi! I have a table for payments what I want to accomplish is: once a certain customer Id reached a certain amount by his accumulated payment, it will trigger an insert into statement to my discount table to generate a code specifically for him. i understand thats trigger is only …

Hi! Part of my website development is being able to recover a password and upon reading the owasp page i found out that the best one is having a temp password and an expiration my customers table doesnt have a date column nor temp pw column do I have to …

If php file cannot be viewed from users browser, what are the advantages and disadvantages of having to process a form in same php file or processing a form with a different script? ie mail_form.php or with process_mail.php thanks!

Hi! Could someone show me how to implement swap algorithm in php and mysql? ie: I have 4 records in a table each are sorted by column position say position 1 2 3 4 if I move an existing position from 4 to 1 number 1 will be moved to …

Im trying to swap the values if taken already but its not working heres the code: [CODE]<?php ob_start(); require_once("../session.php"); require_once("../functions.php"); require_once("../../includes/connection.php"); include_once("../../includes/header.php"); confirm_logged_in(); if(isset($_GET['cat_id'])) { $category_id = $_GET['cat_id']; $result = get_specific_category($category_id); while($row = mysql_fetch_array($result)) { $category_name = $row['category_name']; $position = $row['position']; $visible = $row['visible']; } } if(isset($_POST['Submit'])) { $errors = …

Hi, I have a pretty quick question regarding PHP code if script is hidden from client's browser and php code are rendered back as HTML to the user is there a way ever that someone can view your code using say a browser plugin? or getting your source file and …

Hi! I dont know if this possible I have a payments table in a database what I want to accomplish is, once a certain customer id has paid say $100 USD my discounts table will generate a code for me automatically say I'll insert a new record is there such …

Aside from sql injection if I sanitize data before querying or sending it to a database are there any issues that needs to be addressed concerning security of a web app? im building an e commerce from scratch as part of a school project using notepad++ and xampp. any recommendations? …

my goal is when user adds a product thats already in the cart, it will retain the product name and it will add 1 to the current quantity my code is: [CODE]$item_found = false; $index_of_array = 0; if(isset($_POST['product_id'])) { $product_id = $_POST['product_id']; if(!isset($_SESSION['cart_array'] ) || empty($_SESSION['cart_array'] )) { $_SESSION['cart_array'] = …

im making a small web app as e-commerce site im storing the product id selected by a visitor into session product id as an array now what i want to accomplish is: also store the quantity associated with the product selected and then update that sessions for quantity if visitor …

Im building a shopping cart for every product that is clicked, i append them to $_SESSION['product_id] and put comma so if producct 1 is clicked, the value of the $_SESSION['product_id] is 1 then if producct 2 is clicked, the value of the $_SESSION['product_id] becomes 1,2 and then I explode the …

if I use session in a web app can I be assured that every guest who visits the site has a unique session id? and for example I use a rand() to generate and store a $_SESSION['customer_id'] can I be assured that every set of rand() is also unique? say …

I have set my table to InnoDB which has parent to child relation table 2(child) has FK Reference to table 1 (parent) PK table 2 has cascade on update and delete I am trying to insert a record in table 2 which PK doesnt exist yet in table 1 my …

Im building a very small website which has an admin and public area what i want to know is your prefence when it comes to reporting or logging ie. when admin or user insert, update, delete, from and to the database changes will be written to either a database or …

Hi! Im changing my database engine from MyISAM to InnoDB its because I learned online that if I were to use FK's that its more likely that I have to use InnoDB my question is: if I have a one-to-many relationship tables: ie. one PK in table 1 can have: …

Hi! I need to know if theres a function that is simmilar to mysql_insert_id function where it gets the last inserted id but the thing is my id is not auto increment i tried doing the select statement but not working my scenario is: i am updating a record from …

I know that php can validate data input before querying to the database but which is more preferable by the developer or user experience? validation thru php? or validation thru javascript? whats your insight about this? thank you!

Hi i wan to start an application but without showing its window Thank you

I want to be able to insert and update 2 different tables at the same time heres the scenario: if i insert a new record, the it will create a primary key for me as auto increment then once that primary key is created, I want to use that to …

Database query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 [CODE]<?php ob_start(); require_once("includes/connection.php"); include_once("includes/header.php"); //get category id according to selected record $category_id = $_GET['cat_id']; //fetch data to populate …

Im building a simple yet robust small e commerce site what i wanna know is: is it more safe and secure to add the mysql commands such as select add update delete in the same html form or create another php file for that as a process? example: i have …

Hi Im new to php programming as part of my academics, Im building an e-commerce website can you give me some tips on how to build robust site?

[B]i dont know why i am having an error in [B]header[/B] Warning: Cannot modify header information - headers already sent by (output started at delete.php on line 13[/B] [B]delete.php [/B] [CODE]<?php include("db.php"); $id =$_REQUEST['BookID']; // sending query mysql_query("DELETE FROM books WHERE BookID = '$id'") or die(mysql_error()); header("Location: index.php"); ?> [/CODE] …

Hi! im new to php programming im trying to output the file image uploaded to a directory in localhost im using xampp i tried several things im unable to get image displayed it shows only blank page if not it shows a very small icon which indicates that pic cannot …

What is the difference between "[CODE]return[/CODE]" and "[CODE]messageBox.Show("whatever")[/CODE]"? Also explain(efforts will be appreciated): What does [CODE]retern[/CODE] do?

I have a form with a recordset which is filtered on some controls on the form. In the code behind page I want to loop through the records as filtered on the form. I can set up another SqlDataSource and refilter it on the same controls, but I'm wondering if …

I want to figure out how this loop sequence how would the computer execute this loop by going through all the steps in the picture attached.